Asterisk Patch crashes Query

**joschi05fan** · 2006-07-13, 08:04 AM

hi @ all,

i have one problem after aplying the asterisk patch 1.2.
here is how i done it.

i'm working with sugar 4.0 updated with all patches to 4.2.1. after installing the patch to 4.2.1 i applied the asterisk patch 1.2. there were no errors that occured during the installation.
but when i tried to go to a detailview site the following error occured:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND' at line 1

since i'm not very firm with fixing query, can you please help me.

after the problem occured i deinstalled the asterisk patch, but the error still appears.

my sugar is a testing version on xamp for linux
linux ubuntu
php4
apache2
firefox 1.5.0.4

please help

joschi

**joschi05fan** · 2006-07-17, 01:29 PM

***push****
does no one has any idea? where are the developers of this patch???

**NavoneNew1** · 2006-07-17, 10:10 PM

i believe its because u did not apply the LDAP patch first as per the text file instructions

**joschi05fan** · 2006-07-19, 07:52 AM

hi,

if i first install the ldap patch i get the following line at the end of the process:

Fatal error: main(): Failed opening required '' (include_path='.:/opt/lampp/lib/php') in /opt/lampp/htdocs/sugar/modules/Administration/RebuildRelationship.php on line 51

can you tell me, what field is required?
i still get the query error.

joschi