[horde] Query error (was: How to use the address book ...)

[Bruno Costacurta]

> Did you set your address book(s) in the configuration for IMP
> (Webmail)? Otherwise IMP does not know where to look for addresses and
> the autocompletion cannot work. AFAIK you don't have to set
> autocompletion to ON in horde.
> --

Yes, the address book is correctly setup within IMP.

The problem appears to be the SQL query.
As I type an email address in the composing email window, found the  
following error in the Horde log :


(...)
2013-01-12T17:30:51+01:00 ERR: HORDE [imp] QUERY FAILED: Incorrect  
parameter count in the call to native function 'LOWER'

SELECT object_id, object_type, owner_id, object_members,  
object_nameprefix, object_firstname, object_lastname, object_email  
FROM turba_objects WHERE (owner_id = 'bruno' AND  
((LOWER(object_nameprefix) LIKE LOWER('%techi%') OR  
LOWER(object_firstname) LIKE LOWER('%techi%') OR LOWER() LIKE  
LOWER('%techi%') OR LOWER(object_lastname) LIKE LOWER('%techi%') OR  
LOWER() LIKE LOWER('%techi%')))) [pid 22228 on line 171 of  
"/var/www/horde4/turba/lib/Driver/Sql.php"]
2013-01-12T17:30:52+01:00 ERR: HORDE [imp] QUERY FAILED: Incorrect  
parameter count in the call to native function 'LOWER'

SELECT object_id, object_type, owner_id, object_members,  
object_nameprefix, object_firstname, object_lastname, object_email  
FROM turba_objects WHERE (owner_id = 'bruno' AND  
((LOWER(object_nameprefix) LIKE LOWER('%techie%') OR  
LOWER(object_firstname) LIKE LOWER('%techie%') OR LOWER() LIKE  
LOWER('%techie%') OR LOWER(object_lastname) LIKE LOWER('%techie%') OR  
LOWER() LIKE LOWER('%techie%')))) [pid 22228 on line 171 of  
"/var/www/horde4/turba/lib/Driver/Sql.php"]
(...)

Thanks to any clue or help.
Bruno

-- 
Linux Counter # 353844
https://linuxcounter.net/user/353844.html