Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT

[Lumina]

Hello, on the following board : http://www.nouvelle-aube.net/forums/
Sometimes, on the admincp, it displays :

Invalid SQL:
UPDATE datastore
SET data = 0,
data = IF( data < 0, 0, data )
WHERE 1=1 AND title = 'mailqueue'

mysql error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'if'

I checked the MySQL 4.1 database, and all tables and parameters are set to utf8. So latin1_swedish_ci is nowhere to be found on our database.

[Floris]

Hello,

Apologies for the late reply.

I believe this is due to an issue with MySQL. Upgrade MySQL to the latest version and this issue should be resolved.

[Dragon]

Please see this thread for a fix.