Tickets :: Comment on [#1918] DB Error: syntax error

* Your Email Address
* Spam protection	Enter the letters below: . __ .. . . \|/ ` \|\|_/ \| \__\|\__.\__\|\| \\__\|
Comment	> I'm using mysql as a backend. Here's an excerpt from sources.php > > > > 'search' => array( > > 'name', > > 'email', > > 'alias' > > ), > > 'strict' => array( > > 'object_id', > > 'owner_id', > > 'object_type', > > 'object_alias' > > ), > > > > I want people to be able to search by name, email or alias, but I > want the alias to be a strict search (allowing people to have entries > like "dad" and "stepdad" in their addressbook and have it find the > right one). So, after I added "object_alias" to strict search, I > get... > > > > May 05 12:07:14 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 = 'dad' 0 > owner_id = 'liamr' AND (object_name LIKE LOWER('%dad%'))) > [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('%dad%')))' at line 1] [on line 82 of > "/usr/local/projects/webmail/html-dev/horde/turba/lib/Driver/sql.php"] > > > > This is probably equally bug / feature request.. but basically, I'd > like to replicate PINE's addressbook behavior such that if you type > in an unqualified address (eg "dad" ) it follows logic like this.. > > - look for entries where the nickname matches "dad" exactly > > - look for entries where the full name contains "dad" > > - add the default domain to the word and call it done ( "dad@example.com" )
Attachment
Watch this ticket

Saved Queries