going back to v2.7.1 fixes the vote registration problem but I couldn’t use that version because v3 has changed the database columns in a way that v2.7.1 can’t recalculate ratings out of that so everything goes back to zero after recalculation. So I had to continue to use v3 which has the problems I described above.
Any ideas?
Also it’s odd that when recalculating there is about 500 item difference in what v2.7.1 sees and what v3 sees. (v2.7.1 sees 500 more items)
In a new WP installation, I can see that when user rates there is a “stars-rating_distribution” in “gdrts_itemmeta” in the DB.
I believe This is not present in my current website’s DB at all …
So I think this is the culprit but I don’t know how to fix it.
I think something is not converted well when I upgraded even though I followed the upgrading instructions.
Not sure if it makes a difference but on the website that I have these problems we are using MariaDB and not MySQL.
-
This reply was modified 4 years, 6 months ago by
metalsoft.
The tool for the conversion to 3.0 format clearly says that after conversion, old data will be removed and that you create the DB backup. There is no way to downgrade from 3.0 DB format to 2.7.
Can you give me the URL where the rating is active, so I can check out the HTML of the page for the rating block?
Milan
I understand that. My problem is new votes don’t show up on my website anymore.
As for the URL since this is shown publicly I kind of don’t want to give any URLs to my website.
HTML is fine since i can see all the votes in “Votes log” and “Ratings Items” the thing is “stars-rating_distribution” doesn’t show up in “gdrts_itemmeta” table in my website’s DB.
If users can vote, and votes are stored, but you don’t see them on the frontend, most likely the issue is the cache (page HTML is cached). Plugin has Dynamic Load addon (enable it in Settings -> Extension) that will load rating blocks via AJAX.
I checked Dynamic Load and it didn’t make a difference.
On a clean installation, I can see that whenever a user votes there is a new entry in DB “stars-rating_distribution” in the table “gdrts_itemmeta”
For my website this doesn’t happen I don’t get these entries in my DB and I think this is the problem.
even after recalculation, the entries that I mentioned don’t show up.
I have run the tests on a few websites, and I even forced deleted the distribution keys, and they get recreated when using recalculation.
Do you have any errors in the server PHP error log?
I don’t see errors, only a few warnings but not for this plugin and they don’t seem to be related.
On my server we are using MariaDB. Could this be the problem? if so, do you have any suggestions to fix it?
Also is there any way I can export all my ratings data, Delete everything, reinstall the plugin, and reimport ratings data back in the plugin? I saw the option to export the plugin’s settings but nothing to export ratings data.
-
This reply was modified 4 years, 6 months ago by metalsoft.
I use on different servers and for developing different versions of MySQL, Percona, MariaDB, and I had no issues with any of theme. If the database was the issue, there would be an error logged somewhere. I have seen issues in WordPress caused by different DB versions, but they always have errors logged, there is no way for DB query to silently fail, if the server is configured to log errors. I can’t fix the issue that I can’t identify.
In the past two weeks I have run plugin on various servers, various WordPress versions, and I had no major issues. Few bugs reported are already identified and fixed.
Rating data is connected via IDs to other WordPress data, and exporting them to import on other websites is not an option. If you transfer the database, all data has to go together. So, there is no way to export data only.
1. Do you use some sort of DB cache method, if the database queries are cached, that can be the issue. I never used any sort of DB cache that caches the queries, because it gives false results all the time. There are plenty of cache systems in the server that are better then plugins for WordPress caching DB queries.
2. I am willing to test the issues with your website, but the only way to do it, is for you to send me whole website backup I can unpack and use locally and debug what can be the problem. If you want to do that, let me know.
Milan
I appreciate your willingness to help me out. I will run a few more tests and get back to you on that.
So I tweaked so many things that honestly I can’t really remember all of them (including changing the priority of stars, multiple rechecks, deleting so many votes and etc) but right now ratings are working on new posts again.
For old posts, all that came to my mind was creating a duplicate, deleting the old one, and setting the URL to the URL of the old post …. a bad solution but still a solution because I can’t think of anything else.
I am not sure why that happens, but it looks like some underlying issue that I simply can’t reproduce without testing your data.
