Hi @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/
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!
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`
Hey @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!
