[Solved] Comments rating problem

✦ Summarize Topic

How-to and Troubleshooting

Last Post by Arsaces7 6 years ago

4 Posts

2 Users

0 Reactions

1,554 Views

RSS

Posts: 8

Arsaces7

Topic starter

Translate ▼

Jun 14, 2020 7:21 pm

(@arsaces7)

Active Member

Joined: 6 years ago

[#365]

with latest update there is a problem with rating and each user can rate unlimited!

i did the structure in this post

https://wpdiscuz.com/community/f-a-q/limit-comment-likes-unlimited-voting-problem/

and deleted all the cache but not solved the problem

3 Replies

Posts: 8208

Asti

Support

Translate ▼

Jun 16, 2020 1:20 pm

(@asti)

Illustrious Member

Joined: 8 years ago

Hi @arsaces7,

You should execute this SQL query in phpMyAdmin database manager SQL Tab. You can install phpMyAdmin plugin, or use your Hosting Service cPanel > phpMyAdmin Database Manager > Your website Database > SQL Tab, it should solve the issue:

CREATE TABLE `t_wpd_wc_users_rated` (`id` INT(11) NOT NULL AUTO_INCREMENT, `post_id` INT(11) NOT NULL DEFAULT 0, `user_id` INT(11) NOT NULL DEFAULT 0, `user_ip` VARCHAR(32) NOT NULL DEFAULT '', `rating` INT(11) NOT NULL, `date` INT(11) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `post_id` (`post_id`), KEY `user_id` (`user_id`));

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.