GiveWP

Hey,

This is not an official response to your question, but I saw your post and I’m wondering if you tried manually replacing the plugin files via FTP to satisfy the update.

Plugin Support

(@mrdaro)

https://gist.github.com/rickalday/24fc18ef298d5604e4c4f7f6ea658bc5

Hi @tkouch,

What’s going on here is a result of a missing table on the site. Here’s a long-winded explanation:

We overhauled the logging system in GiveWP in version 2.10.x to make it much easier to manage logs in the application. A part of that overhaul was taking the existing logs (in a table named wp_give_logs) and moving them to a new table that was structured in a way that is more performant. The new table is named wp_give_log (no s on the end). The order of events was the following:

1. create the new log table. (this happens silently upon update to 2.10.x)
2. migrate the logs from the old logs table to the new log table (this happens as a result of clicking the button to run the updates)
3. delete the old and no longer needed logs table. (this happens at the end of step 2, automatically)

I suspect that somehow on your site the logs table was deleted before the migration in step 2 happened, and GiveWP doesn’t know how to fix that, so it just fails with a logged failure.

You can add the missing _give_logs table with the following SQL command:
(Do NOT try this on your live site. Do it in a staging site first and be sure to backup first!)

Please note that the table prefix wp_ may be different on your database so edit the command accordingly.

Your host might be able to help you implement the table in the database if you’re not comfortable with code.

Once that is done you can proceed with the database update (it may require pausing and restarting the update routine a couple of times, and refreshing the page).

Let me know if that resolves things, or if you need further assistance. Thanks for using GiveWP! Have a great day.`

This reply was modified 4 years, 11 months ago by Rick Alday.

Thread Starter

TKouch

(@tkouch)

Thanks for your help. I did exactly as your instructions said. Afterwards, the wp_give_log table was empty and the wp_give_logs table had 1 row in it.

I then re-installed the Give-Donation plugin (version 2.4.10) and tried to run the updater. It gave me this error almost immediately:
An unexpected issue occurred during the database update which caused it to stop automatically. Please contact support for assistance.

There are 3 error logs created from running the updater:

(1) `Description: Update Error
Category: Migration
Source: Give Core
Date & Time: 2021-05-07 18:04:53`
Error details:

post_title:Update Error
post_content:Update Task
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] => 1
    [update] => 29
    [heading] => Update 29 of 30
    [percentage] => 0
    [total_percentage] => 90
)

Error
 Query failed in database
post_parent:0
log_type:update
file:/home/hx1zw7zvwkay/public_html/staging/wp-content/plugins/give/includes/class-give-background-updater.php
line:394
function:add
class:Give_Logging

================================

Description: Update Pause
Category: Migration
Source: Give Core
Date & Time: 2021-05-07 18:04:53
Error details:

post_title:Update Pause
post_content:stdClass Object
(
[key] => wp_give_db_updater_batch_1bdaa3e068beaebc540c9164ac503d67
[data] => Array
(
[10] => Array
(
[id] => v20_upgrades_user_address
[version] => 2.0.0
[callback] => give_v20_upgrades_user_address
[type] => database
)

[11] => Array
(
[id] => v20_upgrades_payment_metadata
[version] => 2.0.0
[callback] => give_v20_upgrades_payment_metadata_callback
[type] => database
)

[12] => Array
(
[id] => v20_upgrades_donor_name
[version] => 2.0.0
[callback] => give_v20_upgrades_donor_name
[type] => database
)

[13] => Array
(
[id] => v20_move_metadata_into_new_table
[version] => 2.0.0
[callback] => give_v20_move_metadata_into_new_table_callback
[depend] => Array
(
[0] => v20_upgrades_payment_metadata
[1] => v20_upgrades_form_metadata
)

[type] => database
)

[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
)

[15] => Array
(
[id] => v201_upgrades_payment_metadata
[version] => 2.0.1
[callback] => give_v201_upgrades_payment_metadata_callback
[type] => database
)

[16] => Array
(
[id] => v201_add_missing_donors
[version] => 2.0.1
[callback] => give_v201_add_missing_donors_callback
[type] => database
)

[17] => Array
(
[id] => v201_move_metadata_into_new_table
[version] => 2.0.1
[callback] => give_v201_move_metadata_into_new_table_callback
[depend] => Array
(
[0] => v201_upgrades_payment_metadata
[1] => v201_add_missing_donors
)

[type] => database
)

[18] => Array
(
[id] => v210_verify_form_status_upgrades
[version] => 2.1.0
[callback] => give_v210_verify_form_status_upgrades_callback
[type] => database
)

[19] => Array
(
[id] => v213_delete_donation_meta
[version] => 2.1.3
[callback] => give_v213_delete_donation_meta_callback
[depends] => Array
(
[0] => v201_move_metadata_into_new_table
)

[type] => database
)

[20] => Array
(
[id] => v215_update_donor_user_roles
[version] => 2.1.5
[callback] => give_v215_update_donor_user_roles_callback
[type] => database
)

[21] => Array
(
[id] => v224_update_donor_meta
[version] => 2.2.4
[callback] => give_v224_update_donor_meta_callback
[type] => database
)

[22] => Array
(
[id] => v224_update_donor_meta_forms_id
[version] => 2.2.4
[callback] => give_v224_update_donor_meta_forms_id_callback
[depend] => Array
(
[0] => v224_update_donor_meta
)

[type] => database
)

[23] => Array
(
[id] => v230_move_donor_note
[version] => 2.3.0
[callback] => give_v230_move_donor_note_callback
[type] => database
)

[24] => Array
(
[id] => v230_move_donation_note
[version] => 2.3.0
[callback] => give_v230_move_donation_note_callback
[type] => database
)

[25] => Array
(
[id] => v230_delete_donor_wall_related_donor_data
[version] => 2.3.0
[callback] => give_v230_delete_dw_related_donor_data_callback
[depend] => Array
(
[0] => v224_update_donor_meta
[1] => v224_update_donor_meta_forms_id
[2] => v230_move_donor_note
[3] => v230_move_donation_note
)

[type] => database
)

[26] => Array
(
[id] => v230_delete_donor_wall_related_comment_data
[version] => 2.3.0
[callback] => give_v230_delete_dw_related_comment_data_callback
[depend] => Array
(
[0] => v230_move_donor_note
[1] => v230_move_donation_note
)

[type] => database
)

[27] => Array
(
[id] => v240_update_form_goal_progress
[version] => 2.4.0
[callback] => give_v240_update_form_goal_progress_callback
[type] => database
)

[28] => 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
)

[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`

