Fresh new install of OceanWP, GiveWP fails database update

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”

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/

@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!

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

There are others I can copy paste if it helps…

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.