Can’t delete donations – Error 500

Hey @nephalem,

Happy to help you!

When an error 500 shows up, it usually means that there is some problem in the code that is breaking when an action is being executed. Every time this kind of error happens on a website, it is recorded on the server’s logs. Can you share with me what is in the logs regarding the errors?

If you don’t know where are the logs, your hosting company will be able to help you with that.

Also, you may consider updating WordPress to the latest version, so we ensure you are using the latest version for your CMS.

Your success with online donations is our number one priority. Looking forward to helping you get to the bottom of this!

Unfortunately, we can not upgrade to WordPress 5.x as our custom plugins and themes on our production site are not compatible with WP 5.x.

I have downgraded the GiveWP on our site to v2.9.1. That’s the last version of Give that works on WordPress 4.9.x without issues. The only bug in v2.9.1 is the Manual Donations plugin when a zero donation ($0.00) is entered. This will produce a 500 Error. This issue has been resolved in Give 2.9.4 but as I said, this latest version of Give throws 5xx errors during deletion of donations. The issue with 0 donations are not a problem, so we will stick to this version of Give for some time.

Give 2.9.2 and higher versions are unable to delete donations on WordPress 4.9.x installations and it has something to do with the changes in the Give core.

I have also discovered a WP critical error occurs when I try to delete any donation using the ‘delete’ option. The website is shut down by WP with a warning.

Details are: Howdy!

Since WordPress 5.2 there is a built-in feature that detects when a plugin or theme causes a fatal error on your site, and notifies you with this automated email.

In this case, WordPress caught an error with one of your plugins, Give – Donation Plugin.

First, visit your website (https://www.betterhealthcaretechnology.org/) and check for any visible issues. Next, visit the page where the error was caught (https://www.betterhealthcaretechnology.org/wp-admin/edit.php?post_type=give_forms&page=give-payment-history&give-action=delete_payment&purchase_id=37218&_wpnonce=76fc98a6b7) and check for any visible issues.

Please contact your host for assistance with investigating this issue further.

If your site appears broken and you can’t access your dashboard normally, WordPress now has a special “recovery mode”. This lets you safely login to your dashboard and investigate further.

https://www.betterhealthcaretechnology.org/wp-login.php?action=enter_recovery_mode&rm_token=Y2qCceaaPEZmmy2k1R0slo&rm_key=TwJoXqOPlauA72cABQItYt

To keep your site safe, this link will expire in 1 day. Don’t worry about that, though: a new link will be emailed to you if the error occurs again after it expires.

When seeking help with this issue, you may be asked for some of the following information:
WordPress version 5.5.3
Current theme: Hestia Pro (version 3.0.6)
Current plugin: Give – Donation Plugin (version 2.9.5)
PHP version 7.3.25

Error Details
=============
An error of type E_ERROR was caused in line 32 of the file /home2/acpsemfo/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php. Error message: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /home2/acpsemfo/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:32
Stack trace:
#0 /home2/acpsemfo/public_html/wp-content/plugins/give/src/Framework/Database/DB.php(79): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array)
#1 /home2/acpsemfo/public_html/wp-content/plugins/give/src/Framework/Database/DB.php(49): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))
#2 /home2/acpsemfo/public_html/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(62): Give\Framework\Database\DB::delete(‘_FGF_give_reven…’, Array, Array)
#3 /home2/acpsemfo/public_html/wp-content/plugins/give/src/Revenue/Listeners/DeleteRevenueWhenDonationDeleted.php(39): Give\Revenue\Repositories\Revenue->deleteByDonationId(37218)
#4 [internal function]: Give\Revenue\Listeners\DeleteRevenueWhenDonationDeleted->__invoke(37218)
#5 /home2/acpsemfo/public_html

LOliver

Please notify response by email. L Oliver

Hey @lyn-oliver,

This is happening possibly because you do not have the revenue table on your database. To fix it, you need to do the following:

1. Go to the following URLs, in order: (add your base URL to each)
/wp-admin/?give-run-migration=create_revenue_table (this manually forces the database routine again)
/wp-admin/?give-clear-update=add-past-donation-data-to-revenue-table (this clears the update so that your site can try again. You should see an update alert after this one runs. If you get a message like “No upgrade for the given ID” it should mean that you already see some updates ready to run. Proceed to the next step)
2. Run the update at Donations > Updates or by clicking the message at the top of the admin screens.
3. Go to this URL:
/wp-admin/edit.php?post_type=give_forms&page=give-tools&tab=logs&section=updates (this checks the logs to see if there were any errors. If you see errors, pass them along in a reply here.

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