Title: database error – will not update Last modified: June 30, 2025 --- # database error – will not update * Resolved [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-will-not-update/) * 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 15 replies - 1 through 15 (of 35 total) 1 [2](https://wordpress.org/support/topic/database-error-will-not-update/page/2/?output_format=md) [3](https://wordpress.org/support/topic/database-error-will-not-update/page/3/?output_format=md) [→](https://wordpress.org/support/topic/database-error-will-not-update/page/2/?output_format=md) * [Nagesh Pai](https://wordpress.org/support/users/nagpai/) * (@nagpai) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18535320) * Hi [@darbyohara](https://wordpress.org/support/users/darbyohara/), sorry to see you face this annoying error. One reason this can happen is if there is a plugin or some code on your site that is changing the logged-in privilege of your user. To help troubleshoot this better can you share the System Status report of your site. You can get it from `WooCommerce > Status > Get system report` . Copy the report on [https://pastebin.com](https://pastebin.com) or [https://gist.github.com](https://gist.github.com) and share the link of that here ( since it will be too lengthy to paste it all here ) * If you have access to WP command line ( WP CLI ) , try running this command –` wp wc update` See if this helps. You may also want to reattempt the update and check `WooCommerce > Status > Logs` to see if there are any logs around the time of your attempt. If you have anything there, you can share it here. * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18535607) * Thanks for the reply. As I stated in the original post, ALL plugins were disabled except for woocommerce. So it can’t be a plugin issue as SO MANY people want to blame. I posted the log to pastebin and the url is: [https://pastebin.com/LCP00beg](https://pastebin.com/LCP00beg) * I have no clue what WP CLI is or how to get it. After a google search, it appears one has to compile the dumb thing. Lovely! I don’t have that ability. Let me know if you see anything in the log. Thanks. * [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/) * (@mosesmedh) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18535985) * Hi [@darbyohara](https://wordpress.org/support/users/darbyohara/), * Thank you for the detailed explanation and for sharing your system report. I completely understand how frustrating it can be when you’ve already tried multiple troubleshooting steps and still aren’t sure how to resolve the issue. * From the report you shared, it looks like your database is already up to date. In most cases, when the update database notice keeps reappearing, it’s often caused by a caching issue or a conflict with another plugin or theme that’s incorrectly triggering the notice. * Let’s start by repairing the database in case there’s a hidden issue causing this behavior. Please open your wp-config.php file and add the following line just before the line that says /* That’s all, stop editing! */: * ```wp-block-code define('WP_ALLOW_REPAIR', true); ``` * Once that’s added, go to this link in your browser (while logged in as an administrator): * **[https://abovecreations.com/wp-admin/maint/repair.php](https://abovecreations.com/wp-admin/maint/repair.php)** * Then select the **“Repair and Optimize Database”** option. After running the repair, remove the line you added from your wp-config.php file. It’s also a good idea to back up your site before making these changes. * After the repair, please clear your browser cache, site cache, server cache, and any CDN cache if you’re using one, and then check if the database update notice still appears. * Looking forward to hearing how it goes. * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18538906) * Hi Moses. I did the config.php and ran the link. It completed checking all databases, but it failed to optimize on every one. Then I removed that line in the config. php. Then you said to browser cache, site cache, server cache, and any CDN cache. I only know the browser cache. I have no idea where to find the site or server cache. No idea what CDN is, so I guess it doesn’t apply. But I am still getting the “update woocommerce database” on nearly every page in the settings. Very annoying! If I hit the update button, it goes to a new page that simply says “ Sorry, you are not allowed to access this page.” Are there any other suggestions. I spent a lot of time on my store/product page and hate to lose anything. * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18538981) * Hi there! * Thank you for the update — I completely understand how frustrating this must be, especially after all the time you’ve invested in setting up your store. * To assist you further, I recommend reaching out to your hosting support team and asking them to **flush or temporarily disable any server-side cache**, then check if the issue persists. * If that doesn’t help, could you please create a **staging site** for testing purposes? Once set up, try deactivating and then reactivating the WooCommerce plugin to see if the update notice disappears. * You can use the following plugin to create a staging site: 🔗 [https://wordpress.org/plugins/wp-staging/](https://wordpress.org/plugins/wp-staging/) * Let me know how it goes! * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18539213) * I ran the flush cache on my server side dashboard. I now get “WooCommerce database update complete. Thank you for updating to the latest version!” on the website dashboard, but STILL get the window to update the database. Grrrrrr. Once agin, when I hit the update button, it goes to a new page and states “Sorry, you are not allowed to access this page.” This is so ridiculous! * [Mahfuzur Rahman](https://wordpress.org/support/users/mahfuzurwp/) * (@mahfuzurwp) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18539284) * Hi [@darbyohara](https://wordpress.org/support/users/darbyohara/), * Thanks for the update, and I hear you — that persistent notice is definitely frustrating. * Since the database update message still appears even after clearing the cache and seeing the “update complete” message, it suggests that the option WooCommerce uses to track the database version may not be updating correctly. * Here’s what you can check next: 1. **Ask your hosting provider** to help you check the database directly. Specifically, they can look in the `wp_options` table for an entry called `_wc_version`. 2. - If that value doesn’t match your current WooCommerce plugin version (for example, `9.9.5`), ask them to update it to match. - WooCommerce uses that value to determine if the database is up to date, so correcting it may stop the message from reappearing. 3. **Double-check your user permissions** — the “Sorry, you are not allowed to access this page” error can happen if your admin account is missing the `manage_woocommerce` capability. You can use a plugin like [User Role Editor](https://wordpress.org/plugins/user-role-editor/) to review and adjust your current role if needed. * Let us know how it goes! * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18541006) * I used the phpadmin to browse the database and in the wp_options, there is no _wc_version. It is called woocommerce_version and woocommerce_db_version. Both have 9.9.5 So it isn’t that. * I installed that user role plugin and viewed the admin roles and everything is checked. Including everything in the woocommerce. So the issue is not that. * As before, on the dashboard and the plugins screen, I get the top message that the woocommerce database has been updated. It appears everytime I pull those up. I goto woocommerce screen and the top message is that it wants me to update the database. I again click that and it takes me to the blank page that says “ Sorry, you are not allowed to access this page.” I don’t know what else to do, this is so frustrating! * [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/) * (@mosesmedh) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18541140) * Hi [@darbyohara](https://wordpress.org/support/users/darbyohara/), * Thanks for the detailed clarification. At this stage, it would be helpful to run a conflict test. Please create a copy of your live site on a subdomain or directory using WP Migrate Guru. Once done, deactivate all plugins except WooCommerce and switch the theme to Storefront on the copied site. Then, try updating the database again and let us know whether the update goes through or if the issue still persists. * Your feedback from this test will help guide the next steps to resolve the issue on your live site. * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542014) * Hi Moses. Thanks for trying to help. Unfortunately I have no idea what WP Migrate Guru is. I google it and it makes no sense to me. It appears it wants to make a working clone of my website. But it just doesn’t make sense. I can turn off ALL plugins on my website except woocommerce but still get that error. EVERYONE keeps blaming or pointing to my web server or my plugins. But NO ONE is ddressing the elephant in the room. Woocommerce plugin. The plugin worked fine for years on my website. It HAD to be a woocommerce update that spoiled my website. I am at a point of destroying the website and databases and start a new. Is there a way to backup the store products, but nothing else? The product page is merely a wp page, so I can copy n paste the contents. But not the actual database content sense it hasalot of media data. * Again, I am at a lost and I can’t believe I am the only one with this issue. * [Nagesh Pai](https://wordpress.org/support/users/nagpai/) * (@nagpai) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542087) * I understand this is very frustrating, but had this been a widespread issue with WooCommerce, there would be several similar complaints and a definite way to reproduce this error. There is something specific with your setup, which at the moment is difficult to trace unless we have direct access. The forum guidelines here prevent us from having direct admin access to your website. It would be better if you get help from some expert familiar with WooCommerce. I found some more clues though. The issue of seeing “Sorry, you are not allowed to access this page”, happens when the particular page does not see your session cookie identifying you as an admin. This in my experience, usually happens due to either: - A security plugin being over-allergic blocking a legit user . I am seeing several 403 Forbidden errors in the browser console, when I try to even select an option on your product page. When I try to add to cart, I see an error saying that I am not allowed. * Screenshot: [https://snipboard.io/2olLFY.jpg](https://snipboard.io/2olLFY.jpg) * ![](https://i0.wp.com/snipboard.io/2olLFY.jpg?ssl=1) * Sometimes, even if we disable the security plugin, the rules remain in the config of the site. Thats why it would be better to test this on a copy of the site with all other plugins deleted, and with either storefront or TwentyTwentyFour theme. Other reasons…. - Stale cache due to cacheing plugin, or cacheing offered by your host ( I think your host provides Litespeed .. ask them to clear the cache once, or see if your CPanel has that option ) - Ad blockers on your browser. If you have those turned on please try turning it off momentarily. Also try using a different browser – if you are using Safari, for eg., switch to Chrome. * I do not wish to annoy you, but based on what I see, I would like to offer these suggestions. Thanks and I hope your issue gets resolved at the earliest! * Thread Starter [DarbyOhara](https://wordpress.org/support/users/darbyohara/) * (@darbyohara) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542141) * Ok. I honestly don’t think creating a copy of the website to a new url will make a difference because although this current website is online and active, it is still in the building phase. That said, I understand that just disabling a plugin may not completely turn it’s features off. THAT should be against the rules, but who would enforce that. Anyway, I have DELETED all security related plugins. * The only plugins remain installed are the woocommerce plugins, akismet, user roll and the WP Mail SMTP plugins. I again cleared ALL cache from my server cpanel. I don’t have the litespeed enabled on my cpanel. I logged out of my admin account and went to the Shop and made selections. I didn’t get any forbidden errors and the selection to the cart went smoothly. Incidently, I am using Chrome browser and I use the GeneratePress theme. Once again, I logged into my admin, on my dashboard a message states that the woocommerce database was updated. I then go to woocommerce and at the top again is the message to update the database and I hit update and I get the ‘not allowed’ error. * You suggest to seek a woocommerce expert? I think that is WHY I am here. It is the woocommerce support page and someone should have some knowledge of the plugin and it’s database. It seems the store is running fine although as admin I am getting the update database and error, I guess I will have to live with it * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542204) * Hi there! Thank you for the detailed update, and I completely understand how frustrating this situation must be especially when things seem to be working on the front end, but you’re still running into issues as the admin. * I really appreciate all the steps you’ve already taken, and since the issue still persists, I’d recommend trying just one more thing: * Please try the following steps: 1. **Deactivate all plugins**, including WooCommerce. 2. **Switch to a default WordPress theme** like Twenty Twenty-Four. 3. **Delete the WooCommerce plugin.** 4. **Reinstall WooCommerce** from Plugins > Add New. * Before doing this, I highly recommend taking a full backup of your site to avoid any data loss. You can also try this on a staging copy of your site to be safe. If you don’t already have one, the [WP Staging plugin](https://wordpress.org/plugins/wp-staging/) is a great tool to quickly set up a staging environment. * Once reinstalled, check if the database update error still occurs. This will help rule out any residual corruption or permission issues tied to the current installation. * Let me know how it goes—I’m here to help! * [Nagesh Pai](https://wordpress.org/support/users/nagpai/) * (@nagpai) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542313) * > You suggest to seek a woocommerce expert? I think that is WHY I am here. It > is the woocommerce support page and someone should have some knowledge of the > plugin and it’s database. It seems the store is running fine although as admin > I am getting the update database and error, I guess I will have to live with > it * You are more than welcome to share more information and continue seeking support here. The volunteers and staff here will do there best to help you troubleshoot. It may take a few iterations here though to completely understand what is happening on your site. My apologies, since I got mixed up with another discussion where the user was insisting on us directly accessing their site. Further – Since you have disabled the security plugin, I am now able to see the cart page correctly. The 403 errors are no longer visible in the browser console. I am curious to find a solution to this issue! I did a deeper search in WooCommerce GitHub repo and [found an issue](https://github.com/woocommerce/woocommerce/issues/50552) that tells us more about this “not allowed” page. Can you confirm if the page that says “Sorry you are not allowed to access this page”, looks like the screenshot below? : * ![](https://i0.wp.com/private-user-images.githubusercontent.com/417342/356676970- 010ee15c-7cfa-46c8-b900-adad21e866f0.png?ssl=1) * If yes, then this message need not be a permission issue at all. It could indicate that the link which you click on the banner is no longer valid ( if the database update is successfully done ) . It is likely that the database update has been done successfully, but due to some reason, the flag that disables the update pending banner is not deactivated. Thats why it keeps showing, and when you click the link, it leads to an invalid page, which shows a misleading message. Can you copy here, the link that you see on the address bar when you click the Update button? Ref: GitHub Issue on misleading message : [https://github.com/woocommerce/woocommerce/issues/50552](https://github.com/woocommerce/woocommerce/issues/50552) * [Nagesh Pai](https://wordpress.org/support/users/nagpai/) * (@nagpai) * [11 months, 1 week ago](https://wordpress.org/support/topic/database-error-will-not-update/#post-18542315) * It will also be helpful if you can open the browser console in chrome dev tools.( Right click on the browser window with the page open, click “Inspect”, and click the “Console” tab ) . Once the tab is open, click the “update” link in the banner, and send a screenshot of the console, where there may be a few errors logged. This will help troubleshoot too. Thanks. Viewing 15 replies - 1 through 15 (of 35 total) 1 [2](https://wordpress.org/support/topic/database-error-will-not-update/page/2/?output_format=md) [3](https://wordpress.org/support/topic/database-error-will-not-update/page/3/?output_format=md) [→](https://wordpress.org/support/topic/database-error-will-not-update/page/2/?output_format=md) The topic ‘database error – will not update’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * 36 replies * 6 participants * Last reply from: [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/) * Last activity: [11 months ago](https://wordpress.org/support/topic/database-error-will-not-update/page/3/#post-18551244) * Status: resolved