Woocommerce-admin: database update done persists

[7thcirclegit]

After updating to 4.0.1 and updating the db, the notice... WooCommerce database update done
reappears after clicking thanks

[ben72]

+1
I'm seeing the same issue on multiple sites I've updated. Not all though.

[juliaamosova]

Hi @7thcirclegit,

Thank you for reporting the issue. The DB update notice you describe is a part of WooCommerce Admin functionality which is being developed in another repository: https://github.com/woocommerce/woocommerce-admin.

I am going to move your bug report there so that the right team could take a look further.

[timmyc]

Hello @7thcirclegit and @ben72 - apologies for you all hitting this bug. We have a fix in progress for this, but I'm going to close this issue in favor of the original report #3497

If you would like, I've also created a quick plugin that will set the DB notice as "actioned" and remove it from your Woo pages.

The plugin can be found here: https://gist.github.com/timmyc/ee0c6f4cb3ed82620efaa16386e62c6b

You could copy that into any other plugin/functions file as well, but once it has run one time, you can disable/remove the code.

[ben72]

Thanks @timmyc! This works on all sites it was needed on. Some of the sites had cured themselves. Do you know why this happened on just some sites?

[timmyc]

@ben72 glad it worked out for you. If someone clicks on the action button in the notice within 24 hours of it being created - then all is fine as the nonce value that was stored in the action is still valid. The bug only happens when the db update happens, the notice is created, and nobody clicks the button within that first 24 hours.

[7thcirclegit]

That is incorrect. The db update can be performed immediately after woocommerce update, and then clicking on "thanks" and it still fails.

[ben72]

@timmyc Yes, it's like @7thcirclegit says. I clicked update and then the button to close the finished notice just a little while later and it took me to a page that didn't exist. And the notice would not go away.

[7thcirclegit]

I never got an error, the message just stayed or reappeared. I ended up fixing this by editing the db manually

the easiest fix is… In the xxx_wc_admin_notes table I updated wc-update-db-reminder from unactioned to actioned

[ben72]

This happened on a few sites even with the latest update.

[timmyc]

@ben72 indeed if the notice action is not clicked on within the nonce expiry time limit, the bug persists. The team over in woocommerce/woocommerce is aware and looking into it. Deleting the notice from the db, or using the fixer plugin above should remedy

[bozzmedia]

I can confirm that this remains an issue on 4.5.2

[eazylaykzy]

I never got an error, the message just stayed or reappeared. I ended up fixing this by editing the db manually

the easiest fix is… In the xxx_wc_admin_notes table I updated wc-update-db-reminder from unactioned to actioned

This remains an issue on Version 4.7.1, it persisted no matter how many times I click the "Thanks!" button.
Thanks to @7thcirclegit tweak to the DB, this actually fixed mine.