================================

Description: Update Health Check
Category: Migration
Source: Give Core
Date & Time: 2021-05-07 18:04:53
Error details:

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] => upgrade_give_payment_customer_id
[version] => 1.3.2
[callback] => give_v132_upgrade_give_payment_customer_id
[type] => database
)

[step] => 1
[update] => 1
[heading] => Update 1 of 2
[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`

================================

We have NO donation data as I am trying to get this working for the first time. My guess is that the issue came from trying to import demo data from the new theme into our WP environment.

Can I just DELETE the plugin and all the wp_give_ tables from the database and just start over? I just want to get it working.

Thank you so much for your assistance. Terri

Thread Starter

TKouch

(@tkouch)

Hello,
After getting those errors, I tried manually running the database updates/migrations (per your instruction on https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/
Result: each of the 6 database updates ran successfully
Then I tried re-running the database updates, and it failed again. There are now 5 error logs. I will include them here:

update error
————

update pause
————

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] => upgrade_give_payment_customer_id
            [version] => 1.3.2
            [callback] => give_v132_upgrade_give_payment_customer_id
            [type] => database
        )

    [step] => 1
    [update] => 1
    [heading] => Update 1 of 2
    [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

a second update health check error
———————————-

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] => upgrade_give_payment_customer_id
            [version] => 1.3.2
            [callback] => give_v132_upgrade_give_payment_customer_id
            [type] => database
        )

    [step] => 1
    [update] => 1
    [heading] => Update 1 of 2
    [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

update restart
————–

THANKS FOR YOU ASSISTANCE!!
Terri

Plugin Support

(@mrdaro)

We’ve seen this happen with another user just today, and for them it came down to a missing database table.

Here’s a long-winded explanation:

1. create the new log table. (this happens silently upon update to 2.10.x)
2. migrate the logs from the old logs table to the new log table (this happens as a result of clicking the button to run the updates)
3. delete the old an no longer needed logs table. (this happens at the end of step 2, automatically)

Somehow on their site the logs table was deleted before the migration in step 2 happened, and GiveWP doesn’t know how to fix that, so it just kinda fails with a logged failure.

Manually adding back in the logs table and then running the migration fixes the problem.

I’ve linked to a SQL file here with that dummy log in it, for you to attempt the same on your side: https://drive.google.com/file/d/16GSitC3f1XacGTxk_YM1WOfU0U4WIZ-N/view?usp=sharing Your host should be able to help with manually adding in that missing table from this SQL file:

Let me know if that resolves things, or if you need further assistance. Thanks for using GiveWP! Have a great day.

Thread Starter

TKouch

(@tkouch)

You gave me the exact same instructions that you gave me already – I did the steps to add the wp_give_logs table last week and it did NOT fix the problem.

We have NO donation data as I am trying to get this working for the first time. Can I just DELETE the plugin and all the wp_give tables from the database and start over? I just want to get it working.

Please advise! Thanks, Terri

Plugin Support

(@mrdaro)

My bad, in that case, go to Donations -> Settings -> Advanced -> Remove Data on Uninstall, select Yes, Remove all data. Next to go Plugins -> All plugins, deactivate and delete GiveWP.

After this process, you can go ahead and reinstall GiveWP.

Thread Starter

TKouch

(@tkouch)

Thank you Rick.
Just to confirm … my database still has these 4 tables after I deactivated (removing all data) and deleted the plugin:
a. wp_give_log
b. wp_give_logs
c. wp_give_migrations
d. wp_give_revenue

Is that correct or should I delete these tables before I reinstall GiveWP?

Thanks so much, Terri

Plugin Support

(@mrdaro)

Go ahead and delete those tables as well.

Plugin Support

Matheus Martins

(@matheusfd)

Hey @tkouch,

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.

Thread Starter

TKouch

(@tkouch)

Thank You for your assistance. The plugin is now working!!!!

Plugin Support

Matheus Martins

(@matheusfd)