Title: BUG report: Collation Error
Last modified: July 6, 2017

---

# BUG report: Collation Error

 *  Resolved [FireMyst](https://wordpress.org/support/users/firemyst/)
 * (@firemyst)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/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)

 *  [Israel Barragan](https://wordpress.org/support/users/reedyseth/)
 * (@reedyseth)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/bug-report-collation-error/#post-9293157)
 * 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](https://wordpress.org/support/users/firemyst/)
 * (@firemyst)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/bug-report-collation-error/#post-9302361)
 * 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?
 *  [jmslbam](https://wordpress.org/support/users/jmslbam/)
 * (@jmslbam)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/bug-report-collation-error/#post-9359620)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/subscribe-to-comments-reloaded_f0f9fc.
   svg)
 * [Subscribe To Comments Reloaded](https://wordpress.org/plugins/subscribe-to-comments-reloaded/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/subscribe-to-comments-reloaded/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/subscribe-to-comments-reloaded/)
 * [Active Topics](https://wordpress.org/support/plugin/subscribe-to-comments-reloaded/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/subscribe-to-comments-reloaded/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/subscribe-to-comments-reloaded/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [jmslbam](https://wordpress.org/support/users/jmslbam/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/bug-report-collation-error/#post-9359620)
 * Status: resolved