• Resolved rhiannonppl

    (@rhiannonppl)


    I updated the GD ratings plugin from a pre-3.0 version to version 3.1. I then upgraded the database to the 3.0 version as instructed. The process said that there were no entries to upgrade. Following this, the site began showing a Critical Error.

    Removing the plugin allows the website to display. How can I restore the ratings plugin in working order?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Milan Petrovic

    (@gdragon)

    What critical error? Also, if you used the plugin before 3.0 and had ratings, the upgrade process would have found them. Which version did you use before? Check out the plugin Tools -> Recheck and Update to see if all database tables are created and OK.

    Thread Starter rhiannonppl

    (@rhiannonppl)

    I’ve reinstated the plugin and the website isn’t producing a Critical Error any more. However, the ratings are not displaying. The votes all appear to exist in the votes log, but each one has ‘Rating method not available’ in the Vote column.

    This is what I see when I attempt to upgrade the database:

    Important
    Upgrade is in progress.
    
    Do not close this page, it will stop the process!
    Processing progress
    * Total of 0 upgrade steps in queue.
    * Process is starting.
    
    * Process has completed.

    The Stop Process button remains ghosted out.

    Plugin Author Milan Petrovic

    (@gdragon)

    It looks like nothing was converted for some reason. Maybe the critical errors from before contained some useful information because right now I am not sure what is wrong. Have you tried this: Check out the plugin Tools -> Recheck and Update to see if all database tables are created and OK?

    Thread Starter rhiannonppl

    (@rhiannonppl)

    Thanks. This is what I see when I do Recheck and Update:

    Database tables
    
    Database Tables Check
    
    [OK] - wp_11_gdrts_itemmeta
    [OK] - wp_11_gdrts_items
    [OK] - wp_11_gdrts_items_basic
    [OK] - wp_11_gdrts_logmeta
    [OK] - wp_11_gdrts_logs
    [OK] - wp_11_gdrts_cache
    Rating templates
    
    Templates list saved.
    Rules Settings
    
    No rules found to convert.
    Plugin Settings
    
    Plugin settings are updated.
    Cache Cleanup
    
    Plugin cache is flushed.
    Plugin Author Milan Petrovic

    (@gdragon)

    Without seeing the data in these tables, I have no idea what can be wrong, I can’t reproduce the problem, and so far no one else reported similar problems. If you can send me database tables export, I can take a look. You can export these 6 tables listed in your previous post (full export, including data), and sent it to: support@dev4press.com.

    Plugin Author Milan Petrovic

    (@gdragon)

    I got the database tables, and I have checked them out. All the data is generated by GD Rating System Pro, not Lite version, because there are Thumbs Ratings and Emote This ratings logged, and there is not a single Stars Rating entry anywhere. That is why the upgrade displayed 0 steps for upgrade because the Lite version can only upgrade Stars Rating method data, it doesn’t include Thumbs or Emotes. And, that is why you got critical errors, it has methods that are not available in Lite version.

    I don’t know why you updated to this new Lite version of the plugin, if you have Pro plugin already installed, but the only way for the data you have to continue working is to continue using Pro version, Lite doesn’t have the rating methods you use.

    Thread Starter rhiannonppl

    (@rhiannonppl)

    OK. So I shouldn’t use the in-built WordPress upgrade system, because that will install Lite instead of Pro? Got you. Thanks for your help!

    Plugin Author Milan Petrovic

    (@gdragon)

    Pro version uses higher numbers for version (currently 4.2), but you must have been using some Pro version older than 3.0 (Pro version 3.0 was released 2 years ago), and when Lite got to 3.0, WordPress found it as the update.

    Plugin Author Milan Petrovic

    (@gdragon)

    Also, once you update the Pro version, you have to go through the Database Upgrade. Since you had 3.0 Lite installed, some things might be set wrong, and the plugin was not designed to handle Pro to Lite downgrade and upgrade to Pro again, so if you don’t get Database Upgrade prompt, make sure to go to plugin Tools -> Database 4.0 to run the upgrade properly.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Critical error after upgrading database’ is closed to new replies.