Title: Uncaught Database Exception Last modified: July 10, 2022 --- # Uncaught Database Exception * Resolved [rik100](https://wordpress.org/support/users/rik100/) * (@rik100) * [3 years, 11 months ago](https://wordpress.org/support/topic/uncaught-database-exception/) * Following reports from users that they are unable to make payments using the Stripe gateway I started investigating the GiveWP plugin. * If I select Donations from my admin dashboard I get an error in my debug.log: PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /customers/0/e/c/rotaryestoipalace.org/httpd.www/wp-content/ plugins/give/src/Framework/Database/DB.php:242 * All other selections e.g. donors, settings, forms etc all work as expected. * This is what I have tried so far: * I have disabled all other plugins and installed default theme. * I deleted GiveWP and reinstalled. * I have followed the re-run updates advice which I have seen in quite a few answers to this type of issue. I get “Uncaught database exception” errors in the Error Logs. * Short of completely deleting the plugin and all data and starting from scratch I don’t know what to do next. * I would be happy to lose all donation data but I don’t want to lose my donation forms as it would be a major task to rebuild them. * Any advice? * ___________________________________________ * This is my system log: ### WordPress Environment ### * Home URL: [https://rotaryestoipalace.org](https://rotaryestoipalace.org) Site URL: [https://rotaryestoipalace.org](https://rotaryestoipalace.org) WP Version: 6.0 WP Multisite: – WP Memory Limit: 205 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_GB Permalink Structure: /%postname%/ Show on Front: page Page on Front: Home(# 1900) Page for Posts: Unset Table Prefix Length: network_ Table Prefix Length: 8 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, wc-pending, wc-processing, wc-on-hold, wc-completed, wc-cancelled, wc-refunded, wc-failed, wc-checkout-draft, refunded, failed, revoked, cancelled, abandoned, processing, preapproval * ### Server Environment ### * Hosting Provider: DBH: rotaryestoipalace.org.mysql, SRV: rotaryestoipalace.org TLS Connection: Connection uses TLS 1.3 TLS Connection: Probably Okay Server Info: Apache PHP Version: 7.4.30 PHP Post Max Size: 256 MB PHP Time Limit: 300 PHP Max Input Vars: 5000 PHP Max Upload Size: 256 MB cURL Version: 7.68.0, OpenSSL/ 1.1.1f SUHOSIN Installed: – Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ gzip: ✔ GD Graphics Library: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ * ### GiveWP Configuration ### * GiveWP Version: 2.21.4 GiveWP Cache: Enabled Database Updates: All DB Updates Completed. Database Updates: All database migrations completed. Database Tables: ✔ network_give_donors✔ network_give_donormeta✔ network_give_comments✔ network_give_commentmeta ✔ network_give_sessions✔ network_give_formmeta✔ network_give_sequential_ordering ✔ network_give_donationmeta✔ network_give_revenue✔ network_give_migrations✔ network_give_log 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.21.2 Test Mode: Disabled Currency Code: EUR Currency Position: Before Decimal Separator: , Thousands Separator:. Success Page: [https://rotaryestoipalace.org/payment-confirmation/](https://rotaryestoipalace.org/payment-confirmation/) Failure Page: [https://rotaryestoipalace.org/transaction-failed/](https://rotaryestoipalace.org/transaction-failed/) Donation History Page: [https://rotaryestoipalace.org/donor-dashboard-4/](https://rotaryestoipalace.org/donor-dashboard-4/) GiveWP Forms Slug: /payments/ Enabled Payment Gateways: Offline Donation, Stripe– Checkout Default Payment Gateway: Stripe – Checkout PayPal IPN Notifications: N/A Donor Email Access: Disabled Stripe Webhook Notifications: 22 May 2022 11: 56 * ### Active GiveWP Add-ons ### * Give – Stripe Gateway: ✔ Licensed – by GiveWP – 2.4.1 * ### Other Active Plugins ### * Activity Log: by Activity Log Team – 2.8.3 Add Admin CSS: by Scott Reilly – 2.0.1 Admin Bar: by Richard Thorpe – 1.0 Admin Menu Editor: by Janis Elsts – 1.10.2 Admin Menu Search: by Michael Herchenroder – 1.2 Advanced Custom Fields: by Delicious Brains – 5.12.2 Advanced Excerpt: by WPKube – 4.3.9 Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.1 Akismet Anti-Spam: by Automattic– 4.2.4 amr personalise: by anmari – 2.10 Another Mailchimp Widget: by MotoPress– 2.1.0 Anything Popup: by Gopi Ramasamy – 7.3 Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.5 Autocomplete WooCommerce Orders: by QuadLayers – 1.5.3 Better Plugin Compatibility Control: by Oliver Schlöbe – 6.0.0 Blocks Animation: CSS Animations for Gutenberg Blocks: by ThemeIsle – 2.0.7 Blocksy Companion: by CreativeThemes – 1.8.41 Bulk Delete: by Sudar – 6.0.2 Calculated Fields Form: by CodePeople – 1.1.95 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.6.1 Classic Widgets: by WordPress Contributors – 0.3 Code Embed: by David Artiss– 2.3.4 Conditional Fields for Contact Form 7: by Jules Colle – 2.2 Contact Form 7: by Takayuki Miyoshi – 5.6 Contact Form CFDB7: by Arshid – 1.2.6.4 Contest Gallery – PRO Version: by Contest Gallery – PRO – 17.0.7-PRO Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.3.1 Create And Assign Categories For Pages: by Sandeep Singh – 1.2 CSS JS Manager, Async JavaScript, Defer Render Blocking CSS: by Pi Websolution – 2.4.41 Current User Capabilities: by Richard Thorpe – 1.0 Custom Login Page Templates: by Cozmoslabs, Madalin Ungureanu, Antohe Cristian, – 1.0.1 Custom Order Status Per Product for WooCommerce: by theDotstore– 1.6.1 Custom Sidebars: by WebFactory Ltd – 3.35 Custom Upload Dir: by Ulf Benjaminsson– 3.4.6 Date Time Picker Field: by Carlos Moreira – 1.8.2 Direct Checkout for WooCommerce: by QuadLayers – 2.6.3 Disable Admin Notices Individually: by Creative Motion – 1.3.0 Duplicate Page: by mndpsingh287 – 4.4.8 Easy Post Types and Fields: by Barn2 Plugins – 1.0.0 EditorsKit: by Munir Kamal – 1.33.7 Embed Any Document: by Awsm Innovations – 2.7.1 Embed PDF Viewer: by Andy Fragen – 2.3.0 FooBox Image Lightbox: by FooPlugins – 2.7.17 Google Doc Embedder: by Kevin Davis – 2.6.4 Gosign – Background Container Block: by Gosign.de – 2.7.2 GS Team Members: by GS Plugins – 1.11.1 GTranslate: by Translate AI Multilingual Solutions – 2.9.12 Gutenslider — The last WordPress slider you will ever need.: by eedee – 5.8.2 Health Check & Troubleshooting: by The WordPress.org community – 1.4.5 If Menu– Visibility control for menus: by Layered – 0.16.3 Insert PHP Code Snippet: by xyzscripts.com – 1.3.3 Jotform oEmbed: by Jotform.com – 1.3.0 jQuery Updater: by Ramoonus – 3.6.0.2 Kadence Blocks – Gutenberg Blocks for Page Builder Features: by Kadence WP – 2.4.12 Latest Posts Block Lite: by AF themes – 1.0.4 Log Out Shortcode: by OM4 – 1.0.8 Mail logging – WP Mail Catcher: by James Ward – 2.0.4 MaxButtons: by Max Foundry – 9.2 Max Mega Menu: by megamenu.com – 2.9.7 Members: by MemberPress – 3.2.1 Menu In Post: by linux4me – 1.1.8 Meta Tag Manager: by Marcus Sykes – 3.0.2 My Custom Functions: by Space X-Chimp – 4.51 New User Approve: by WPExpertsio – 2.4.1 one.com: by one.com – 4.0.0 one.com PHP compatibility scanner: by one.com – 0.2.0 Order Export & Order Import for WooCommerce: by WebToffee– 2.2.5 Participants Database: by Roland Barker, xnau webdesign – 2.1.7 Passwordless Login: by Cozmoslabs, sareiodata – 1.1.1 PDFjs Viewer – Embed PDFs: by Ben Lawson, Thomas McMahon – 2.1.7 Performance Cache: by one.com – 3.0.0 Photonic Gallery& Lightbox for Flickr, SmugMug, Google Photos & Others: by Sayontan Sinha – 2.81 plugin load filter: by enomoto@celtislab – 4.0.9 Plugins Garbage Collector (Database Cleanup) Old!: by Vladimir Garagulya – 0.14 Plugins List: by David Artiss – 2.4.4 Plugins Page Customize: by Webtemyk – 1.4.2 Plugin Toggle: by Cedaro – 1.3.1 Pods – Custom Content Types and Fields: by Pods Framework Team – 2.8.23 Post/ Page specific custom CSS: by Łukasz Nowicki – 0.2.4 Post Snippets: by Postsnippets– 3.1.7 Posts Table Pro: by Barn2 Plugins – 2.4.1 Posts Table Pro – EU Date Format: by Barn2 Media – 1.0 Post Type Switcher: by Triple J Software, Inc. – 3.2.1 PostX– Gutenberg Post Grid Blocks: by wpxpo – 2.6.4 Prevent Browser Caching: by Kostya Tereshchuk – 2.3.3 Profile Builder: by Cozmoslabs – 3.7.6 Query Monitor: by John Blackbourn – 3.9.0 Raffle Ticket Generator – Woocommerce: by The Web Design Ninja– 4.6.1 reBusted!: by Simon Prosser – 1.1 ReCaptcha v2 for Contact Form 7: by IQComputing– 1.4.0 Rich Text Excerpts: by Peter Edwards – 1.3.4 Secondary Title: by Kolja Nolte – 2.0.8 Shortcode in Menus: by Gagan Deep Singh – 3.5.1 Simple 301 Redirects: by WPDeveloper – 2.0.6 Smart Slider 3: by Nextend – 3.5.1.7 Snippet Shortcodes: by Ali Colville – 4.0.1 Social Media and Share Icons (Ultimate Social Media): by UltimatelySocial – 2.7.5 Stackable – Gutenberg Blocks: by Gambit Technologies, Inc – 3.3.5 Stop Spammers: by Trumani – 2022.3 SVG Support: by Benbodhi – 2.4.2 TablePress: by Tobias Bäthge – 1.14 TablePress Extension: Cell Highlighting: by Tobias Bäthge – 1.0 TablePress Extension: DataTables Sorting plugins: by Tobias Bäthge – 1.0 TablePress Extension: Table Row Order: by Tobias Bäthge – 1.2 Ultimate Blocks: by Ultimate Blocks – 2.5.1 User Role Editor: by Vladimir Garagulya – 4.62 Webcraftic Assets manager: by Webcraftic – 2.1.5 WebP Converter for Media: by Mateusz Gbiorczyk – 4.4.1 WooCommerce: by Automattic – 6.6.1 Wordfence Security: by Wordfence – 7.5.11 Wordpress File Upload: by Nickolas Bossinas – 4.16.4 WP- Optimize – Clean, Compress, Cache: by David Anderson, Ruhani Rabin, Team Updraft– 3.2.6 WP Bulk Delete: by Xylus Themes – 1.2.2 WP Extra File Types: by Davide Airaghi – 0.5.2 WP Latest Posts: by JoomUnited – 4.8.9 WP Latest Posts Add-on: by JoomUnited – 4.5.5 WP Mail From II: by Ben Huson – 2.0 WP Mail SMTP: by WPForms– 3.4.0 * ### Inactive Plugins ### * eCards: by Ciprian Popescu – 5.3.0 FooGallery: by FooPlugins – 2.2.7 Forminator: by WPMU DEV – 1.17.1 MetaSlider: by MetaSlider – 3.27.6 Popup Builder: by Sygnoos– 4.1.12 Popup Maker: by Popup Maker – 1.16.7 Subscriptions For WooCommerce: by WP Swings – 1.4.1 Weather Effect: by A WP Life – 1.4.0 WOLF – WordPress Posts Bulk Editor and Manager Professional: by realmag777 – 1.0.6 WP-DBManager: by Lester ‘GaMerZ’ Chan – 2.80.5 WP Activity Log: by WP White Security – 4.4.2.1 WP Attachments: by Marco Milesi – 5.0.4 YellowPencil: by WaspThemes – 7.5.6 YITH WooCommerce Subscription: by YITH – 2.11.0 Yoast SEO: by Team Yoast – 19.2 * ### Active MU Plugins ### * assets-manager.php: by – 1.1.2 Health Check Troubleshooting Mode: by – 1.7.2 plugin load filter [plf-filter]: by enomoto@celtislab – 4.0.6 WP STAGING Optimizer: by René Hermenau – 1.4.1 * ### Theme ### * Name: Blocksy Child Version: Author URL: Child Theme: Yes Parent Theme Name: Blocksy Parent Theme Version: 1.8.41 Parent Theme Author URL: [https://creativethemes.com](https://creativethemes.com) Viewing 4 replies - 1 through 4 (of 4 total) * Thread Starter [rik100](https://wordpress.org/support/users/rik100/) * (@rik100) * [3 years, 11 months ago](https://wordpress.org/support/topic/uncaught-database-exception/#post-15822189) * Is anyone monitoring this support forum? * Plugin Support [Matheus Martins](https://wordpress.org/support/users/matheusfd/) * (@matheusfd) * [3 years, 11 months ago](https://wordpress.org/support/topic/uncaught-database-exception/#post-15828508) * Hi, [@rik100](https://wordpress.org/support/users/rik100/). * Glad you reached out. * We’re not sure the underlying cause for the timeouts (and are working under the assumption it’s a combination of an over-taxed server with too many donations/ donors/forms to query) and are going to dedicate some time over the next weeks to look into that. * In the meantime, we’ve created a snippet for switching the new list views to the legacy views for all administrators on a site. To use it, do the following: * Add the snippet (linked below) to functions.php or some other place that runs arbitrary PHP. You can use the Code Snippets plugin too. * Go to /wp-admin/index.php?givewp_set_legacy_lists=1 — be sure to add your own domain name at the beginning * It will redirect you back to the same page, and now the lists should be legacy. * Here’s the link to the snippet: [https://gist.github.com/rickalday/ffb27e660cd4b1c7b1d9cf92ef696264](https://gist.github.com/rickalday/ffb27e660cd4b1c7b1d9cf92ef696264) * Can you let us know if this fixes your issue? * Looking forward to helping you get to the bottom of this! * Thread Starter [rik100](https://wordpress.org/support/users/rik100/) * (@rik100) * [3 years, 11 months ago](https://wordpress.org/support/topic/uncaught-database-exception/#post-15829711) * Thanks. The snippet worked. * I am not sure the issue is “a combination of an over-taxed server with too many donations/donors/forms to query” as I have less than 100 donors, just 10 or 12 forms and less than 150 payments. * But having said that I noticed a while back that the debug log included: [13- Jul-2022 15:23:21 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT DISTINCT id,post_date AS createdAt, post_status AS status, give_donationmeta_attach_meta_0.meta_value AS amount, give_donationmeta_attach_meta_1.meta_value AS baseAmount, ……………etc * Not sure if that adds anything. * Plugin Support [Matheus Martins](https://wordpress.org/support/users/matheusfd/) * (@matheusfd) * [3 years, 10 months ago](https://wordpress.org/support/topic/uncaught-database-exception/#post-15835898) * Hi, [@rik100](https://wordpress.org/support/users/rik100/). * This has something to do with the MAX_JOIN_SIZE too. We are working on it to fix it. * Thanks for using GiveWP! Have a great day. Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Uncaught Database Exception’ is closed to new replies. * ![](https://ps.w.org/give/assets/icon-256x256.jpg?rev=2873287) * [GiveWP - Donation Plugin and Fundraising Platform](https://wordpress.org/plugins/give/) * [Frequently Asked Questions](https://wordpress.org/plugins/give/#faq) * [Support Threads](https://wordpress.org/support/plugin/give/) * [Active Topics](https://wordpress.org/support/plugin/give/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/give/unresolved/) * [Reviews](https://wordpress.org/support/plugin/give/reviews/) * 4 replies * 2 participants * Last reply from: [Matheus Martins](https://wordpress.org/support/users/matheusfd/) * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/uncaught-database-exception/#post-15835898) * Status: resolved