[horde] Horde_Imap_Client utf8 error?

[Jan Schneider]

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