[horde] Horde_Imap_Client utf8 error?

Erling Preben Hansen erling at eph.dk
Mon Apr 28 16:33:23 UTC 2014


  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


More information about the horde mailing list