woocommerce checkout error message “Illegal mix of collations”

  • Resolved Allen Freeman

    (@allenfreeman)


    3 years, 8 months ago

    At shop.standardlegal.com, we’re suddenly getting an error message that is preventing checkout while using WooCommerce 5.1.0 on WP 5.7:

    SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’

    A customer pointed it out to us, and I tested and received the same error message when trying to checkout. The error appears in trying Paypal Pro with a credit card and trying to access Paypal Standard to pay at Paypal.

    We are using the most up-to-date version of all plugins, so I’m stuck. Any ideas? Thank you!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 16 through 17 (of 17 total)
Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘woocommerce checkout error message “Illegal mix of collations”’ is closed to new replies.