[turba] Mysql Turba char set problem

[Jan Schneider]

Zitat von Brock Palen <brockp at michiganlivestock.com>:

> I am getting the following in my horde-log.   My setup is as follows
>
> 5.1.4-pl4-gentoo
> apache2-2.0.58
> mysql-4.1.21
>
> Bellow is the full error message and the debug query that causes the problem.
>
> Basicly the message is:
> Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and  
> (utf8_general_ci,COERCIBLE) for operation 'like'
>
> The value from conf.php
> $conf['sql']['charset'] = 'iso-8859-1';
>
> Which is the latin1 char set right?  I have never had to dig to deep

Correct.

> into sets before so i'm in the dark here.  Any insight would be helpful.

What is the charset of your turba_objects table?

> The error
>
> Aug 21 11:38:43 HORDE [error] [turba] DB Error: unknown 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 (owner_id = 'brockp' AND  
> (LOWER(object_name) LIKE LOWER('%greg%') OR LOWER(object_email) LIKE  
> LOWER('%greg%'))) [nativecode=1267 ** Illegal mix of collations  
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for  
> operation 'like'] [on line 126 of  
> "/var/www/mail.michiganlivestock.com/htdocs/turba/lib/Driver/sql.php"]
>
> The debug query:
>
> Aug 21 11:38:43 HORDE [debug] [turba] SQL query by  
> Turba_Driver_sql::_search(): 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  
> (owner_id = ? AND (LOWER(object_name) LIKE LOWER(?) OR  
> LOWER(object_email) LIKE LOWER(?))) [on line 121 of  
> "/var/www/mail.michiganlivestock.com/htdocs/turba/lib/Driver/sql.php"]

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/