Support » Plugin: Database Collation Fix » many thanks, lifesaver!

  • saw this error – SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’ – on 3x WordPress Woocommerce sites.
    My support (SiteGround) suggested changing the collation using PHPMyAdmin.
    this seemed like a recipe for disaster.
    found this plugin, not updated for 3 years, but saw 4 5* reviews in the last 24 hours, so I knew it was OK to try.
    Uploaded, installed, activated – problem solved.
    remember, it’s WordPress, There’s ALWAYS a plugin!
    the plugin was even updated between me downloading and installing! glad to see it’s up to date. that always helps when trying plugins.
    many thanks, lifesaver

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi Steve,

    Thanks so much for the review!

    We are trying to recreate this error so that we can create a short FAQ on how to fix it for our knowledgebase. Unfortunately, we’ve been unable to do so. Would it be possible for you to email us a few details? Specifically:

    * What version of WordPress were you running?
    * What version of WooCommerce were you running?
    * How/When did you see the error (What were you trying to do)?
    * What version of MySQL were you running (if you know)?

    Thanks for any help on this! You can email us at

    Thread Starter stevejharris


    hi, everything was up to date, but…

    I had I noticed that there was a ‘Your Site is Experiencing a Technical Issue’ earlier in the day, before the problem started. I have re-looked at it and seen that the plugin causing the error was mailpoet.
    So I then looked at the mailpoet support page here on WordPress, and…
    there it is, the error, the reply, the fix

    in the meantime, I have left your plugin active on the 3 sites I had issues with
    many thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘many thanks, lifesaver!’ is closed to new replies.