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

[Solved] Fix comment rating spam

6 Posts
2 Users
0 Reactions
623 Views
Posts: 2
Topic starter
(@mrbanks2023)
New Member
Joined: 2 years 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: 7516
 Asti
Support
(@asti)
Illustrious Member
Joined: 7 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: 2 years 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: 7 years ago

Illustrious Member
Posts: 7516

@mrbanks2023,

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

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

Illustrious Member
Posts: 7516

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: 7 years ago

Illustrious Member
Posts: 7516

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: