| 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 |
State ⇒ Feedback
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Malformed SQL Query
Queue ⇒ Turba
New Attachment: sources.php
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.