6.0.0-RC7
6/27/26

[#2661] Malformed SQL Query
Summary Malformed SQL Query
Queue Turba
Queue Version 2.0.3
Type Bug
State Resolved
Priority 2. Medium
Owners selsky (at) columbia (dot) edu
Requester yyfede (at) gmail (dot) com
Created 9/23/05 (7582 days ago)
Due
Updated 9/29/05 (7576 days ago)
Assigned 9/27/05 (7578 days ago)
Resolved 9/29/05 (7576 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
428 Jan Schneider State ⇒ Resolved
 
167 yyfede (at) gmail (dot) com Comment #4 Reply to this comment
It works properly with Horde 3.0.5.
426 Matt Selsky Assigned to Matt Selsky
 
166 Matt Selsky Comment #3
State ⇒ Feedback
Reply to this comment
User has Horde 3.0.2 and will try upgrading to 3.0.5.
3410 Matt Selsky Comment #2 Reply to this comment
What version of Horde are you using?
359 yyfede (at) gmail (dot) com Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Malformed SQL Query
Queue ⇒ Turba
New Attachment: sources.php Download
Reply to this comment
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.

Saved Queries