BUG report: Collation Error
-
This is showing up in the log files on my host.
Note that I removed my email address and for the purposes of posting here replaced it with “[removed my email]”. The address I used had an underscore character in it (don’t know if that helps) :
[06-Jul-2017 01:42:13 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' for query SELECT meta_id, REPLACE(meta_key, '_stcr@_', '') AS email, post_id, SUBSTRING(meta_value, 1, 19) AS dt, SUBSTRING(meta_value, 21) AS status, srs.subscriber_unique_id AS email_key FROM wpdl_postmeta INNER JOIN wpdl_subscribe_reloaded_subscribers srs ON ( REPLACE(meta_key, '_stcr@_', '') = srs.subscriber_email ) WHERE meta_key LIKE '\_stcr@\_%' AND SUBSTRING(meta_value, 21) = 'Y' AND SUBSTRING(meta_key, 8) = '[removed my email]' ORDER BY dt ASC LIMIT 0,18446744073709551610 made by wp_handle_comment_submission, wp_new_comment, do_action('comment_post'), WP_Hook->do_action, WP_Hook->apply_filters, stcr\wp_subscribe_reloaded->new_comment_posted, stcr\wp_subscribe_reloaded->isDoubleCheckinEnabled, stcr\wp_subscribe_reloaded->get_subscriptions
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘BUG report: Collation Error’ is closed to new replies.