[horde] Horde_Imap_Client utf8 error?

[Erling Preben Hansen]

  Citat af 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.
> and howto workaround utf8 using more space than latin1.
> or is 'messageuid Varshar(255)' a workaround?
>
> /erling
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
> horde-unsubscribe at lists.horde.org

Hey

Solved it by exporting the missing tables from my 'test it, or do your
worst, server'.

enabling Innodb
and importing them to the production server.

/erling