BUG report: Collation Error

  • Resolved FireMyst

    (@firemyst)


    7 years, 8 months ago

    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)

  • You can fix this issue by running this Query on your database:

    ALTER TABLE wp_subscribe_reloaded_subscribers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

    If you don’t have access to the database you can use a plugin to run queries within WordPress.

    Thread Starter FireMyst

    (@firemyst)

    THanks!

    That fixed the issue.

    As a suggestion, is this something you can modify the install for so users don’t have to go through and do this?

    Thank you for the fix! It worked.

    I agree with FireMyst to alter the plugin so you don’t have to run this MySQL plugin. Not everybody knows what Queries are and what plugins to look for.

    Greetz,

    Jaime

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘BUG report: Collation Error’ is closed to new replies.