Can’t upgrade DB

  • Resolved rbaugh

    (@rbaugh)


    2 years, 8 months ago

    We have a site in which WC was updated, but when we try and run the DB upgrade, we keep getting notified that the DB needs to be updated. The WC version is at 6.7.0, but the WC DB version is at 6.6.1.

    I tried to run the WP-CLI option and I get this response:
    Found 2 updates (wc_update_670_purge_comments_count_cache, wc_update_670_delete_deprecated_remote_inbox_notifications_option)
    Updating database 100% [==================================================================================] 0:00 / 0:00
    Success: 2 update functions completed. Database version is 6.6.1

    When running the update through the UI and checking the progress on the status page, I see the same two tasks and then when I refresh they are gone and the Upgrade DB button is back.

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

  • Hi @rbaugh

    Thank you for reaching out!

    Could you please navigate to WooCommerce > Status > Tools, Clear the WooCommerce Transients and Expired Transients and then try updating the database again?

    Also, in order for us to get a better understanding of your site setup, could you please share a copy of your website’s System Status Report?

    You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Thread Starter rbaugh

    (@rbaugh)

    Some of the support report I didn’t want shared on the public since I am managing for a client. But I will try the transients and see what it does. I had cleared the memcache in case it was something with that, but nothing changed.

    Thread Starter rbaugh

    (@rbaugh)

    Once the transients were cleared, the DB update complete showed and the WC DB Version is not matching the WC version.

    Thanks for the info

    We are having the same issue – unfortunately clearing the WooCommerce Transients and Expired Transients did not resolve it for us. Are there other things we can try?

    Plugin Support Sandip Mondal – a11n

    (@sandipmondal)

    Hi @wpuser1234,

    After clearing the cache and transients, have you tried manually updating the database from WooCommerce > Status > Tools and clicking on the Update Database button there?

    Also, I see you have created a thread of your own here. Moving forward, can you please reply to that thread so we can have all the information in one place please?

    Thanks! ??

    I’m having the same issue too with the update database.

    I did the below and still having the issues.
    WooCommerce > Status > Tools, Clear the WooCommerce Transients and Expired Transients and then try updating the database again

    Our analytics has also stopped reporting. In Analytics > orders it’s saying we have no orders from the last two days but we have. The last orders are from the 13th and it’s saying a few of these are still processing but they have been completed and show completed in the WooCommerce > orders page.

    not sure what to do.

    • This reply was modified 2 years, 8 months ago by justaddsalt.
    • This reply was modified 2 years, 8 months ago by justaddsalt.
    Plugin Support Sandip Mondal – a11n

    (@sandipmondal)

    Hi @justaddsalt,

    It seems this issue is caused due to timeout during the database update.

    If you are still getting the above message about the database update then please go to WP-Admin > Tools > Scheduled Actions and run the 2 actions that are stuck?

    The 2 actions arguments will be:

    update_callback => wc_update_670_purge_comments_count_cache

    update_callback => wc_update_670_delete_deprecated_remote_inbox_notifications_option

    Please let us know how it goes! ??

    Thanks for your reply.

    I left the website alone for 24 hours and I came back and the database had updated and the Analytics was working.

    Yay!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Can’t upgrade DB’ is closed to new replies.