[Tickets #2661] NEW: Malformed SQL Query

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=2661
-----------------------------------------------------------------------
 Ticket             | 2661
 Created By         | yyfede at gmail.com
 Summary            | Malformed SQL Query
 Queue              | Turba
 Version            | 2.0.3
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
+New Attachment     | sources.php
-----------------------------------------------------------------------


yyfede at gmail.com (2005-09-23 02:57) wrote:

According to the following error message, reported in /tmp/horde.log, it
seems that Turba's SQL query engine doesn't submit a valid query for reading
contacts belonging to the current logged user.
The error message is:

Sep 23 11:45:59 HORDE [error] [turba] DB Error: mismatch: 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 (o) [on
line 85 of "/srv/www/htdocs/horde/turba/lib/Driver/sql.php"]

This error happens when the 'public' option in 'sources.php' file is set to
'true' (see attached sources.php file), so that only entries belonging to
current user should be listed.

It seems that the WHERE clause, where the matching between owner_id and the
current logged use should be performed, is made only of a simple 'o'.

This error results in listing 3 not existent entries while browsing the
address book, while valid entries that should appear aren't listed at all.