AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

AI Assistant

Notifications

Clear all

[Solved] Fix comment rating spam

✦ Summarize Topic

How-to and Troubleshooting

Last Post by Asti 3 years ago

6 Posts

2 Users

0 Reactions

1,284 Views

RSS

Posts: 2

MrBanks2023

Topic starter

Translate ▼

Jan 29, 2023 5:15 am

(@mrbanks2023)

New Member

Joined: 3 years ago

[#6641]

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.

Topic Tags

comment rating spam moderation

5 Replies

Posts: 8217

Asti

Support

Translate ▼

Jan 30, 2023 12:30 pm

(@asti)

Illustrious Member

Joined: 8 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

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

4 Replies

MrBanks2023

(@mrbanks2023)

Joined: 3 years ago

New Member

Posts: 2

Jan 30, 2023 12:45 pm

Reply to

Asti

Translate ▼

@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

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8217

Jan 30, 2023 12:48 pm

Reply to

MrBanks2023

Translate ▼

@mrbanks2023,

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

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8217

Jan 31, 2023 1:00 pm

Reply to

Asti

Translate ▼

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.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8217

Feb 13, 2023 4:27 pm

Reply to

Asti

Translate ▼

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!

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.