Notifications
Clear all

Error in PHP Log

3 Posts
2 Users
0 Reactions
887 Views
(@nick776)
Posts: 58
Trusted Member
Topic starter
 

Hi There!

We upgrate yesterday to wpdiscuz an Subscription Manager 7.x . Today we take a lock at our php error log and found this:

 

[02-Oct-2020 17:02:33 UTC] WordPress-Datenbank-Fehler Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like' für Abfrage 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_2_comments` AS `c` LEFT JOIN (SELECT `email`, COUNT(`email`) AS `count` FROM `wp_2_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_2_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_2_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' GROUP BY `c`.`comment_author_email`, `c`.`comment_author` ORDER BY `count` DESC LIMIT 7 OFFSET 0; von do_action('wp_ajax_wpd_stat_user'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzHelperAjax->wpd_stat_user, WpdiscuzDBManager->getActiveUsers, QM_DB->query

 

Is there anything we can do to avoid this error?

thnx for helping

Nick

 
Posted : 03/10/2020 8:46 am
Elvina
(@elvina)
Posts: 1403
Support
 

@nick776,

Please navigate to the Dashboard > Comments > wpDiscuz > Tools > Database Operations  admin page, click on "Fix Tables" button and check again.

 
Posted : 03/10/2020 11:54 am
(@nick776)
Posts: 58
Trusted Member
Topic starter
 

@elvina ok, thnx for your quick reply Elvina

 
Posted : 04/10/2020 9:36 am
Share:
Scroll to top