Failed PayPal Redirect After Switch to Paypal Donations

Hello. Just following up on my prior message as we have not received any update in over a week. Thank you.

any progress from troubleshooting? I’m also having PayPal donation gateway issues in love mode even though all my tests were successful

No progress so far. I installed the newest update to Give WP yesterday, 8/12/2024 and am still encountering the same critical error after the donation goes through.

Hi, @andrewmcclellan.

I’m glad you reached out. I can certainly help you.

Typically, this error means some broken code is causing your site to crash. It is a WordPress system-generated message that means something has caused a PHP fatal error. Whenever you see that message, a more detailed error log has been sent to the main admin email address (which you can configure at Settings > General in the main WordPress settings).

Check that email, and then pass along any error messages you are receiving so we can help. Every time you see that error, it sends another email. If you need to, you can trigger a new email to be able to see the error message again.

If you don’t see that error in your email (WordPress emails are notoriously unreliable that way), you’ll need to ask your host for the error logs. They will be able to send you a complete record of the errors on your site. Once they provide you with this file, send it to us, and we will be able to identify the issue and move towards a resolution for you.

?Also, please send along your System Info.Navigate to Donations –> Tools –> System Info (tab) and click the button to “Get System Report” and copy/paste that in your reply here. That will give me some more context to be able to help.

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

Hi Matheus, and thank you for getting back to me. I have exported the error logs from our web host and see the following Fatal Error message which occurred at the exact time when I received the Critical Error when testing the donations:

