Title: unexpected issue occurred during the database update Last modified: September 8, 2021 --- # unexpected issue occurred during the database update * Resolved [sophisticationdesign](https://wordpress.org/support/users/sophisticationdesign/) * (@sophisticationdesign) * [4 years, 7 months ago](https://wordpress.org/support/topic/unexpected-issue-occurred-during-the-database-update/) * I have an unexpected update error that keeps occurring for the Give WP plugin. I have tried multiple fixes and nothing works. I even tried the health check plugin for Give WP and nothing happens. I don’t even know how to tell what is wrong there is no additional info message just reads: * ** An unexpected issue occurred during the database update which caused it to stop automatically. Please contact support for assistance. Viewing 3 replies - 1 through 3 (of 3 total) * Plugin Support [Rick Alday](https://wordpress.org/support/users/mrdaro/) * (@mrdaro) * [4 years, 7 months ago](https://wordpress.org/support/topic/unexpected-issue-occurred-during-the-database-update/#post-14860701) * Hi [@sophisticationdesign](https://wordpress.org/support/users/sophisticationdesign/), * Happy to help. * For a bit of context, GiveWP 2.10 included some database upgrades in order to provide new features right now and for the future, but some hosts prevented the upgrade from being completed correctly. You’re getting that error that means the migrations didn’t run successfully. * To fix it, do the following: * 1. First, I’d recommend taking a backup of the site that you can confidently restore from. Here’s an article we wrote that explains more clearly how to do that: [https://givewp.com/backup-for-faster-troubleshooting/](https://givewp.com/backup-for-faster-troubleshooting/) 2. Next, enable Advanced Database Updates in Donations > Settings > Advanced. 3. Next, run the update in Donations -> Tools -> Data, and based on the Run Order columns, re-run the create_revenue_table update. If you notice any pending updates, run them as well. 4. Check the logs at Donations > Tools > Logs for errors. If there are any errors, pass those along here. 4. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates. * Thanks! * Thread Starter [sophisticationdesign](https://wordpress.org/support/users/sophisticationdesign/) * (@sophisticationdesign) * [4 years, 7 months ago](https://wordpress.org/support/topic/unexpected-issue-occurred-during-the-database-update/#post-14866864) * So, I tried the instructions you sent. Under data, all of the columns say “Success” but I still got the error. Here’s the log from today – * Error Core Revenue Migration 2021-09-13 14:24:33 An error occurred inserting data into the revenue table * Error Migration Give Core 2021-09-13 14:24:33 Update Pause * Error Migration Give Core 2021-09-13 14:24:33 Update Health Check * Error Migration Give Core 2021-09-13 14:24:29 Update Health Check * Error Migration Give Core 2021-09-13 14:24:29 Update Restart` * Plugin Support [Matheus Martins](https://wordpress.org/support/users/matheusfd/) * (@matheusfd) * [4 years, 7 months ago](https://wordpress.org/support/topic/unexpected-issue-occurred-during-the-database-update/#post-14871123) * Hey [@sophisticationdesign](https://wordpress.org/support/users/sophisticationdesign/), * The error: “An error occurred inserting data into the revenue table” means that something is missing for a donation and the database update won’t continue until it’s fixed. * Probably, you’ll have a similar error to the following: _Error: An error occurred when processing Donation #1575._ * It means that donation #1575 is probably missing some essential data and this is preventing you from running the database upgrade. * Navigate to Donations > Donations and search for 1575. If this is missing a donor, amount, email, or form, then you can edit it. However, if this is entirely corrupt, you can also delete it. * **The donation number here is only an example, so you need to see which is the corrupted donation on your site.** * After that, try to run the database upgrade again. If it gets stuck, then navigate to your logs and check if there are other corrupted donations. If there are, then you can either try to fix them or delete them. Then, repeat this process until the database upgrade is finished. * Please let us know if you have further questions on this or need any additional assistance! Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘unexpected issue occurred during the database update’ is closed to new replies. * ![](https://ps.w.org/give/assets/icon-256x256.jpg?rev=2873287) * [GiveWP - Donation Plugin and Fundraising Platform](https://wordpress.org/plugins/give/) * [Frequently Asked Questions](https://wordpress.org/plugins/give/#faq) * [Support Threads](https://wordpress.org/support/plugin/give/) * [Active Topics](https://wordpress.org/support/plugin/give/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/give/unresolved/) * [Reviews](https://wordpress.org/support/plugin/give/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [update](https://wordpress.org/support/topic-tag/update/) * 3 replies * 3 participants * Last reply from: [Matheus Martins](https://wordpress.org/support/users/matheusfd/) * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/unexpected-issue-occurred-during-the-database-update/#post-14871123) * Status: resolved