• Resolved rholdstock

    (@rholdstock)


    Hello,
    I get this message when I try to delete my pending test donations:

    Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:32 Stack trace: #0 /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Framework/Database/DB.php(79): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array) #1 /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Framework/Database/DB.php(49): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure)) #2 /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(62): Give\Framework\Database\DB::delete(‘wp_give_revenue’, Array, Array) #3 /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Revenue/Listeners/DeleteRevenueWhenDonationDeleted.php(39): Give\Revenue\Repositories\Revenue->deleteByDonationId(7320) #4 [internal function]: Give\Revenue\List in /home/customer/www/co2balance.com/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php on line 32

    Here is my system report:

    ### WordPress Environment ###

    Home URL: https://www.co2balance.com
    Site URL: https://www.co2balance.com
    WP Version: 5.6
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: (#2)
    Page for Posts: Blog (#7)
    Table Prefix Length: wp_
    Table Prefix Length: 3
    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, refunded, failed, revoked, cancelled, abandoned, processing, preapproval

    ### Server Environment ###

    Hosting Provider: DBH: localhost, SRV: https://www.co2balance.com
    TLS Connection: Connection uses TLS 1.2
    TLS Connection: Probably Okay
    Server Info: Apache
    PHP Version: 7.3.26
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    PHP Max Upload Size: 256 MB
    cURL Version: 7.66.0, OpenSSL/1.1.1g-fips
    SUHOSIN Installed: –
    MySQL Version: 5.7.26
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    gzip: ?
    GD Graphics Library: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### GiveWP Configuration ###

    GiveWP Version: 2.9.5
    GiveWP Cache: Enabled
    Database Updates: All DB Updates Completed.
    Database Updates: All database migrations completed.
    Database Tables: ? wp_give_donors? wp_give_donormeta? wp_give_comments? wp_give_commentmeta? wp_give_sessions? wp_give_logs? wp_give_logmeta? wp_give_formmeta? wp_give_sequential_ordering? wp_give_donationmeta? wp_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.9.1
    Test Mode: Disabled
    Currency Code: GBP
    Currency Position: Before
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://www.co2balance.com/credit-purchase-confirmation/
    Failure Page: https://www.co2balance.com/credit-purchase-failed/
    Donation History Page: https://www.co2balance.com/credit-purchase-history/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: PayPal Standard
    Default Payment Gateway: PayPal Standard
    PayPal IPN Verification: Disabled
    PayPal IPN Notifications: N/A
    Donor Email Access: Disabled
    Stripe Webhook Notifications: N/A

    ### Active GiveWP Add-ons ###

    ### Other Active Plugins ###

    Advanced Custom Fields PRO: by Elliot Condon – 5.9.3
    AWSM Team Pro: by AWSM Innovations – 1.9.0
    Classic Editor: by WordPress Contributors – 1.6
    Contact Form 7: by Takayuki Miyoshi – 5.3.2
    Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.31
    CPT Projects: by Rebecca Holdstock – 1.0
    Custom Taxonomy Order: by Marcel Pol – 3.2.2
    GDPR Cookie Consent: by WebToffee – 1.9.5
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.14.0
    HTML in Category Descriptions: by Arno Esterhuizen – 1.2.3
    Interactive World Maps: by Carlos Moreira – 2.2.7
    ManageWP – Worker: by GoDaddy – 4.9.7
    Post Types Order: by Nsp Code – 1.9.5.4
    Responsive Lightbox & Gallery: by dFactory – 2.3.1
    SG Optimizer: by SiteGround – 5.7.12
    Shared Counts: by Bill Erickson & Jared Atchison – 1.3.0
    Smush: by WPMU DEV – 3.8.2
    Stackable – Gutenberg Blocks: by Gambit Technologies, Inc – 2.13.2
    Yoast SEO: by Team Yoast – 15.6.1

    ### Inactive Plugins ###

    Autoptimize: by Frank Goossens (futtta) – 2.8.1

    ### Active MU Plugins ###

    ManageWP – Worker Loader: by ManageWP –

    ### Theme ###

    Name: CO2balance
    Version: 1.0.0
    Author URL: https://rebeccaholdstock.co.uk
    Child Theme: No – If you’re modifying GiveWP on a parent theme you didn’t build personally, then we recommend using a child theme. See: How to Create a Child Theme

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter rholdstock

    (@rholdstock)

    I’ve fixed this now by turning off my hosting cache and manually re-running the database update/migration process which I found on this page – https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/

    I am having the same issue – when I try to delete test donations I get the same error recorded above.
    I read about the process to manually re-run database update/migration processes on the link in the above reply – it sounds rather scary. There are 7 database/migration steps listed on my site. All but one were run on the same date (2021-03-29), and there is one later one to delete log files. All steps are marked “Success”, so I’m not sure why they need to be re-run.

    Can anyone confirm that this is the best or only way to fix the problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Fatal error: Uncaught’ is closed to new replies.