[turba] Mysql Turba char set problem

Brock Palen brockp at michiganlivestock.com
Mon Aug 21 18:06:49 PDT 2006


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  
into sets before so i'm in the dark here.  Any insight would be helpful.


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"]


More information about the turba mailing list