database error – will not update

  • Resolved DarbyOhara

    (@darbyohara)


    11 months ago

    I’ve searched and searched for help. I haven’t messed with my website for quite a few months (personal issues), but now I need to get it up and running to sell my crafts with woocommerce. A window on top woocommerce CONSTANTLY tells me to update the database. I hit the update button and it immediately errors on a new page saying “Sorry, you are not allowed to access this page.”. I’ve turned off ALL plugins and still the same. I’ve validated the database header in the login.php file to the header on my phpadmin. Still the same one since I created the website in 2016. I tried to run the database update in woocommerce/status/tools/ It tells me it is scheduled in the background. But if I look in the scheduled actions, nothing. Of course as soon as I hit the update, that window on top warning to update the database. I even ftp to my website and completely deleted the woocommerce plugin since the delete is greyed out in the plugins section. When I reinstalled woocommerce, everything is the same, like it never got deleted. I am pulling my hair out how to fix this. Can anyone help please?

Viewing 5 replies - 31 through 35 (of 35 total)
1 2 3
  • Moses M. (woo-hc)

    (@mosesmedh)

    10 months, 3 weeks ago

    Hi @darbyohara,

    It looks like you didn’t include a screenshot in your last response. Could you please share a screenshot of the update notice you’re seeing using snipboard.io?

    Thread Starter DarbyOhara

    (@darbyohara)

    10 months, 3 weeks ago

    https://snipboard.io/CbDgNx.jpg

    Sai (woo-hc)

    (@saivutukuru)

    10 months, 2 weeks ago

    Thanks again for your patience!

    To resolve this, one advanced step would be to update a specific record in your site’s database. Here’s how:

    1. Access the wc_admin_notes table via your database.
    2. Find the row named wc-update-db-reminder with the title WooCommerce update required
    3. Change its status from unactioned to actioned.

    Please make sure to back up your site before making any changes, or ask a developer to help if you’re not comfortable working with the database directly.

    Let us know if you need help with any part of this!

    • This reply was modified 10 months, 2 weeks ago by Sai (woo-hc).
    Thread Starter DarbyOhara

    (@darbyohara)

    10 months, 2 weeks ago

    WooooHoooo! THAT worked! The message window to update the woocommerce database is now gone. I’m not an expert in this, but will it effect anything else? Not sure why the original setting wasn’t ‘actioned’ in the first place?

    Thanks again for all your help guys. I really appreciate it!

    Moses M. (woo-hc)

    (@mosesmedh)

    10 months, 2 weeks ago

    Hi @darbyohara,

    That’s great to hear! I’m glad the support was helpful and that the issue is now resolved.

    To answer your question — this won’t impact anything on your site. That value should already be the default if your database is up to date. In your case, the update did complete successfully, but the notice just got stuck and wasn’t marked as actioned.

    Manually changing it won’t cause any problems.

    Since everything’s sorted, and if you found the support helpful, we’d really appreciate it if you could take a moment to leave us a review here: https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/#new-post

Viewing 5 replies - 31 through 35 (of 35 total)
1 2 3

The topic ‘database error – will not update’ is closed to new replies.