[Tickets #1918] DB Error: syntax error

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=1918
-----------------------------------------------------------------------
 Ticket             | 1918
 Updated By         | liamr at umich.edu
 Summary            | DB Error: syntax error
 Queue              | Turba
 Version            | 2.0.2
 State              | Feedback
 Priority           | 1. Low
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


liamr at umich.edu (2005-05-06 08:09) wrote:

I tried copying SQL.php and the SQL subdirectory, and I get the same
error...

May 06 11:07:50 HORDE [error] [turba] DB Error: syntax error: SELECT
object_id, owner_id, object_type, object_members, object_uid, object_name,
object_email, object_alias, object_homeaddress, object_workaddress,
object_homephone, object_workphone, object_cellphone, object_fax,
object_title, object_company, object_notes, object_pgppublickey,
object_smimepublickey, object_freebusyurl FROM turba_objects WHERE
(object_alias = 'sara' 0 owner_id = 'liamr' AND (object_name LIKE
LOWER('%sara%'))) [nativecode=1064 ** 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 '0 owner_id = 'liamr' AND (object_name LIKE
LOWER('%sara%')))' at line 1] [on line 82 of
"/usr/local/projects/webmail/html-dev/horde/turba/lib/Driver/sql.php"]