Database out of sync

  • Resolved mjsheldonwp

    (@mjsheldonwp)


    4 years, 7 months ago

    I updated the ZipRecipes plugin to 6.4.2, which possibly skipped a couple versions.
    Now I cannot save new recipes, and the error logs are showing issues with missing columns.

    database error Unknown column ‘json_image_1x1’ in ‘field list’ for query UPDATE wp_amd_zlrecipe_recipes

    Is there a way I can tell the plugin to refresh the database table schema?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    Hi @mjsheldonwp,

    Sorry to hear you’re having trouble updating.
    The plugin is designed to run the upgrade when the version changes, so it’s strange the upgrade didn’t run.

    Can you try to change in the file zip-recipes.php in wp-content/plugins/zip-recipes on line 44

    define(‘ZRDN_VERSION_NUM’, ‘6.4.2’);

    to for example 6.4.2.1?

    This should force the upgrade to run again.

    Let me know if this helps!

    Rogier

    Thread Starter mjsheldonwp

    (@mjsheldonwp)

    Turns out the update didn’t run completely because the user did not have ALTER privileges. Prob removed at some point for security.
    And wordpress did not forward those errors to the UI during the update.

    I manually added the columns I found that were missing, but I’ll reset the version to make sure I didn’t miss anything.

    Great you resolved the issue!
    Let me know if you have any questions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database out of sync’ is closed to new replies.