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 support@serverpress.com.

    Thread Starter stevejharris

    (@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

    https://wordpress.org/support/topic/illegal-mix-of-collations-prevent-customers-from-checking-out/

    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.