1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Yet another failed upgrade - PleskMainDBException

Discussion in 'Plesk for Linux - 8.x and Older' started by ryanduff, Apr 2, 2006.

  1. ryanduff

    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
    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
    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 '='
  2. ryanduff

    ryanduff Guest