[turba] Mysql Turba char set problem

[Brock Palen]

On Aug 22, 2006, at 9:21 AM, Jan Schneider wrote:

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

Its having IMP automatically expand a address in the To: CC: or BCC;  
lines of a new message.  For example i have  
greg at michiganlivestock.com in my turba book.  I type in greg in to,  
when i move out IMP tries to expand the address, i see the error in  
the log, and IMP says it could not be expanded.

General searching in the address-book does not cause this problem.   
As far as i can tell.

>
>>>> 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/
>
> -- 
> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org