[horde] Horde_Imap_Client utf8 error?

[Jan Schneider]

Zitat von Erling Preben Hansen <erling at eph.dk>:

> Citat af Jan Schneider <jan at horde.org>:
>
>> Zitat von Erling Preben Hansen <erling at eph.dk>:
>>
>>> Hey
>>>
>>> Is there a workaround for this:
>>>
>>> QUERY FAILED: Table 'horde.horde_imap_client_message' doesn't exist SHOW
>>> FIELDS FROM `horde_imap_client_message`
>>>
>>> As I understand it. It is because my mysql database is in utf8.
>>>
>>> Aparently the Table horde.horde_Imap_Client_message are using some sort
>>> of
>>> UNIQUE key that can be longer than 1000 bytes in utf8 but not in latin1.
>>>
>>> It hasn't been a problem up until my last pear update to version
>>> Groupware
>>> 5.1.4
>>>
>>> This is a running production server.
>>>
>>> Folowing message from Horde_db_migrate:
>>>
>>> [  INFO  ] Migrating DB up.
>>> [  INFO  ] Current Horde_Imap_Client schema version: 1
>>> Migrating to HordeImapClientChangeColumnName (2)
>>> == 2 HordeImapClientChangeColumnName: migrating
>>> ===============================
>>> -- columns('horde_imap_client_data')
>>>    -> 0.0106s
>>> -- columns('horde_imap_client_message')
>>> QUERY FAILED: Table 'horde.horde_imap_client_message' doesn't exist
>>>
>>> SHOW FIELDS FROM `horde_imap_client_message`
>>>
>>> ------
>>> Quoting "John H. Bennett III" <bennettj at thebennetthome.com> from date
>>> 23-2
>>> 2014:
>>>
>>>> I think I've finally found the issue.  I was using UTF-8 as the
> charset
>>>
>>> for mysql.  I found this bug,
>>>> http://bugs.mysql.com/bug.php?id=4541. 
>>>> Changing to latin1 fixes things and the horde DB's get updated. 
>>>> Not sure when I changed to
>>>> utf-8 unless that's the default, but my current horde 3 DB is using
>>>> latin1
>>>
>>> also, so for me I think It will fix all my issues, and
>>>> allow me to begin upgrading without fear.
>>>
>>> Quot stop
>>> -----
>>>
>>> Any solutions?
>>>
>>> /erling
>>
>> No, the message cannot be clearer: that table doesn't exist. It should
>> though.
>>
>> --
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>> https://www.facebook.com/hordeproject
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
>> horde-unsubscribe at lists.horde.org
>
> Hey
>
> Jan I can se that.
> My question still is How to make it when horde_db_migrate fails.

You schema version information for Horde_Imap_Client tables is  
incorrect. Migrate down, if necessary delete left-over tables, then  
migrate up.

> and howto workaround utf8 using more space than latin1.
> or is 'messageuid Varshar(255)' a workaround?

No idea what you are talking about or what this has to do with the  
issue above.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject