[Solved] Comments rating problem

How-to and Troubleshooting

Last Post by Arsaces7 5 years ago

4 Posts

2 Users

0 Reactions

976 Views

RSS

Posts: 8

Arsaces7

Topic starter

Jun 14, 2020 3:21 pm

(@arsaces7)

Active Member

Joined: 5 years ago

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: 7664

Asti

Support

Jun 16, 2020 9:20 am

(@asti)

Illustrious Member

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