PayPal Donations Don’t Work

Hi there,

Your situation is certainly frustrating, and we understand that. What Matheus said in this other ticket that you commented on, is that this is a situation with PayPal itself. it’s not something unique or specific to GiveWP or to our integration with PayPal.

We are working directly with PayPal to help them see situations exactly like yours so they can resolve this on their end.

Again, we are doing everything we can to help resolve this situation by communicating directly with PayPal, which is where the source of this issue is.

For the time being, you can continue accepting donations with “PayPal Standard”.

Let me know if you have additional questions at all.

• This reply was modified 4 years ago by Matt Cromwell. Reason: added link to the other thread referenced

Hello,

I am trying to assist a charity, Lions Club. their site is at sbclions.com

They were able to receive donations fine until July. They are in desperate need right now due to the Typhoons. They have willing and waiting donors that keep getting error messages.

Please try yourself on the site at https://sbclions.com and do a test. Once you click DONATE then it goes to a PayPal error page.

I have updated the entire site except for the 2x “Elementor” plugins which i do NOT want to update.

I have been trouble shooting for over 4 hours now and the only thing I am unable to complete or think MAY be the cause is the “GiveWP” Plugin will not update.

When I try to update it either quits on error or just “hangs”. I have tried the instructions here https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/ but the issue still remains, Donors cannot donate and the people are in desperate need right now for food, water and shelter due to all the Typhoon flooding.

They are a Charity and 100% volunteer and 100% off their donations (plus out of their pockets) goes to helping the needy & poor I am Begging for help.

Can you assist me?

An unexpected issue occurred during the database update which caused it to stop automatically.

you can check the error logs from file manager https://prntscr.com/vkkhwt

[17-Nov-2020 07:44:06 UTC] WordPress database error Table ‘sbc81lio_wp622.wp_give_revenue’ doesn’t exist for query INSERT INTO wp_give_revenue (donation_id, form_id, amount) VALUES (2409, 1852, 2500) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, give_post_actions, do_action(‘give_purchase’), WP_Hook->do_action, WP_Hook->apply_filters, give_process_donation_form, give_send_to_gateway, do_action(‘give_gateway_paypal’), WP_Hook->do_action, WP_Hook->apply_filters, give_process_paypal_payment, give_create_payment, give_insert_payment, do_action(‘give_insert_payment’), WP_Hook->do_action, WP_Hook->apply_filters, Give\Helpers\Hooks::Give\Helpers{closure}, call_user_func_array, Give\Revenue\DonationHandler->handle, Give\Revenue\Repositories\Revenue->insert

I tried a database restore to June 2020 when the last successful donation completed on PayPal but SAME error

Hi @sbclions

Your issue sounds like a separate one from @ideahost, and is related to a failed Database routine. When you update to 2.9.x GiveWP creates a new database table for “revenue” and if that table is not created correctly, things can go wrong. This has happened for a handful of customers, and we are looking into both how to fix it as well as prevent it.

As of version there’s a trick to re-running those database routines that fail for any reason. In your case the routine that failed is the one that creates the revenue table. Here’s the steps to re-run that db routine:

1. Log into your site.
2. Paste the following onto the end of your site URL in the URL bar: /wp-admin/?give-run-migration=create_revenue_table (if your site is https://givewp.test then the final URL would be https://givewp.test/wp-admin/?give-run-migration=create_revenue_table
3. Go and check the system info at Donations > Tools > System Info to see if the revenue table has been created.
4. If it has not, navigate to Donations > Tools > Logs > Database updates and let me know if you see anything logged there.

Thanks!

Ben Meredith (@benmeredithgmailcom)

Thanks for the reply. I replied to your email. I tried that and still not working. I included screenshot and more info

Thanks, there are so many that need help and we HAVE donors to help but unable to process through PP ??

Hi Matt, Just a follow-up: I am happy to report that I was able to get the “country not matched” error resolved. The error message was confusing, because the actual issue was a typo in the email address to which the funds would go (the PayPal account). I found another forum that mentioned the “country” mismatch issue but they resolved it after finding a typo in the PayPal account email address. A way to mitigate some of the confusions would be if the error message generated said “The PayPal account email address does not exist.” Hope this helps someone out there. Sorry for the confusion, it was not exactly a PayPal issue. Thank you for your assistance ??

ideahost (@ideahost)

Glad you found a solution !

Hopefully they find a solution for my issue ??

I have the same issue, but don’t understand the email typo resolution. If there was a typo I wouldn’t be able to logon to the PayPal account via GiveWP plugin. Is there somewhere else in particular I should check the email?