Hi
I am using wpDiscuz on my website with lscache plugin which CSS - js minify +combine is disabled
now I see people can not star rate my posts
sometimes I see stars are not clickable and mouse or mobile have not any action on them
and some times, if you rate then after page refresh rating is still 0 and nothing counted
but when I click rating again it shows you can not rate again
I should click rebuild rating in the tools menu and then it shows the rating
I tried both WordPress native ajax and wpDiscuz ajax in settings
and when minification is disabled on my lscache plugin so there is nothing to exclude in cache setting
what should I do now with this?
I am using latest version of both plugins and there is no error in console
@asti this is a sample :
right now stars are not clickable at all!
but after some refresh, it will be clickable but again shows the same rate
till I click rebuild rating in settings
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 `wp_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`))
The wp_ is just a prefic, in your case it can differ.
@asti Hi I had this table before on my database,
now I have deleted it and run your query
but still the same problem
I think it is a site related and no database problem
what about opcache and Redis? both are activated on my website
but any kind of combine or minification for CSS and Js is disabled
Could you please send the admin login details to info[at]gvectors.com email address? I'll ask the developers to check the issue for you.
