Uncaught Database Exception

  • Resolved rik100

    (@rik100)


    2 years, 4 months ago

    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
    Site URL: 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/
    Failure Page: https://rotaryestoipalace.org/transaction-failed/
    Donation History Page: 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 www.remarpro.com 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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter rik100

    (@rik100)

    Is anyone monitoring this support forum?

    Plugin Support Matheus Martins

    (@matheusfd)

    Hi, @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

    Can you let us know if this fixes your issue?

    Looking forward to helping you get to the bottom of this!

    Thread Starter rik100

    (@rik100)

    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

    (@matheusfd)

    Hi, @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.