The table horde.imp_sentmail could not be converted to UTF-8

uadm

• March 18, 2014 07:37

We started getting hundereds of the following message from the server: "The table horde.imp_sentmail could not be converted to UTF-8. Horde tables must use the Latin-1 encoding in order to be converted. As a result, no changes have been made to this table. You will still be able to access the data that this table contains, but use of non-UTF-8 encoded data may cause problems and is not recommended. " Where is it coming from? how can we stop it? Thanks

• 

  cPanelMichael

  • March 19, 2014 14:47

  Hello :) This message indicates the Horde update script executed during cPanel updates could not convert that table to UTF-8. The warning message is sent to alert you of this conversion failure. Do you have a custom default character set and custom default collation configured in your /etc/my.cnf file? If so, that's likely the reason for the non-standard encoding of the tables. Thank you.

  0
• 

  uadm

  • March 19, 2014 15:04

  Hi, yes we do have this in my.cnf. What is the horde update script? We can remove those entried from my.cnf and run it manualy (then put the entries back). Thanks.

  0
• 

  cPanelMichael

  • March 19, 2014 15:49

  The tables have already been created so unless you want to lose all of your Horde configuration data, you will have to manually convert the encoding of the tables to UTF-8. You can search for methods of completing this on a search engine if necessary. I found the following result when using a search engine: [url=http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8]character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow Thank you.

  0

Please sign in to leave a comment.