Support » Plugin: GiveWP - Donation Plugin and Fundraising Platform » An unexpected issue occurred during the database update

  • Resolved circleb

    (@circleb)


    I’m getting this error on my site: An unexpected issue occurred during the database update which caused it to stop automatically.

    What I’ve tried so far:
    1. disabling caching and security plugins
    2. disabling all plugins except for give
    3. migrating to a local install and deleting all plugins but give
    4. installing a previous version

    On my live/prouction site, I can pause updates, but I get the same error when restarting, after trying the first two items.

    On my local install when I try to pause the updates, I get the WordPress error: There has been a critical error on this website.

    Here’s the production system info:

    ### WordPress Environment ###
    
    Home URL: https://www.aspringofhope.com
    Site URL: https://www.aspringofhope.com
    WP Version: 5.7.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: Christmas Music 2020 (#10501)
    Page for Posts: Blog (#8620)
    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, give_subscription
    
    ### Server Environment ###
    
    Hosting Provider: DBH: localhost, SRV: www.aspringofhope.com
    TLS Connection: Connection uses TLS 1.3
    TLS Connection: Probably Okay
    Server Info: Apache
    PHP Version: 7.4.16
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    PHP Max Upload Size: 128 MB
    cURL Version: 7.71.0, OpenSSL/1.1.1d
    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.10.3
    GiveWP Cache: Enabled
    Database Updates: 4 updates still need to run. (Paused)
    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_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❌Renewal Receipt Email❌Renewal Receipt Email❌Subscription Cancelled Email❌Subscription Cancelled Email❌Subscription Completed Email❌Subscription Reminder Email✔Subscriptions Email Access✔Subscription Payment Failed Email
    Upgraded From: 2.10.3
    Test Mode: Disabled
    Currency Code: USD
    Currency Position: After
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://www.aspringofhope.com/donation-confirmation/
    Failure Page: https://www.aspringofhope.com/transaction-failed/
    Donation History Page: https://www.aspringofhope.com/donor-dashboard-3/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: Stripe - Credit Card
    Default Payment Gateway: Stripe - Credit Card
    PayPal IPN Verification: Enabled
    PayPal IPN Notifications: N/A
    Donor Email Access: Enabled
    Stripe Webhook Notifications: April 27, 2021 3:58 am
    
    ### Active GiveWP Add-ons ###
    
    Give - Recurring Donations: ✔ Licensed – by GiveWP – 1.12.2
    Give - Stripe Gateway: ✔ Licensed – by GiveWP – 2.3.0
    
    ### Other Active Plugins ###
    
    Advanced Custom Fields: by Elliot Condon – 5.9.5
    Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0
    Advanced WP Columns: by Vladica Savic – 2.0.6
    Akismet Anti-Spam: by Automattic – 4.1.9
    AudioJS Album: by Ben Owen – 1.0
    Blank Page: by Ben Owen – 1.0
    Blank Slate: by Aaron Reimann & Micah Wood – 1.2.1
    Classic Editor: by WordPress Contributors – 1.6
    Custom Post Type UI: by WebDevStudios – 1.9.1
    Donorbox Donation Form: by rebelidealist – 7.1.3
    Embed Plus for YouTube - Gallery, Channel, Playlist, Live Stream: by Embed Plus for YouTube Team – 13.4.2
    Export Users to CSV: by Matt Cromwell – 1.1.1
    Extended API: by Michael Grosser – 0.8.1
    JSON API: by Dan Phiffer – 1.1.1
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.3
    MC4WP: Mailchimp User Sync: by ibericode – 1.8.1
    Mixlr Shortcode: by Mixlr Ltd. – 1.0.1
    Podcast Archive: by Ben Owen – 1.0
    Popup Maker: by Popup Maker – 1.16.1
    Recording Archive: by Ben Owen – 1.0
    Remove Widget Titles: by Stephen Cronin – 1.0
    SHM Addons: by Ben Owen – 1.5
    Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.26
    Top Bar PRO: by WP Darko – 2.0
    Ultimate Member: by Ultimate Member – 2.1.19
    WEN's Responsive Column Layout Shortcodes: by Bhuwan Roka – 2.3
    WP Mail SMTP: by WPForms – 2.7.0
    
    ### Inactive Plugins ###
    
    iOS Notificator: by Ben Owen – 0.1
    
    ### Theme ###
    
    Name: Twenty Seventeen
    Version: 2.6
    Author URL: https://wordpress.org/
    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

    Local system report

    ### WordPress Environment ###
    
    Home URL: http://localhost:8888
    Site URL: http://localhost:8888
    WP Version: 5.7.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: Christmas Music 2020 (#10501)
    Page for Posts: Blog (#8620)
    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, refunded, failed, revoked, cancelled, abandoned, processing, preapproval
    
    ### Server Environment ###
    
    Hosting Provider: DBH: localhost, SRV: localhost
    TLS Connection: Connection uses TLS 1.2
    TLS Connection: Probably Okay
    Server Info: Apache/2.4.46 (Unix) OpenSSL/1.0.2u PHP/7.4.12 mod_wsgi/3.5 Python/2.7.13 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.11 Perl/v5.30.1
    PHP Version: 7.4.12
    PHP Post Max Size: 64 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    PHP Max Upload Size: 64 MB
    cURL Version: 7.68.0, OpenSSL/1.0.2u
    SUHOSIN Installed: –
    MySQL Version: 5.7.32
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    gzip: ✔
    GD Graphics Library: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### GiveWP Configuration ###
    
    GiveWP Version: 2.10.3
    GiveWP Cache: Enabled
    Database Updates: 4 of 35 updates still need to run.
    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.10.3
    Test Mode: Disabled
    Currency Code: USD
    Currency Position: After
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: http://localhost:8888/donation-confirmation/
    Failure Page: http://localhost:8888/transaction-failed/
    Donation History Page: http://localhost:8888/donor-dashboard-3/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: Stripe - Credit Card
    Default Payment Gateway: Stripe - Credit Card
    PayPal IPN Verification: Enabled
    PayPal IPN Notifications: N/A
    Donor Email Access: Enabled
    Stripe Webhook Notifications: April 27, 2021 2:08 am
    
    ### Active GiveWP Add-ons ###
    
    ### Other Active Plugins ###
    
    ### Inactive Plugins ###
    
    Give - Donation Plugin: by GiveWP – 2.10.3
    Give - Recurring Donations: by GiveWP – 1.12.2
    Give - Stripe Gateway: by GiveWP – 2.3.0
    
    ### Theme ###
    
    Name: Twenty Twenty-One
    Version: 1.3
    Author URL: https://wordpress.org/
    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 9 replies - 1 through 9 (of 9 total)
  • I am having a similar issue with both the 2.10.2 and 2.10.3 versions. I am in my staging environment where I am implementing a new theme which included the GiveWP as a plugin. Every time I click the Updater, it just spins and spins. This last time it ran overnight and all day today.

    I also have a demo version of our new theme and the GiveWP updater ran in that environment with no problem – it ran in just a couple of minutes.

    * I am on GoDaddy hosting and can not find any caching to disable.
    * I have deactivated all the plugins in my staging environment which are not in my demo environment (since it works there, I assume there is no plugin conflicts). See list of active and deactivated plugins below.

    Please advise if this is the correct place for support. We have a licensed copy of GiveWP so I feel like I should be able to use your support from https://givewp.com/ but I don’t have an account to use.

    Details
    ——-

    URL: https://new.ncaonline.net/staging/
    WP Version: 5.7.1
    Theme: Churhius
    Version: 2.5
    Author: monkeysan
    Child Theme: not yet
    
    Active Plugins
    --------------
    All-in-One WP Migration version 7.4.1 by ServMask 
    All-in-One WP Migration Unlimited Extension version 2.39 by ServMask 
    Churhius Theme – Functionality version 1.0.8 by monkeysan 
    Contact Form 7 version 5.4 by Takayki Miyoshi 
    Easy Tables (vc) version 2.0.1 by WPBakery 
    Give - Donation Plugin Version 2.10.3 & 2.10.4
    Latest Tweets Widget version 1.1.4 by Tim Whitlock 
    Redux version 4.1.24 by Redux.io + Dovy Paukstys 
    Sermon Manager for WordPress version 2.16.7 by WP for Church 
    Slider Revolution version 6.3.3 by ThemePunch
    The Events Calendar version 5.5.0.1 by The Events Calendar 
    WPBakery Page Builder version 6.6.0 by Michael M - WPBakery.com
    
    Inactive Plugins (inactivated to try to get this to work ... many will be active in production)
    ----------------
    Easy Google Fonts version 1.4.4 by Titanium Themes
    Envato Market version 2.0.6 by Envato 
    EventON version 2.3.23 by AshanJay
    EventOn - Events List version 0.7 by AshanJay
    Go Daddy Quick Setup version 1.04 by GoDaddy.com
    Google Analytics Dashboard for WP (GADWP) version 6.7.0 by ExactMetrics
    Gravity Forms version 1.9.17.8 by rocketgenius
    Gravity Forms version 2.4.24 by rocketgenius
    Gravity Forms CSS Ready Class Selector version 1.1 by Brad Vincent
    Gravity Forms Mailchimp Add-On version 4.8 by Gravity Forms
    Gravity Forms PayPal Standard Add-On version 3.4 by Gravity Forms
    Hello Dolly version 1.7.2 by Matt Mulleweg
    Limit Login Attempts version 1.7.1 by Johan Eenfeldt
    Limit Login Attempts Reloaded version 2.21.0 by Limit Login Attempts Reloaded
    MailPoet version 2.14 by MailPoet
    MailPoet version 3.60.9 by MailPoet
    McAfee SECURE version 1.9.1 by TrustedSite
    Post Grid by PickPlugins version 2.1.3 by PickPlugins
    Qube+ Elements version 1.1 by Qube+
    Qube+ Once Click Import version 3.1 by Qube+
    Really SImple SSL version 4.0.13 by Really Simple Plugins
    Search & Replace version 3.2.1 by Inpsyde GmbH
    Series Engine version 2.8.4 by Eric Murrell (Volacious)
    Sermon Browser version 0.45.22 by Mark Barnes
    Sermon Podcast for Church Theme Content version 1.0.6 by Churchly
    Simple CSS version 1.1.1 by Tom Osborne
    SlickNav Mobile Menu version 1.9.1 by Neil Gee
    Smash Balloon Instagram Feed version 2.9 by Smash Balloon 
    UpdraftPlus - Backup/Restore version 1.16.53 by UpdraftPlus.com
    Woocommerce version 5.2.2 by Automattic 
    WordPress Importer version 0.7 by wordpressdotorg 
    Yoast Duplicate Post version 4.1.2 by Enrico Battocchi & Team Yoast
    Yoast SEO version 16.1.1 by Team Yoast

    thank you for your assistance

    Plugin Support Rick Alday

    (@mrdaro)

    Hi @tkouch and @circleb

    Anytime the database update stalls there’s an error message in the logs that explains what happened.

    Go to Donations -> Tools -> Logs -> Errors.
    Click the eye icon next to any error with the description of “Update error” and copy the full error message in your next reply.

    Thanks!

    I reran and received the message:
    “An unexpected issue occurred during the database update which caused it to stop automatically.
    Update 1 of 30
    There are 3 error logs. Each have a category of “Migration” and a Source of “Give Core”. The descriptions for the 3 errors are respectively: “Update Error”, “Update Pause”, and “Update Health Check”.

    The first error (Update error) log gives the following:
    ——————————————————

    post_title:Update Error
    post_content:Update Task
    Total update count: 0
    Update IDs: Array
    (
    )
    Update: Array
    (
        [update_info] => Array
            (
                [id] => migrate_existing_logs
                [version] => 2.10.0
                [callback] => Array
                    (
                        [0] => Give\Log\Migrations\MigrateExistingLogs Object
                            (
                                [logTypeHelper:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LogTypeHelper Object
                                    (
                                    )
    
                                [legacyLogsTable:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LegacyLogsTable Object
                                    (
                                    )
    
                            )
    
                        [1] => run
                    )
    
                [type] => database
            )
    
        [step] => 643721
        [update] => 29
        [heading] => Update 29 of 30
        [percentage] => 0
        [total_percentage] => 93
    )
    post_parent:0
    log_type:update
    file:/home/hx1zw7zvwkay/public_html/staging/wp-content/plugins/give/includes/class-give-background-updater.php
    line:365
    function:add
    class:Give_Logging

    The second error (Update pause) log gives the following:
    ——————————————————-

    post_title:Update Pause
    post_content:stdClass Object
    (
        [key] => wp_give_db_updater_batch_932d9258387bb8eb59976bc779f0b6d5
        [data] => Array
            (
                [14] => Array
                    (
                        [id] => v20_rename_donor_tables
                        [version] => 2.0.0
                        [callback] => give_v20_rename_donor_tables_callback
                        [depend] => Array
                            (
                                [0] => v20_move_metadata_into_new_table
                                [1] => v20_logs_upgrades
                                [2] => v20_upgrades_form_metadata
                                [3] => v20_upgrades_payment_metadata
                                [4] => v20_upgrades_user_address
                                [5] => v20_upgrades_donor_name
                            )
    
                        [type] => database
                    )
    
                [29] => Array
                    (
                        [id] => migrate_existing_logs
                        [version] => 2.10.0
                        [callback] => Array
                            (
                                [0] => Give\Log\Migrations\MigrateExistingLogs Object
                                    (
                                        [logTypeHelper:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LogTypeHelper Object
                                            (
                                            )
    
                                        [legacyLogsTable:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LegacyLogsTable Object
                                            (
                                            )
    
                                    )
    
                                [1] => run
                            )
    
                        [type] => database
                    )
    
            )
    
    )
    post_parent:0
    log_type:update
    file:/home/hx1zw7zvwkay/public_html/staging/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
    line:360
    function:add
    class:Give_Logging

    The third error (Update health check) log gives the following:
    ————————————————————-

    post_title:Update Health Check
    post_content:Array
    (
        [id] => migrate_existing_logs
        [version] => 2.10.0
        [callback] => Array
            (
                [0] => Give\Log\Migrations\MigrateExistingLogs Object
                    (
                        [logTypeHelper:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LogTypeHelper Object
                            (
                            )
    
                        [legacyLogsTable:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LegacyLogsTable Object
                            (
                            )
    
                    )
    
                [1] => run
            )
    
        [type] => database
    )
    
    Updated doing update:
    Array
    (
        [update_info] => Array
            (
                [id] => migrate_existing_logs
                [version] => 2.10.0
                [callback] => Array
                    (
                        [0] => Give\Log\Migrations\MigrateExistingLogs Object
                            (
                                [logTypeHelper:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LogTypeHelper Object
                                    (
                                    )
    
                                [legacyLogsTable:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LegacyLogsTable Object
                                    (
                                    )
    
                            )
    
                        [1] => run
                    )
    
                [type] => database
            )
    
        [step] => 643721
        [update] => 1
        [heading] => Update 1 of 0
        [percentage] => 0
        [total_percentage] => 0
    )
    
    post_parent:0
    log_type:update
    file:/home/hx1zw7zvwkay/public_html/staging/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
    line:574
    function:add
    class:Give_Logging

    ——————————————————–
    Please let me know. I did not deactivate all the plug-ins when I ran it this time.

    thanks, Terri

    Thread Starter circleb

    (@circleb)

    @mrdaro Here’s the Update Errors that I could find:

    Description:
    Update Error
    Category:
    Migration
    Source:
    Give Core
    Date & Time:
    2021-04-23 07:23:31
    Error details:

    post_title:Update Error
    post_content:Update Task
    Array
    (
        [update_info] => Array
            (
                [id] => add-past-donation-data-to-revenue-table
                [version] => 2.9.0
                [callback] => Array
                    (
                        [0] => Give\Revenue\Migrations\AddPastDonationsToRevenueTable Object
                            (
                            )
    
                        [1] => run
                    )
    
                [type] => database
            )
    
        [step] => 1
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    
    Error
     Query failed in database
    post_parent:0
    log_type:update
    file:/home/evangell/public_html/aspringofhope.com/wp-content/plugins/give/includes/class-give-background-updater.php
    line:394
    function:add
    class:Give_Logging

    Description:
    Update Error
    Category:
    Migration
    Source:
    n/a
    Date & Time:
    2021-04-14 00:11:14
    Error details:

    post_title:Update Error
    post_content:Update Task
    Array
    (
        [update_info] => Array
            (
                [id] => add-past-donation-data-to-revenue-table
                [version] => 2.9.0
                [callback] => Array
                    (
                        [0] => Give\Revenue\Migrations\AddPastDonationsToRevenueTable Object
                            (
                            )
    
                        [1] => run
                    )
    
                [type] => database
            )
    
        [step] => 1
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    
    Error
     Query failed in database
    post_parent:0
    log_type:update
    file:/home/evangell/public_html/aspringofhope.com/wp-content/plugins/give/includes/class-give-background-updater.php
    line:394
    function:add
    class:Give_Logging

    Description:
    Update Error
    Category:
    Migration
    Source:
    n/a
    Date & Time:
    2021-04-14 00:08:41
    Error details:

    post_title:Update Error
    post_content:Update Task
    Array
    (
        [update_info] => Array
            (
                [id] => add-past-donation-data-to-revenue-table
                [version] => 2.9.0
                [callback] => Array
                    (
                        [0] => Give\Revenue\Migrations\AddPastDonationsToRevenueTable Object
                            (
                            )
    
                        [1] => run
                    )
    
                [type] => database
            )
    
        [step] => 1
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    
    Error
     Query failed in database
    post_parent:0
    log_type:update
    file:/home/evangell/public_html/aspringofhope.com/wp-content/plugins/give/includes/class-give-background-updater.php
    line:394
    function:add
    class:Give_Logging

    Good afternoon,
    a) I see that you have released a new version of the plug-in. Should I try installing that and rerunning the updater?
    b) My environment currently has no donations as I am just setting it up for the first time. Could that be the issue with the updater?
    Waiting to hear back from you …
    thanks, Terri

    Hello, Please advise if I should install the new version of the plugin to fix this? I have not been able to successfully run the Updater in my database as of yet. Please review my error logs posted previously.
    thanks, Terri

    Plugin Support Rick Alday

    (@mrdaro)

    @circleb

    That error is consistent with not having a give_revenue table in the database.

    The fix is really simple.

    1. First, backup your site and be sure you are comfortable recovering from that backup just in case.

    2. Enable Advanced Database Updates in Donations -> Settings -> Advanced:

    3. Next, they can run the update in Donations -> Tools -> Data, find create_revenue_table and click the Re-run Update button.

    4. Last, go back to in Donations -> Settings -> Advanced and disable Advanced Database Updates.

    Then try to complete the database update process and let me know if the issue persists.

    Thanks!`

    Plugin Support Rick Alday

    (@mrdaro)

    Do you still need assistance here? Feel free to reopen this ticket if you need further assistance and we’ll happily help you.

    Thanks for using GiveWP! Have a great day.

    Hello.

    I am having this same issue but my host will not update MySQL 5.7 as I am on shared hosting. is there a workaround?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘An unexpected issue occurred during the database update’ is closed to new replies.