SQL error upgrade from v1.8.7 `hide`

  • There is an error with the upgrade callback in grw.php

    grw_exist_install()

    case version_compare($last_active_version, ‘1.8.7’, ‘<‘):

    If the version you are on is in fact 1.8.7, the SQL query to add hide to the DB doesn’t run and therefore you get SQL errors in error_log.

    Should be less than or equals:

    case version_compare($last_active_version, ‘1.8.7’, ‘<=’):

    Run this, replacing the wp prefix if you’re getting the same thing, until plugin is updated.

    ALTER TABLE wp_grp_google_review ADD hide VARCHAR(1) DEFAULT ” NOT NULL;

Viewing 1 replies (of 1 total)
  • Plugin Author richplugins

    (@richplugins)

    Hi @smithpress1,

    Thank you for your help to improve the plugin, it’s great!

    I have a question, before we change the code. Why we need to change the less to less or equals if the version 1.8.7 has already contains the ‘hide’ attribute in the database structure, you can see it in the ‘grw_install_db’ function, line 199.

    In other words, if the user installed the version 1.8.7 (without updating the old one version), he get the ‘hide’ attribute in the database initialization.

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘SQL error upgrade from v1.8.7 `hide`’ is closed to new replies.