[turba] Mysql Turba char set problem

[Jan Schneider]

Keep discussions on the list.

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

>
> On Aug 22, 2006, at 4:39 AM, Jan Schneider wrote:
>
>> 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?
>
> It is cp12512 West European.
> The Collation is latin1_swedish_ci
> The table type in InnoDB.

Is there anything special about the string you are searching for, or  
is this happening with any searches?

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