wpDiscuz - WordPress Comment Plugin
WordPress database ...
 
Share:
Notifications
Clear all

Bug [Solved] WordPress database error Illegal mix of collations

5 Posts
2 Users
2 Likes
67 Views
Posts: 3
Topic starter
(@theservant)
Active Member
Joined: 2 weeks ago

This error shows up in the PHP log file.

 

WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation 'like' for query SELECT `c`.`comment_author_email`, `c`.`comment_author`, COUNT(`c`.`comment_ID`) AS `count`, IFNULL(`s`.`count`, 0) AS `scount`, IFNULL(`fi`.`count`, 0) AS `ficount`, IFNULL(`fw`.`count`, 0) AS `fwcount`, MAX(`c`.`comment_date_gmt`) AS `last_date` FROM `wp_comments` AS `c` LEFT JOIN (SELECT `email`, COUNT(`email`) AS `count` FROM `wp_wc_comments_subscription` WHERE `confirm` = 1 GROUP BY `email`) AS `s` ON `s`.`email` LIKE `c`.`comment_author_email` LEFT JOIN (SELECT `follower_email`, COUNT(`follower_email`) AS `count` FROM `wp_wc_follow_users` WHERE `confirm` = 1 GROUP BY `follower_email`) AS `fi` ON `fi`.`follower_email` LIKE `c`.`comment_author_email` LEFT JOIN (SELECT `user_email`, COUNT(`user_email`) AS `count` FROM `wp_wc_follow_users` WHERE `confirm` = 1 GROUP BY `user_email`) AS `fw` ON `fw`.`user_email` LIKE `c`.`comment_author_email` WHERE `c`.`comment_approved` = '1' AND `c`.`comment_type` NOT IN('order_note') GROUP BY `c`.`comment_author_email`, `c`.`comment_author` ORDER BY `count` DESC LIMIT 7 OFFSET 0; made by do_action('wp_ajax_wpd_stat_user'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzHelperAjax->wpd_stat_user, WpdiscuzDBManager->getActiveUsers

Topic Tags
4 Replies
Asti
Posts: 5779
 Asti
Support
(@asti)
Illustrious Member
Joined: 5 years ago

Hi @theservant,

Please read this support topic. The same issue is discussed here:  https://wpdiscuz.com/community/plugin-update-issues/db-collation-issue-after-updating-to-7-0-0/

Posts: 3
Topic starter
(@theservant)
Active Member
Joined: 2 weeks ago

I will try fixing the tables (hopefully, a subsequent update has considered different collations on different installs on WordPress on MySQL). Then I will update the collation if that does not work.

Thanks.

1 Reply
Asti
 Asti
Support
(@asti)
Joined: 5 years ago

Illustrious Member
Posts: 5779

@theservant,

Please keep us informed. 

Posts: 3
Topic starter
(@theservant)
Active Member
Joined: 2 weeks ago

Fix tables did not work. Changing the collation mannually did.

Share: