Roberto D. Torre

After updating MailPoet 3.0.1 to 3.0.2

MailPoet Error: exception 'Exception' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='' in <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Models/Model.php:187
Stack trace:
#0 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Segments/WP.php(104): MailPoet\Models\Model::__callStatic('raw_execute', Array)
#1 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Segments/WP.php(104): MailPoet\Models\Subscriber::raw_execute('\n UPDATE I...')
#2 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Segments/WP.php(83): MailPoet\Segments\WP::updateSubscriberWPUserIds()
#3 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Populator.php(150): MailPoet\Segments\WP::synchronizeUsers()
#4 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Populator.php(66): MailPoet\Config\Populator->createDefaultSegments()
#5 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Activator.php(15): MailPoet\Config\Populator->up()
#6 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Initializer.php(91): MailPoet\Config\Activator->activate()
#7 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Initializer.php(156): MailPoet\Config\Initializer->runActivator()
#8 <em><strong>...</strong></em>/wp-content/plugins/mailpoet/lib/Config/Initializer.php(123): MailPoet\Config\Initializer->maybeDbUpdate()
#9 [internal function]: MailPoet\Config\Initializer->initialize('')
#10 <em><strong>...</strong></em>/wp-includes/class-wp-hook.php(298): call_user_func_array(Array, Array)
#11 <em><strong>...</strong></em>/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters('', Array)
#12 <em><strong>...</strong></em>/wp-includes/plugin.php(453): WP_Hook->do_action(Array)
#13 <em><strong>...</strong></em>/wp-settings.php(448): do_action('init')
#14 <em><strong>...</strong></em>/wp-config.php(92): require_once('/home/kq1hqzpn/...')
#15 <em><strong>...</strong></em>/wp-load.php(37): require_once('/home/kq1hqzpn/...')
#16 <em><strong>...</strong></em>/wp-admin/admin.php(31): require_once('/home/kq1hqzpn/...')
#17 <em><strong>...</strong></em>/wp-admin/index.php(10): require_once('/home/kq1hqzpn/...')
#18 {main}

host site path <em><strong>...</strong></em>

disabling and re-enabling the plug-in

Exception thrown

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