Hi @alex_stoiu
Usually when the database update hangs, the error is logged in the logs at Donations > Tools > Logs. Check those logs for clues.
The most common cause for those updates to stall is if donations have become unattached from their donation forms. We’ve seen this happen to some folks, and the only fix is to maunally go through the donations list and select the donation and reattach it to the donation form, and save it.
Let me know if that resolves things, or if you need further assistance. Thanks for using GiveWP! Have a great day.
Hello, thank you so much for your reply!
I have added the forms and donors to the donations and have restarted the updates, but unfortunately to no effect.
There are many errors in the Log section, most of them stating ‘Update Health Check’, ‘Update Restart’, ‘Update Pause’ or ‘Update Error’ in the description.
Your further assistance on this matter is greatly appreciated.
Thank you!
Hey @alex_stoiu focusing on the most recent one that reads “Update Error” what does the full text of the error say?
Note that ALL donations have to be attached to a form, not just the one in the error message.
Hello again Ben and thanks again for the reply!
Please note that all donations are linked to the donation form.
Here are the details of the Update Error:
Log ID: 160
Description:
Update Error
Category:
Migration
Source:
Give Core
Date & Time:
2021-06-05 09:20:00
Error details:
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] => 2739014
[update] => 1
[heading] => Update 1 of 2
[percentage] => 0
[total_percentage] => 0
)
post_parent:0
log_type:update
file:/home/u178467373/domains/tarkovskiana.ro/public_html/wp-content/plugins/give/includes/class-give-background-updater.php
line:365
function:add
class:Give_Logging
Ah, this is now an issue of the logs not migrating correctly.
Here’s a long-winded explanation:
We overhauled the logging system in GiveWP in version 2.10.x to make it much more easy 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 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.
Thank you again for your replies and help in solving this issue.
Unfortunately I am not very familiar with SQL and don’t know how to go about the instructions you provided.
Could you please provide detailed (step by step) instructions on how to apply your solution? Do I just paste and run that sql code in phpmyadmin?
Thank you!
Hi again,
I have contacted my host in regards to this, have created the new table, but before manually migrating the logs, the support agent wanted to know the following information:
Perhaps you could clarify with the plugin's creator on the table sections? At the moment, your old table has id, log_type, data, category, source and date:
While the new one has id, log_title, log_content, log_parent, log_type, log_date, log_date_gtm:
I would not want you to lose any data, therefore, could you ask him whether you will need to insert additional information to the rest of the fields or can they be replaced by the same ones you had in the old table?
Awaiting for your reply.
Thank you very much!
Hi @alex_stoiu,
There’s no need to add sections to the old logs table. The migration will take care of mapping the data to the new table correctly.
Thank you all so much for your replies and support!
Hey @alex_stoiu,
We are always happy to help you.
We’d love to get a public review about what you think of GiveWP both from a product standpoint as well as how it is to deal with our team. Here are some options:
WordPress: https://ww.wp.xz.cn/support/view/plugin-reviews/give
Google: https://g.page/givewp/review?rc
Facebook: https://www.facebook.com/pg/wpgive/reviews/
The reviews help others to decide if it’s worth doing business with us!
Have a great day!
