Recent Topics

1 Oct 22, 2013 01:46    

I've got the Illegal mix of collations error after upgrading from 4.1 to 5.0.6.
It only shows up when I look at Dashboard > Emails > Addresses so it's not critical. But nobody likes to see that red error text.

I followed the advice here http://stackoverflow.com/questions/1008287/illegal-mix-of-collations-mysql-error?rq=1 and then went through every single table and column in the database and made them all utf8_general_ci. They were not all the same at first.

But the problem persists. Error as follows:

MySQL error!

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='(Errno=1267)

Your query: Results::Query()

SELECT SQL_NO_CACHE emblk_ID, emblk_address, emblk_status, emblk_last_sent_ts, emblk_sent_count, emblk_sent_last_returnerror, emblk_last_error_ts, 

( emblk_prmerror_count + emblk_tmperror_count + emblk_spamerror_count + emblk_othererror_count ) AS emblk_all_count,

emblk_prmerror_count, emblk_tmperror_count, emblk_spamerror_count, emblk_othererror_count, 

COUNT( user_ID ) AS users_count

  FROM evo_email__blocked

  LEFT JOIN evo_users ON user_email = emblk_address

 WHERE (emblk_status IN ('warning','suspicious3'))

 GROUP BY emblk_ID

 ORDER BY emblk_last_sent_ts DESC

 LIMIT 0, 20

2 Oct 22, 2013 09:38

Hi @filthio,

Note that you have changed the charset to UTF8 but the collations are still different: utf8_unicode_ci - utf8_general_ci. Please check these tables: evo_email__blocked and evo_users, for each one all its fields and the table itself should be set with the same collation ( no matter which one you have decided to use, but they have to be the same. Preferably use utf8_general_ci ).

Regards !


Form is loading...