Notifications
Clear all

Fatal Error

2 Posts
2 Users
0 Likes
355 Views
Posts: 6
Customer
Topic starter
(@anna-sviridova)
Member
Joined: 3 years ago

Hi there!

Im have wpforo bungle pro addons. Also would like subscribe on Discuz. First day use plugin but have fatal error in hosting logs

[23-Jun-2023 11:19:20 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_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_hx_comments` AS `c` LEFT JOIN (SELECT `email`, COUNT(`email`) AS `count` FROM `wp_hx_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_hx_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_hx_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

and 

[23-Jun-2023 08:15:08 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_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_hx_comments` AS `c` LEFT JOIN (SELECT `email`, COUNT(`email`) AS `count` FROM `wp_hx_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_hx_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_hx_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

also

and

Can you please help fised it?

Best regards
Alena

1 Reply
Astghik
Posts: 5911
Admin
(@astgh)
Illustrious Member
Joined: 6 years ago

Hi Alena,

Please navigate to the Dashboard > Comments > wpDiscuz > Tolls > Fix Tables admin page and click on the "Fix Tables" button and check again. Everything should work fine.

Reply
Share:
Scroll to top