We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 45714
    • 7 Posts
    Hi,
    I found this in the MODX error log. Can anyone shed some light on what it means and how to fix? Thanks

    [2013-11-28 21:21:34] (ERROR in xPDO::getValue @ /var/www/vhosts/site/httpdocs/core/xpdo/xpdo.class.php : 1096) Error HY000 executing statement:
    Array
    (
    [0] => HY000
    [1] => 1267
    [2] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
    )
      • 40092
      • 265 Posts
      Well, line [2] does say it all, actually smiley
      You're somehow mixing utf8_general and latin_swedish. Try and check in settings wich one is set there, i t hink utf8 is the most preferred setting, should change it to that.

      [2] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='


      In system settings do a search for: "modx_charset" there you should find it.
        • 45714
        • 7 Posts
        Thanks! Quote from: thapriest86 at Nov 29, 2013, 03:06 AM
        Well, line [2] does say it all, actually smiley
        You're somehow mixing utf8_general and latin_swedish. Try and check in settings wich one is set there, i t hink utf8 is the most preferred setting, should change it to that.

        [2] => Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='


        In system settings do a search for: "modx_charset" there you should find it.