R
ryanduff
Guest
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 '='
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 '='