Many changes made to the plugin in the past two months required a lot of changes in the database tables structure needed by the plugin. I tryied to include all the proper upgrade procedures but sometimes that’s not enough. Most bugs reported in the past couple of weeks are caused by database problems. This could be either missing table or missing fields in the tables. As of 1.1.6 version, there will be no more changes to database structure for now, and until a new feature that requires new table, current layout will not change.
So, if you experience problems with saving votes (multi ratings mostly), MySQL errors or PHP errors caused by invalid queries, you need to check if your database tables created by GD Star Rating are valid. Some of the problems can also be caused by older version of MySQL database. Since there are (too) many version of MySQL in use right now, I can’t test with every one of them, and some of the versions are known to be defective. With MySQL3 almost is sure that plugin will not work. You will need at least MySQL 4, and I strongly recommend MySQL5.
When you upgrade the plugin, plugin will try to upgrade the database tables from previous version. In 99% of the cases this will work, but sometimes will not depending on server version or previous version of plugin used. Here is the list of tables created by the plugin. Names of the tables are given without table prefix set during the installation of the WordPress since this prefix can vary. Default value of this prefix is wp_.
- gdsr_data_article
- gdsr_data_category
- gdsr_data_comment
- gdsr_ips
- gdsr_moderate
- gdsr_templates
- gdsr_multis
- gdsr_multis_data
- gdsr_multis_trend
- gdsr_multis_values
- gdsr_votes_log
- gdsr_votes_trend
ALL these tables are needed for the plugin to work. Also, you need to check the structure of each table. Full list of all tables with creation queries can be found on the Google Code project wiki page:
http://code.google.com/p/gd-star-rating/wiki/DatabaseTablesFormat
Check if the tables created in your WordPress database are correct. If they are not, you need to fix the problems, and also, please report what problem was in your installation. In this report include errors, MySQL, PHP and plugin version you use. Also include anything else you noticed when you upgraded plugin or WordPress. This will help to fix the problems, and I will include all needed fixes in the future plugin versions.
loading...
Share this:
Comment Link
Hi Milan.
I’ve upgraded from 1.1.4 but now my multi tables do not save their ratings. How do I check my tables to ensure that it will work? Or is that what I’m supposed to do.
My multi tables (see my blog by clicking on my name) are custom and have been included in the post loop of the main index template.
loading...
Comment Link
I don’t see any multi ratings on your website, there are only standard ratings. You need to check tables according to the format layout page in the post. You can use phpMyAdmin or some similar tool for database access.
loading...
Comment Link
Thanks, Milan.
I took the multi ratings out because of this issue.
Once I get this phpMyAdmin, is the idea to simply look them over and if they differ from what you laid out, edit them?
loading...
Comment Link
Hey Milan.
I found the error – when I upgraded to 1.1.7 there was 13 database tables instead of 12. The ‘rogue’ table was located between gdsr_data_comment and gdsr_data_ips and had ‘multi’ in the name (can’t recall the name).
I ‘dropped’ the table through phpmyadmin and right after, my multi blocks were able to save again!!
darren
http://www.timinganddelivery.com
loading...
Comment Link
Hi Milan..
i’ve been reading alot and seems that some people have the same problem as me, Multis are not showing up or saving the votes, but what’s strange in the WP admin under Plugin options multi sets, i can see that every vote is counted.
Very strange is the fact, that i am using 1 set of multis for more than 1 post, but only 1 – the first one is actually recording and saving the votes, others are not.
That means it works, but with some serious bugs.
Any advice?
Pretty much your Star Rating and Multi ratings is the whole reason why i started developing this website. But i can’t seem to get it working properly.
Thanks..
jr
loading...
Comment Link
I am currently reviewing this, and some small bugs are fixed. I expect to solve all the problems with multi ratings in next one or two releases.
loading...
Comment Link
Ok, thanks Milan..
FYI – bug description..
i’m using Star rating v 1.1.6, as 1.1.7 wasn’t showing any stars at all..
So after yesterdays comment i went on and was playing around for a while, until i noticed pattern in the multi star blocks that worked.
Steps:
1) write new post, include [starratingmulti id=1] in the post and upload the post
Result – multi stars block is visible, but will not work, not showing any votes nor saving new votes.
2) go back to admin, edit the new post i just wrote, add another [starratingmulti id=3] (any id), delete the first set string > update the post
result – multi stars are working properly, showing and recording stars.
Hope this gives u some insight in the problem.
jr
loading...
Comment Link
Hi Milan,
after few days of checking your documentation and testing (GD v1.1.8) in this section I found that corresponding to your list of created tables here: http://code.google.com/p/gd-star-rating/wiki/DatabaseTablesFormat
I have one more installed table called “wp_gdsr_data_multi” is it a bug, or…?
loading...
Comment Link
Just ignore it.
loading...