[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “NOTICE: PHP message: WordPress database error Unknown column ‘phone’ in ‘field list’ for query SELECT id, user_id AS userId, email, phone, name, purchase_value AS totalAmountDonated, purchase_count AS totalNumberOfDonations, payment_ids AS paymentIds, date_created AS createdAt, token, verify_key AS verifyKey, verify_throttle AS verifyThrottle, give_donormeta_attach_meta_firstName.meta_value AS firstName, give_donormeta_attach_meta_lastName.meta_value AS lastName, give_donormeta_attach_meta_prefix.meta_value AS prefix FROM wp_3usfwmpvlg_give_donors LEFT JOIN wp_3usfwmpvlg_give_donormeta give_donormeta_attach_meta_firstName ON ID = give_donormeta_attach_meta_firstName.donor_id AND give_donormeta_attach_meta_firstName.meta_key = ‘_give_donor_first_name’ LEFT JOIN wp_3usfwmpvlg_give_donormeta give_donormeta_attach_meta_lastName ON ID = give_donormeta_attach_meta_lastName.donor_id AND give_donormeta_attach_meta_lastName.me”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “ta_key = ‘_give_donor_last_name’ LEFT JOIN wp_3usfwmpvlg_give_donormeta give_donormeta_at…”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “NOTICE: PHP message: PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /www/wp-content/plugins/give/src/Framework/Database/DB.php:247”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “Stack trace:”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#0 /www/wp-content/plugins/give/src/Framework/Database/DB.php(95): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#1 /www/wp-content/plugins/give/src/Donors/Models/DonorModelQueryBuilder.php(22): Give\Framework\Database\DB::__callStatic(‘get_row’, Array)”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#2 /www/wp-content/plugins/give/src/Donors/Repositories/DonorRepository.php(76): Give\Donors\Models\DonorModelQueryBuilder->get()”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#3 /www/wp-content/plugins/give/src/Donors/Repositories/DonorRepositoryProxy.php(68): Give\Donors\Repositories\DonorRepository->getByWpUserId(3)”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#4 /www/wp-content/plugins/give/src/Donors/Models/Donor.php(113): Give\Donors\Repositories\DonorRepositoryProxy->__call(‘getByWpUserId’, Array)”
[12-Aug-2024 15:59:06] WARNING: child 2449 said into stderr: “#5 /www/wp-content/plugins/give/src/DonationForms/Actions/GetOrCreateDonor.php(30): Give\Donors\Models\Donor::whereUserId…”
136.33.21.21 – 12/Aug/2024:15:59:05 +0000 “POST asartraining.com/donate/?payment-mode=paypal-commerce&form-id=1949” 500 /www/index.php 93434024 6291008 564.161 2048 49.63%

And here is the system info you requested:

WordPress Environment

Home URL: https://asartraining.com
Site URL: https://asartraining.com
WP Version: 6.6.1
WP Multisite: –
WP Memory Limit: 128 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
Permalink Structure: /%postname%/
Show on Front: page
Page on Front: Home (#429)
Page for Posts: Unset
Table Prefix Length: wp_3usfwmpvlg_
Table Prefix Length: 14
Table Prefix Status: Acceptable
Admin AJAX: Accessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, wc-pending, wc-processing, wc-on-hold, wc-completed, wc-cancelled, wc-refunded, wc-failed, wc-spamorder, wc-checkout-draft, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, upgraded, tribe-ea-success, tribe-ea-failed, tribe-ea-schedule, tribe-ea-pending, tribe-ea-draft, tribe-ignored Server Environment

Hosting Provider: DBH: 192.168.15.201, SRV: asartraining.com
TLS Connection: Connection uses TLS 1.3
TLS Connection: Probably Okay
Server Info: Flywheel/5.1.0
PHP Version: 7.4.33.6
PHP Post Max Size: 300 MB
PHP Time Limit: 178
PHP Max Input Vars: 10000
PHP Max Upload Size: 300 MB
cURL Version: 7.68.0, OpenSSL/1.1.1f
SUHOSIN Installed: –
MySQL Version: 5.7.44
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
gzip: ?
GD Graphics Library: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? GiveWP Configuration

GiveWP Version: 3.14.2
GiveWP Cache: Enabled
Database Updates: All DB Updates Completed.
Database Updates: Few Database Migrations still need to run.
Database Tables: ? wp_3usfwmpvlg_give_donors? wp_3usfwmpvlg_give_donormeta? wp_3usfwmpvlg_give_comments? wp_3usfwmpvlg_give_commentmeta? wp_3usfwmpvlg_give_sessions? wp_3usfwmpvlg_give_formmeta? wp_3usfwmpvlg_give_sequential_ordering? wp_3usfwmpvlg_give_donationmeta? wp_3usfwmpvlg_give_revenue? wp_3usfwmpvlg_give_migrations? wp_3usfwmpvlg_give_log
GiveWP Cache: Enabled
GiveWP Cache: ?New Donation?Donation Receipt?Donation Processing Receipt?New Offline Donation?Offline Donation Instructions?New User Registration?User Registration Information?Donation Note?Email access
Upgraded From: 3.14.1
Test Mode: Disabled
Currency Code: USD
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: https://asartraining.com/donation-confirmation/
Failure Page: https://asartraining.com/donation-failed/
Donation History Page: https://asartraining.com/donor-dashboard-5/
GiveWP Forms Slug: /donations/
Enabled Payment Gateways: PayPal Website Payments Pro (NVP API)
Default Payment Gateway: PayPal Website Payments Pro (NVP API)
PayPal IPN Notifications: IPN received for #5748 ( 2FL71907HW810791P ) on 09/03/2023 at 12:04. Status VERIFIED
Donor Email Access: Enabled
Stripe Webhook Notifications: June 18, 2020 8:42 pm Active GiveWP Add-ons

Give - PayPal Pro Gateway: Free addon – by GiveWP – 1.3.0 Other Active Plugins

Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.23.69
Anti-Spam by CleanTalk: by СleanTalk - Anti-Spam Protection – 6.38
Auto Image Attributes From Filename With Bulk Updater: by Arun Basil Lal – 4.4
Divi Alt Text: by Yan Thiaudière – 4.0
Duplicate Page: by mndpsingh287 – 4.5.4
Event Tickets: by The Events Calendar – 5.13.1
Event Tickets Plus: by The Events Calendar – 6.0.1
Gravity Forms: by Gravity Forms – 2.8.16
Lazy Load - Optimize Images: by WP Rocket – 2.3.9
My Custom Functions: by Space X-Chimp – 4.51
Nested Pages: by Kyle Phillips – 3.2.8
Page Links To: by Mark Jaquith – 3.3.7
Popup Maker: by Popup Maker – 1.19.0
Redirection: by John Godley – 5.5.0
Sassy Social Share: by Team Heateor – 3.3.65
The Events Calendar: by The Events Calendar – 6.6.1
The Events Calendar Shortcode & Block: by Event Calendar Newsletter – 3.0.0
TinyPNG - JPEG, PNG & WebP image compression: by TinyPNG – 3.4.3
WooCommerce: by Automattic – 9.1.4
WooCommerce PayPal Pro (Classic and PayFlow Editions) Gateway: by WooCommerce – 4.5.0
WooCommerce Shipping & Tax: by WooCommerce – 2.7.0
WooCommerce Stripe Gateway: by WooCommerce – 8.6.1
WP Rollback: by WP Rollback – 2.0.7
WPS Hide Login: by WPServeur, NicolasKulka, wpformation – 1.9.16.7
WP SVG Icons: by EH Dev Shop – 3.2.2
Yoast SEO: by Team Yoast – 23.2 Inactive Plugins

Give - Form Field Manager: by GiveWP – 2.0.4
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3 Theme

Name: SLWS Child
Version: 1.0.0
Author URL:
Child Theme: Yes
Parent Theme Name: Divi
Parent Theme Version: 4.27.1
Parent Theme Author URL: https://www.elegantthemes.com

Thanks!

Hi, @andrewmcclellan.

There is a failure regarding a field missing in your database. What likely happened here is that you did not run the database upgrades even though you had the latest version of the GiveWP plugins on your site. For example, if you navigate to donations > tools > data > database updates, you will find a migration called Add phone column to donors table, and that’s likely the migration that did not occur or failed.

You can fix it by navigating to donations > settings > advanced > advanced options and there you enable the Advanced Database Updates. Then, navigate to donations > tools > data > database updates, look for Add phone column to donors table and re-run this update.

Before taking any steps for troubleshooting or updating, I highly recommend taking a good backup of the site you can confidently restore from. Having a backup of your site is essential to a solid workflow, and will allow you to restore to a previous version of the site if you run into any issues. You can read more about our top recommendations for taking a backup here: https://givewp.com/backup-for-faster-troubleshooting/

Feel free to reach out to us if you have any further inquiries or require additional assistance. We’re always happy to help!

Hi Matheus, thank you for getting back to me. I have followed the instructions you provided, however, the database update for the phone column did not execute successfully. The error I received read “Database Update Failed! Check migration details for more information.” I searched for this info in the Give logs/settings but didn’t find anything.

Also, your message notes that I should have been running database updates in addition to updating the plugin. I have been running all updates that I was notified about each month over the last several years. Should Give users be manually checking for these database updates moving forward?

Our client has a major donation event coming up soon so we would appreciate expedited assistance if possible. I’m happy to provide login details for the site if that would help move things along more quickly. Thank you!

Hello. Just following up on my prior message. Also, I can confirm that I have attempted to follow your steps with all non-Give WP plugins deactivated and I also switched our custom theme over to WordPress’ Twenty Twenty theme and still encountered an update error. If you could please elevate this ticket we would appreciate it as we’re coming on a full month since the problem first appeared. Thank you.

Hello, we still haven’t received an update from your team for several weeks. Can you please assist us as soon as possible?