Error occurred when processing donation #153

Hi, @gandolfslayer.

I’m glad you reached out. I can certainly help you with this issue.

This is usually an indication that GiveWP is trying to upgrade the database but it’s hitting a roadblock. For a bit of context, the latest GiveWP updates included some database upgrades in order to provide new features right now and for the future.

For the error you are seeing, “Error:An error occurred when processing Donation #153. To insert revenue, please provide valid donation_id, form_id, amount.”, here is how to fix it:

The issue here is related to Donations (likely very old ones) that have somehow become detached from their donation form in the database. From your error message, I see that it’s currently hung up on donation #153:

“Error:An error occurred when processing Donation #153. To insert revenue, please provide valid donation_id, form_id, amount.”

The slightly boring technical explanation of what’s going on there: the update routine in question has to do with moving old donations that were made before GiveWP had a concept of “revenue” into the new revenue database table. In order to add donations to the revenue table, it needs a donation ID, Form ID, and amount. If any single donation on the site does not have one of those three things, the updater stops and logs the error.

The fastest way around it is what you mentioned, deleting the offending donations. Unfortunately, it stops on the first one it finds and doesn’t tell you about any others of them, so you have to comb through all the donations and find ones that are detached from their form.

Let us know about that first error, and we’re happy to dig in!

On the other hand, if there are any different errors, pass those along here.

Please let us know if you have further questions or need additional assistance!