Tickets :: [#12685] Address lookup via address field not working for SQL address book backend

6.0.0-beta1

7/6/25

Summary	Address lookup via address field not working for SQL address book backend
Queue	Turba
Queue Version	Git master
Type	Bug
State	Not A Bug
Priority	2. Medium
Owners
Requester	lotan_rm (at) gmx (dot) de
Created	09/15/2013 (4312 days ago)
Due
Updated	09/16/2013 (4311 days ago)
Assigned
Resolved	09/16/2013 (4311 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

09/16/2013 05:35:21 PM	lotan_rm (at) gmx (dot) de	Comment #3	Reply to this comment
There is now SQL LOWER() call in Turba. You must have added this in your customization. My apologies. You're right. After some search, I found a previous post of yours which led me on the right track: http://lists.horde.org/archives/horde/Week-of-Mon-20130114/046256.html My backend configuration contained errors. Thanks a lot for your help.

09/16/2013 08:42:19 AM	Jan Schneider	Comment #2 State ⇒ Not A Bug	Reply to this comment
There is now SQL LOWER() call in Turba. You must have added this in your customization.

09/15/2013 09:18:12 PM	Michael Slusarz	Version ⇒ Git master Queue ⇒ Turba

09/15/2013 07:02:38 PM	lotan_rm (at) gmx (dot) de	Comment #1 Priority ⇒ 2. Medium Patch ⇒ No Milestone ⇒ Queue ⇒ IMP Summary ⇒ Address lookup via address field not working for SQL address book backend Type ⇒ Bug State ⇒ Unconfirmed	Reply to this comment
For a little while now, address lookup for the SQL address book backend doesn't seem to work. Error message in the log: Sep 15 20:50:46 mm HORDE[14953]: [imp] QUERY FAILED: Incorrect parameter count in the call to native function 'LOWER' If I deactivate all SQL-based address books, the LDAP address book backend works.