Dashboard and hottest comment thread

[Matthias]

Hi at wpdiscuz,
1. I have wrong statistics in the wpdiscuz dashboard.
It says there are 32000 guest comments? I don’t know where thes guest comments are.
I have only 2500 blog comments and 3000 reviews in easy digital downloads review plugin?

2. The flash symbol to show the most voted comment does not work. On my site it shows a comment with one vote, but there is a comment with 3 votes?
https://gtauscht.de/material-dilemma/

Do you have any suggestions?
Thanks
Matthias

[gVectors Team]

Hi @matthias70,
Could you please check the wp_comments table of your WordPress database? Just install the phpMyAdmin plugin or use your Hosting cPanel > phpMyAdmin Database manager and check this table. First see, how many rows are there:

Then navigate to SQL tab and execute this query to see how many comment types you have in the database. If the wp_ prefix is different in your database, please change it before executing:

SELECT comment_type FROM wp_comments GROUP BY comment_type 

[Matthias]

I just hesitate to execute your query, cause I see there are lots of easy digital download payment notes in this table?
What happens with them, when I execute your code line?
Thanks
Matthias

[gVectors Team]

Could you show the screenshot of the result?
I think other plugins use that table and insert non-comment data, so wpDiscuz can’t recognize if those data are simple comments of not. I want to see what comment type they use. This will help us add some filters in future releases.

[Matthias]

So here is the result
https://i.ibb.co/VS3Wnq5/comments.jpg
Thanks
Matthias

• This reply was modified 4 years, 5 months ago by Matthias.
• This reply was modified 4 years, 5 months ago by Matthias.
• This reply was modified 4 years, 5 months ago by Matthias.

[gVectors Team]

Ok, all is clear, you have about 30,000 payment notes, this is way you see that statistic. We’ll add an option to filter comments in future releases. The ‘edd_payment_note’ will be filtered too. Currently, there is no solution I can provide you, because the problem is not from wpDiscuz side.

[Matthias]

O.K. I think edd is working on an different database structure for their new release.

What about my second problem?

2. The flash symbol to show the most voted comment does not work. On my site it shows a comment with one vote, but there is a comment with 3 votes?
https://gtauscht.de/material-dilemma/

[gVectors Team]

Regarding this issue:

2. The flash symbol to show the most voted comment does not work. On my site it shows a comment with one vote, but there is a comment with 3 votes?
https://gtauscht.de/material-dilemma/

I think it’s translated incorrect. Saying The Hottest comment thread (fire icon) we mean the thread with most number of replies, not with the most number of votes.

The most reacted button (bolt icon) brings the comment with most number of likes/dislikes. Currently, you use the total number of like/dislikes so you don’t see how many votes were done. You see 1 like but it maybe 3 likes and 2 dislikes, so the total votes of that comment could be 5. You can enable dislikes and the separate modes to see the real numbers. Here is the doc: https://wpdiscuz.com/docs/wpdiscuz-7/plugin-settings/comment-thread-features/#voting-liking-buttons

[Matthias]

So I changed the setting to show likes and dislikes with separate numbers, but the button still shows a comment with 1 like and there is a comment above with 3 likes…?
https://gtauscht.de/material-dilemma/

[gVectors Team]

Ok @matthias70,
Please navigate to Dashboard > wpDiscuz > Tools admin page and check the regenerate buttons in following Tabs:

• Regenerate Vote Metas
• Regenerate Vote Data
• Synchronize Commenters Data

If all are inactive, then all are already regenerated and the problem comes from your database. It can’t correctly order the SQL result. Something wrong with the table or saved vote data. And, for further support you should open a new support topic in wpDiscuz forum: https://wpdiscuz.com/community/