Donation Problems
-
There’s an error while attempting to make a donation. Here is the information on the error log:
/public_html/wp-content/plugins/give/src/Helpers/Hooks.php(43): call_user_func_array(Array, A in /home1/…/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php on line 34.
This error occurs when you click on “donate” button.
The page I need help with: [log in to see the link]
-
Hi @h2ofilters,
I don’t have much information about your site – the System Info would really help here. 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.
However! Without seeing the System Info I’ll go with my hunch.
For a bit of context, the latest GiveWP update 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. Sometimes a host will block this database table creation during the initial install.
The most common database table for this issue is wp_give_revenue (my database prefix is wp_, yours may be different). In your System Info the database tables should all have a green checkmark beside them – or a red X if they are missing.
If wp_give_revenue is missing, please 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.
5. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.If that doesn’t fix the issue, your System Info will help me a bit.
Please let us know if you have further questions on this or need any additional assistance. Have a good day!
Here is the System Info as requested:
### WordPress Environment ### Home URL: https://www.nodacoalumni.org Site URL: https://www.nodacoalumni.org WP Version: 6.0 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ✔ Language: en_US Permalink Structure: /%postname%/ Show on Front: page Page on Front: Homepage (#2805) Page for Posts: Unset Table Prefix Length: ndcwp_ Table Prefix Length: 6 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, acf-disabled, spam, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, tribe-ea-success, tribe-ea-failed, tribe-ea-schedule, tribe-ea-pending, tribe-ea-draft, tribe-ignored ### Server Environment ### Hosting Provider: DBH: localhost, SRV: www.nodacoalumni.org TLS Connection: Connection uses TLS 1.3 TLS Connection: Probably Okay Server Info: Apache PHP Version: 7.4.28 PHP Post Max Size: 2 GB PHP Time Limit: 600 PHP Max Input Vars: 5000 PHP Max Upload Size: 2 GB cURL Version: 7.81.0, OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 5.6.41 Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ gzip: ✔ GD Graphics Library: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### GiveWP Configuration ### GiveWP Version: 2.20.1 GiveWP Cache: Enabled Database Updates: All DB Updates Completed. Database Updates: All Database Migrations Completed. Database Tables: ✔ ndcwp_give_donors✔ ndcwp_give_donormeta✔ ndcwp_give_comments✔ ndcwp_give_commentmeta✔ ndcwp_give_sessions✔ ndcwp_give_formmeta✔ ndcwp_give_sequential_ordering✔ ndcwp_give_donationmeta❌ ndcwp_give_revenue GiveWP Cache: Enabled GiveWP Cache: ✔New Donation✔Donation Receipt✔New Offline Donation✔Offline Donation Instructions✔New User Registration✔User Registration Information✔Donation Note✔Email access Upgraded From: 2.19.5 Test Mode: Disabled Currency Code: USD Currency Position: Before Decimal Separator: . Thousands Separator: , Success Page: https://www.nodacoalumni.org/donation-confirmation/ Failure Page: https://www.nodacoalumni.org/donation-failed/ Donation History Page: https://www.nodacoalumni.org/donor-dashboard-5/ GiveWP Forms Slug: /donations/ Enabled Payment Gateways: Offline Donation, PayPal Standard Default Payment Gateway: PayPal Standard PayPal IPN Notifications: IPN received for #2776 ( 9E580547F1847945E ) on 09/29/2020 at 18:41. Status VERIFIED Donor Email Access: Enabled Stripe Webhook Notifications: N/A ### Active GiveWP Add-ons ### ### Other Active Plugins ### Advanced Custom Fields: Extended: by ACF Extended – 0.8.8.7 Advanced Custom Fields: Table Field: by Johann Heyne – 1.3.14 Advanced Custom Fields: Theme Code: by Ben Pearson and Phil Kurth – 2.5.3 Advanced Custom Fields PRO: by Delicious Brains – 5.12.2 Akismet Anti-Spam: by Automattic – 4.2.4 Animate It!: by eLEOPARD Design Studios – 2.4.0 Banhammer: by Jeff Starr – 2.9 Blackhole for Bad Bots: by Jeff Starr – 3.3.3 Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: by SeedProd – 6.10.0 Contact Form 7: by Takayuki Miyoshi – 5.5.6.1 CSS Hero: by The CSS Hero Team – 4.08 Custom Post Type UI: by WebDevStudios – 1.12.1 Display Featured Image for Genesis: by Robin Cornett – 3.2.2 Duplicator: by Snap Creek – 1.4.6 FooBox Image Lightbox: by FooPlugins – 2.7.17 FooGallery: by FooPlugins – 2.2.7 Genesis Blocks: by StudioPress – 1.4.0 Genesis Custom Blocks: by Genesis Custom Blocks – 1.5.0 Genesis Layout Extras: by David Decker - DECKERWEB – 2.1.2 Genesis Responsive Slider: by StudioPress – 1.0.1 Jetpack: by Automattic – 10.9.1 Kadence Blocks – Gutenberg Blocks for Page Builder Features: by Kadence WP – 2.4.4 Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.25.3 Maintenance: by WebFactory Ltd – 4.06 MainWP Child: by MainWP – 4.2.3 ManageWP - Worker: by GoDaddy – 4.9.13 MOJO Marketplace: by Mike Hansen – 1.6.2 Post Type Switcher: by Triple J Software, Inc. – 3.2.1 Really Simple SSL: by Really Simple Plugins – 5.3.2 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Responsive WordPress Slider - Soliloquy Lite: by Soliloquy Team – 2.7.0 Simple Social Icons: by StudioPress – 3.1.0 Smart Slider 3 Pro: by Nextend – 3.5.1.6 Stackable - Gutenberg Blocks (Premium): by Gambit Technologies, Inc – 3.3.3 Staff List Pro: by abcFolio – 3.9.7 The Events Calendar: by The Events Calendar – 5.15.0.1 USP Helper: by Jeff Starr – 2.7 USP Pro: by Jeff Starr – 4.2 Widget Logic: by WPChef – 5.10.4 Wordfence Security: by Wordfence – 7.5.10 WordPress Importer: by wordpressdotorg – 0.7 Yoast SEO: by Team Yoast – 18.9 ### Inactive Plugins ### Advanced Custom Fields: by Delicious Brains – 5.12.2 Atomic Blocks - Gutenberg Blocks Collection: by atomicblocks – 2.9.0 BBQ Pro: by Jeff Starr – 2.8.1 Block for Font Awesome: by Ciprian Popescu – 1.2.3 Genesis eNews Extended: by Brandon Kraft – 2.2.0 Getwid: by MotoPress – 1.8.1 Kadence WooCommerce Elementor: by Kadence WP – 1.0.6 Stackable - Gutenberg Blocks: by Gambit Technologies, Inc – 3.3.3 WP Super Cache: by Automattic – 1.7.7 ### Active MU Plugins ### ManageWP - Worker Loader: by GoDaddy – SSO: by Garth Mortensen, Mike Hansen – 0.3 ### Theme ### Name: Genesis Sample Version: 3.4.0 Author URL: https://www.studiopress.com/ Child Theme: Yes Parent Theme Name: Genesis Parent Theme Version: 3.3.5 Parent Theme Author URL: https://www.studiopress.com/Thanks. As you can see, the ndcwp_give_revenue is missing.
Please 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.
5. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.Then do a test donation and let me know if the problem persists.
Thanks!
Instructions worked! Thank you.
The topic ‘Donation Problems’ is closed to new replies.
