Take Action emergency contraceptive.Enjoy Free 888+200 Daily Legal Bonus

Resolved Refine Graphics
(@refine-graphics)

3 years, 7 months ago
WP + all plugins are up to date
This issue started happening after updating to Mailpoet 3.60.6 from 3.60.5

It’s preventing checkout on Woocommerce, so kind of a big deal!

[31-Mar-2021 22:23:52 UTC] PHP Fatal error: Uncaught Exception: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’ in /wp-content/plugins/mailpoet/lib/Models/Model.php:373

Stack trace:
#0 /wp-content/plugins/mailpoet/lib/Segments/WooCommerce.php(247): MailPoet\Models\Model::__callStatic(‘rawExecute’, Array)
#1 /wp-content/plugins/mailpoet/lib/Segments/WooCommerce.php(98): MailPoet\Segments\WooCommerce->updateFirstNames(‘187’)
#2 /wp-includes/class-wp-hook.php(294): MailPoet\Segments\WooCommerce->synchronizeRegisteredCustomer(6)
#3 /wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters(”, Array)
#4 /wp-includes/plugin.php(484): WP_Hook->do_action(Array)
#5 /wp-content/plugins/woocommerce/includes/data-stores/class-wc-customer-data-store.php(214): do_action(‘woocommerce_upd in /wp-content/plugins/mailpoet/lib/Models/Model.php on line 373
- This topic was modified 3 years, 7 months ago by Refine Graphics.
The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)

davidtrebacz
(@davidtrebacz)

3 years, 7 months ago

There is another thread here – update coming Tuesday – either disable or rollback: https://www.ads-software.com/support/topic/latest-update-error-on-woocommerce-checkout/

stevejharris
(@stevejharris)

3 years, 7 months ago

I used this plugin
https://www.ads-software.com/plugins/database-collation-fix/
it fixed the issue

Elvira K.
(@treibalen)

3 years, 7 months ago

Hi there @refine-graphics,

Thanks for reaching out!

Indeed, we’re releasing a fix to this bug today/tomorrow early morning.

We apologize for any inconvenience and we appreciate your patience.

Rolling back to 3.60.4 should fix the issue as well.

Cheers!

Thread Starter Refine Graphics
(@refine-graphics)

3 years, 7 months ago

Thanks @stevejharris I also found that plugin and used it to fix the issue

@treibalen yikes, a full week after releasing the update that caused e-commerce to stop working… The owner of the reported site is almost ready to give up on running her business on WordPress because of issues like this. Can you please confirm that your new release won’t cause issues for those of us that found and used the “Database Collation Fix” plugin to resolve the issue?

Elvira K.
(@treibalen)

3 years, 7 months ago

Hi there @refine-graphics,

This bug only affects sites where a database that uses different collations, not all WooCommerce sites. Also, a workaround to downgrade was provided to resolve it until a permanent fix is released.

Please update to the latest version of the MailPoet plugin and let us know if you’re still seeing any issues.

Enjoy the rest of your day and stay safe!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Illegal mix of collations – prevent customers from checking out’ is closed to new replies.