The effects of alcohol on sustanon 250 leucine for – real weight loss & bodybuilding benefits?
WordPress database ...
 
Share:
Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the wpDiscuz community!

Merry Christmas and Happy Holidays! 🎄

Bug [Solved] WordPress database error Illegal mix of collations

5 Posts
2 Users
2 Reactions
2,171 Views
Posts: 8
Topic starter
(@theservant)
Active Member
Joined: 3 years ago
[#6624]

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


4 Replies
Asti
Posts: 8205
 Asti
Support
(@asti)
Illustrious Member
Joined: 8 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: 8
Topic starter
(@theservant)
Active Member
Joined: 3 years 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: 8 years ago

Illustrious Member
Posts: 8205

@theservant,

Please keep us informed. 


Posts: 8
Topic starter
(@theservant)
Active Member
Joined: 3 years ago

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


Share: