Support » Plugin: GiveWP - Donation Plugin and Fundraising Platform » Fresh new install of OceanWP, GiveWP fails database update

  • Resolved kfegan

    (@kfegan)


    I am trying to create a new website using OceanWP and the template I have selected recommends GiveWP as a plugin.

    This is a fresh install on a production server, haven’t even altered the demo template yet.

    GiveWP says it needs to update the database (32 items). It fails the 1st attempt. Trying to rerun the update (2 items) fails again & says to contact support.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Ben Meredith

    (@benmeredithgmailcom)

    Hi @kfegan

    I just attempted to replicate that and I’m not seeing a fresh install prompt for updates.

    Did the version of GiveWP that you started from come bundled with the theme, or did you download it directly from the WordPress plugin directory?

    What version of GiveWP are you on now?

    When you go to Donations > Tools > Logs are you seeing anything there?

    Finally, please send along your System Info.

    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.

    As I update the plugin with my various active installs, I get the same error message for all websites.

    “There was a problem running the migrations. Please reach out to GiveWP support for assistance: https://givewp.com/support”

    Thread Starter kfegan

    (@kfegan)

    It’s the GiveWP that came bundled with Ocean’s Bounty Theme.

    It looks to be version 2.10.0

    Under Donations>tools>logs, there’s 3 pages of errors.

    System info:

    WordPress Environment
    Home URL:		https://canadianhorsedefencecoalition.kylefegan.com
    Site URL:		https://canadianhorsedefencecoalition.kylefegan.com
    WP Version:		5.7
    WP Multisite:		–
    WP Memory Limit:		1 GB
    WP Debug Mode:		–
    WP Cron:		
    Language:		en_US
    Permalink Structure:		/%year%/%monthnum%/%day%/%postname%/
    Show on Front:		posts
    Table Prefix:		wpbg_
    Table Prefix Length:		5
    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: canadianhorsedefencecoalition.kylefegan.com
    TLS Connection:		Connection uses TLS 1.3
    TLS Rating:		Probably Okay
    Server Info:		Apache
    PHP Version:		7.4.15
    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.0
    GiveWP Cache:		Enabled
    Database Updates:		2 updates still need to run. (Paused)
    Database Migrations:		All Database Migrations Completed.
    Database Tables:		
     wpbg_give_donors
     wpbg_give_donormeta
     wpbg_give_comments
     wpbg_give_commentmeta
     wpbg_give_sessions
     wpbg_give_formmeta
     wpbg_give_sequential_ordering
     wpbg_give_donationmeta
     wpbg_give_revenue
    GiveWP Cache:		Enabled
    GiveWP Emails:		
    New Donation
    Donation Receipt
    New Offline Donation
    Offline Donation Instructions
    New User Registration
    User Registration Information
    Donation Note
    Email access
    Upgraded From:		–
    Test Mode:		Disabled
    Currency Code:		USD
    Currency Position:		After
    Decimal Separator:		.
    Thousands Separator:		,
    Success Page:		https://canadianhorsedefencecoalition.kylefegan.com/donation-confirmation/
    Failure Page:		https://canadianhorsedefencecoalition.kylefegan.com/donation-failed/
    Donation History Page:		https://canadianhorsedefencecoalition.kylefegan.com/donor-dashboard/
    GiveWP Forms Slug:		/donations/
    Enabled Payment Gateways:		Test Donation
    Default Payment Gateway:		Test Donation
    PayPal IPN Verification:		Enabled
    PayPal IPN Notifications:		N/A
    Donor Email Access:		Disabled
    Stripe Webhook Notifications:		N/A
    Active GiveWP Add-ons
    Other Active Plugins
    Elementor	 	by Elementor.com – 3.1.4
    Loginizer	 	by Softaculous – 1.6.6
    Ocean Extra	 	by OceanWP – 1.7.4
    Ocean Pro Demos	 	by OceanWP – 1.1.5
    Ocean Social Sharing	 	by OceanWP – 1.1.1
    WPForms Lite	 	by WPForms – 1.6.5
    Inactive Plugins
    Akismet Anti-Spam	 	by Automattic – 4.1.9
    Hello Dolly	 	by Matt Mullenweg – 1.7.2
    Theme
    Name:		OceanWP Child
    Version:		1.0
    Author URL:		https://oceanwp.org/
    Child Theme:		Yes
    Parent Theme Name:		OceanWP
    Parent Theme Version:		2.0.3
    Parent Theme Author URL:		https://oceanwp.org/about-me/
    Plugin Contributor Ben Meredith

    (@benmeredithgmailcom)

    @kfegan Can you send a screenshot and/or copy paste a few of the errors you are seeing on the logs page? I don’t see anything from that system info that points directly to a problem.

    The “details” column of the logs is what I need. If there are different errors, send all the ones you see.

    Thanks!

    Thread Starter kfegan

    (@kfegan)

    Looks like they are all Migration errors. I’ll paste a few of the logs below:

    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] => 745150
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    post_parent:0
    log_type:update
    file:/home/kfegan/canadianhorsedefencecoalition.kylefegan.com/wp-content/plugins/give/includes/class-give-background-updater.php
    line:365
    function:add
    class:Give_Logging
    post_title:Update Pause
    post_content:stdClass Object
    (
        [key] => wp_give_db_updater_batch_77308bd7705a5e43c8ce617b47901d1f
        [data] => Array
            (
                [16] => 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
                    )
    
                [31] => 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/kfegan/canadianhorsedefencecoalition.kylefegan.com/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
    line:360
    function:add
    class:Give_Logging
    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] => 745150
        [update] => 1
        [heading] => Update 1 of 0
        [percentage] => 0
        [total_percentage] => 0
    )
    
    post_parent:0
    log_type:update
    file:/home/kfegan/canadianhorsedefencecoalition.kylefegan.com/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
    line:574
    function:add
    class:Give_Logging
    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] => 739974
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    
    post_parent:0
    log_type:update
    file:/home/kfegan/canadianhorsedefencecoalition.kylefegan.com/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
    line:574
    function:add
    class:Give_Logging
    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] => 739974
        [update] => 1
        [heading] => Update 1 of 2
        [percentage] => 0
        [total_percentage] => 0
    )
    post_parent:0
    log_type:update
    file:/home/kfegan/canadianhorsedefencecoalition.kylefegan.com/wp-content/plugins/give/includes/class-give-background-updater.php
    line:365
    function:add
    class:Give_Logging
    Thread Starter kfegan

    (@kfegan)

    There are others I can copy paste if it helps…

    Plugin Support Rick Alday

    (@mrdaro)

    Hi @kfegan,

    GiveWP version 2.10.0 was released a few days ago and it included database upgrades that didn’t run well on websites running MySQL versions older than 5.7. Our dev team released a new update today that fixes it and to do so you need to update GiveWP.

    In this case, you can click on Plugins > Installed Plugins and click to update your plugins. If you do not see an update for it, it’s just the cache. You can navigate to Dashboard > Updates and click on Check Again. It will check for the updates and clear the cache and you’ll be able to update the plugin.

    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/

    Bear in mind that although it’s compatible with MySQL 5.5 or later right now, we still encourage you to reach out to your hosting company and ask them to update your MySQL to something greater than 5.7.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.