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

[Jan Schneider]

Zitat von Bruno Costacurta <techie at costacurta.org>:

>> 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'

Looks like a broken backend configuration. You seem to have a member  
of the composite "name" attribute that doesn't actually have a  
database column mapped to it.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/