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

[Solved] php log error

3 Posts
2 Users
2 Reactions
656 Views
Posts: 6
 para
Topic starter
(@para)
Active Member
Joined: 5 years ago

Hi!

Nice to see the development of wpdiscuz go strong everyday.

Yesterday while I was looking at the php logs I found this message, I can't understand to much but seems to be related to wpdiscuz. Could you please take a look?

PS there are couple of words in Greek language I have marked with green and give a quick translation in the ()

 Thanks in advance

[27-Apr-2020 17:06:50 UTC] Σφάλμα (error) Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like' βάσης δεδομένων (database) WordPress για αίτηση (request) 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' GROUP BY `c`.`comment_author_email`, `c`.`comment_author` ORDER BY `count` DESC LIMIT 7 OFFSET 0; από do_action('wp_ajax_wpd_stat_user'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzHelperAjax->wpd_stat_user, WpdiscuzDBManager->getActiveUsers

2 Replies
Tom
Posts: 506
 Tom
Support
(@tomson)
Honorable Member
Joined: 9 years ago

Hi @para,

Go to Dashboard > wpDiscuz > Tools > Fix Table sub-tab and click the button:

wpDiscuz PHP Error WordPress Database Error Illegal mix of collations
Posts: 6
 para
Topic starter
(@para)
Active Member
Joined: 5 years ago

WOW! That's all I can say for a perfect support and a top plugin.

Thank you Tom

Share: