Database Updates Won’t Complete

Resolved

(@worldimpactministries)

Donations section says we have 2 updates. When I click on “Restart Upgrades” it blinks and then the “Restart Upgrades” re-appears. Dashboards says “Database Update – An unexpected issue occurred during the database update which caused it to stop automatically. Please contact support for assistance.”

I’ve updated everything to current (WordPress, plugins, themes) except for WPBakery Visual Composer (licencing issues, currently fixing). Not aware of any special caching or security setups.

Reran the last updates under Tools>Data>Database updates (6 of them from “Create new give_migrations table” to “Create new give_migrations table”) with all flagged “Success”.

How do I fix? Any help appreciated.

Thanks,
Allen

### WordPress Environment ###

Home URL: https://wayofpeace.net
Site URL: https://wayofpeace.net
WP Version: 5.8
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_CA
Permalink Structure: /news/%postname%/
Show on Front: page
Page on Front: (#22)
Page for Posts: Sample Page (#2)
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, wc-pending, wc-processing, wc-on-hold, wc-completed, wc-cancelled, wc-refunded, wc-failed, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, tribe-ea-success, tribe-ea-failed, tribe-ea-schedule, tribe-ea-pending, tribe-ea-draft, tribe-ignored

### Server Environment ###

Hosting Provider: DBH: localhost, SRV: wayofpeace.net
TLS Connection: Connection uses TLS 1.2
TLS Connection: Probably Okay
Server Info: Apache/2.4.25 (Debian)
PHP Version: 7.4.14
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
PHP Max Upload Size: 128 MB
cURL Version: 7.52.1, OpenSSL/1.0.2u
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.11.3
GiveWP Cache: Enabled
Database Updates: 2 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
Upgraded From: 2.11.3
Test Mode: Disabled
Currency Code: CAD
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: https://wayofpeace.net/donation-confirmation-2/
Failure Page: https://wayofpeace.net/donation-failed-2/
Donation History Page: https://wayofpeace.net/donor-dashboard/
GiveWP Forms Slug: /donations/
Enabled Payment Gateways: PayPal Standard
Default Payment Gateway: PayPal Standard
PayPal IPN Verification: Enabled
PayPal IPN Notifications: IPN received for #801 ( 5NX19125SE839831R ) on 06/25/2021 at 20:06. Status VERIFIED
Donor Email Access: Disabled
Stripe Webhook Notifications: N/A

### Active GiveWP Add-ons ###

### Other Active Plugins ###

Akismet Anti-Spam: by Automattic – 4.1.10
Aweber Forms by Optin Cat: by Fatcat Apps – 2.5.4
Contact Form 7: by Takayuki Miyoshi – 5.4.2
Essential Grid: by ThemePunch – 2.1.0.2
Head, Footer and Post Injections: by Stefano Lissa – 3.2.2
Slider Revolution: by ThemePunch – 5.4.1
Social Count Plus: by Claudio Sanches – 3.3.6
The Events Calendar: by The Events Calendar – 5.8.1
Webnus Causes: by Webnus – 1.0
Webnus Sermons: by Webnus – 1.2.1
WooCommerce: by Automattic – 5.5.1
WP-PageNavi: by Lester 'GaMerZ' Chan – 2.94.0
WPBakery Visual Composer: by Michael M - WPBakery.com – 5.1
WP Maintenance Mode: by Designmodo – 2.4.1

### Inactive Plugins ###

LayerSlider WP: by Kreatura Media – 6.1.6

### Theme ###

Name: Divi
Version: 4.9.10
Author URL: http://www.elegantthemes.com
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 3 replies - 1 through 3 (of 3 total)

informativos

(@informativos)

4 years, 10 months ago

Samsung problem here… started yesterday. Updated manuales. Nothing. Looking for another plugin alternative

Plugin Support

Matheus Martins

(@matheusfd)

4 years, 10 months ago

Hey @informativos,

When you see the Database Update – An unexpected issue occurred during the database update which caused it to stop automatically. error, it means that GiveWP stopped the database upgrade for security reasons, to keep your donations integer.

To identify what caused the error, check the logs at Donations > Tools > Logs for errors. If there are any errors, pass those along here.

If you see something like this:
Error: An error occurred when processing Donation #1575 (or another number).

It means that donation #1575 (or the number that was displayed) is probably missing some essential data and this is preventing you from running the database upgrade.

Navigate to Donations > Donations and search for 1575 (or the number that was displayed). If this is missing a donor, amount, email, or form, then you can edit it. However, if this is entirely corrupt, you can also delete it.

After that, try to run the database upgrade again. If it gets stuck, then navigate to your logs and check if there are other corrupted donations. If there are, then you can either try to fix them or delete them. Then, repeat this process until the database upgrade is finished.

Please let us know if you have further questions on this or need any additional assistance!

informativos

(@informativos)

4 years, 10 months ago

First of all: thnks for the help. We are testing the plugin to use it in our foundation site, so no real transactions are been made by now. We were planning to set the site online this weekend. The log error says:

Error
Migration
Núcleo de Give
2021-07-21 18:20:03
Update Error

Error
Migration
Núcleo de Give
2021-07-21 18:20:03
Update Pause

Error
Migration
Núcleo de Give
2021-07-21 18:20:03
Update Health Check

Error
Migration
Núcleo de Give
2021-07-21 18:19:23
Update Health Check

Error
Migration
Núcleo de Give
2021-07-21 18:19:23
Update Restart

Error
Migration
Núcleo de Give
2021-07-21 18:19:08
Update Pause

Error
Migration
Núcleo de Give
2021-07-21 18:19:08
Update Health Check

and so on…

And this are the error message for update Health Check:

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] => 339906
    [update] => 1
    [heading] => Update 1 of 0
    [percentage] => 0
    [total_percentage] => 0
)

post_parent:0
log_type:update
file:/home/inform26/fundacion.informativos.es/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php
line:574
function:add
class:Give_Logging

For the UPDATE ERROR is this:

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] => 339906
    [update] => 1
    [heading] => Update 1 of 2
    [percentage] => 0
    [total_percentage] => 0
)
post_parent:0
log_type:update
file:/home/inform26/fundacion.informativos.es/wp-content/plugins/give/includes/class-give-background-updater.php
line:365
function:add
class:Give_Logging

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database Updates Won’t Complete’ is closed to new replies.