wpDiscuz - WordPress Comment Plugin
Fix comment rating ...
 
Share:
Notifications
Clear all

[Solved] Fix comment rating spam

6 Posts
2 Users
0 Likes
282 Views
Posts: 2
Topic starter
(@mrbanks2023)
New Member
Joined: 10 months ago

We had a troll come to our website and place negative downvotes on all of the comments on a particular article. Is there a way to fix this/change the ratings on comments so they are all not negative? is there a way to prevent this in the future? Thank you.

5 Replies
Asti
Posts: 6742
 Asti
Support
(@asti)
Illustrious Member
Joined: 6 years ago

@mrbanks2023,

Is there a way to fix this/change the ratings on comments so they are all not negative?

You can use the "Remove Vote Data", but this will remove the whole data the positive and the negative as well. Otherwise, you can delete it from the database.Β 

Is there a way to fix this/change the ratings on comments so they are all not negative

To prevent this you can use the "Allow Guests to Vote for Comments" option. Just disable it. More info here: https://wpdiscuz.com/docs/wpdiscuz-7/plugin-settings/comment-thread-features/#voting-liking-buttons

4 Replies
(@mrbanks2023)
Joined: 10 months ago

New Member
Posts: 2

@asti Hi. Thank you for the response. Is it possible to remove vote data from just one article...as only one article is affected?

Asti
 Asti
Support
(@asti)
Joined: 6 years ago

Illustrious Member
Posts: 6742

@mrbanks2023,

I'll ask the developers and let you know ASAP.Β 

Asti
 Asti
Support
(@asti)
Joined: 6 years ago

Illustrious Member
Posts: 6742

You

Please use theΒ phpMyAdmin pluginΒ orΒ the same tool in your hosting cPanel, go to the website WordPress database, open the SQL Tab, paste the following SQL and execute it (press ok).

If the prefix of your DB tables is notΒ wp_, you should change it in the SQL before using it:

XX should be replaced with the current post ID.Β 

UPDATE `wp_comments` c
LEFT JOIN `wp_commentmeta` cm ON c.comment_ID = cm.comment_id
SET `meta_value` = ''
WHERE (cm.`meta_key` = 'wpdiscuz_votes' OR cm.`meta_key` = 'wpdiscuz_votes_seperate')
AND c.`comment_post_ID` = XX;

DELETE FROM `wp_wc_users_voted` WHERE `post_id` = XX;

Please make a backup of the database before executing the code.Β 

Asti
 Asti
Support
(@asti)
Joined: 6 years ago

Illustrious Member
Posts: 6742

We have not received a reply from you for over a couple of weeks, therefore we will be closing this topic. Please create a new one if you require any additional help.

Thank You!

Share: