Yet another failed upgrade - PleskMainDBException

[ryanduff]

I'm getting this after a failed upgrade to 8.0 from 7.5.4 on FC2

This is what I get when I try and log in:

ERROR: PleskMainDBException
MySQL query failed: Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

0: /usr/local/psa/admin/plib/common_func.php3:229
db_query(string 'SELECT id FROM locales WHERE id = "en-US"')
1: /usr/local/psa/admin/plib/countries.php3:291
locale_list()
2: /usr/local/psa/admin/plib/common_func.php3:1405
locale_exists(string 'en-US')
3: /usr/local/psa/admin/plib/class.Session.php:158
Session->Session()
4: /usr/local/psa/admin/auto_prepend/auth.php3:137


And the same error in the log file...

MySQL41PSADBUpgrade: Database upgrade successful
ERROR 1267 (HY000) at line 1: Illegal mix of collations (ascii_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

 

[ryanduff]

For anyone else with this, I solved it by adding the ART repos (more info at http://atomicrocketturtle.com) and doing a `yum install mysql`