Database Update Unexpected Error

Hey GiveWP Support Team!

One of our clients is having issues with their database updating.

I’ve followed the following steps here: https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/
and here: https://www.ads-software.com/support/topic/unexpected-issue-occurred-during-the-database-update/

But unfortunately the issue is not resolved.

Steps I’ve taken:
– cleared site cache and disabled all plugins besides GiveWP and tried to update database
– enabled advanced updates and updated each entry individually, cleared plugin cache (site cache disabled) and tried to run the updater again, same issue.
– All themes, wp core, plugins are up to date
– Looked for the donation ID in the log but the log contains no entries with the log id (#1936) so I cant remove or edit the donation in question.

Here are the general log entries:

Error

Core

Revenue Migration

2023-02-10 02:35:34

An error occurred inserting data into the revenue table

Error

Migration

Give Core

2023-02-10 02:35:34

Update Pause

Error

Migration

Give Core

2023-02-10 02:35:34

Update Health Check

Error

Migration

Give Core

2023-02-10 02:35:34

Update Health Check

Error

Migration

Give Core

2023-02-10 02:35:34

Update Restart

Error

Core

Revenue Migration

2023-02-10 02:31:36

An error occurred inserting data into the revenue table

Error

Migration

Give Core

2023-02-10 02:31:36

Update Pause

Error

Migration

Give Core

2023-02-10 02:31:36

Update Health Check

Error

Migration

Give Core

2023-02-10 02:31:36

Update Health Check

Error

Migration

Give Core

2023-02-10 02:31:36

Update Restart

Here is detail from the first entry:

{
“Data”: {
“donation_id”: 1936,
“form_id”: 0,
“amount”: 0
},
“Error”: “An error occurred when processing Donation #1936. To insert revenue, please provide valid donation_id, form_id, amount.”
}

And the second entry:

{
“post_title”: “Update Pause”,
“post_content”: “stdClass Object\n(\n [key] => wp_give_db_updater_batch_81d68a5200b87e128f6991361c909d9a\n [data] => Array\n (\n [0] => Array\n (\n [id] => add-past-donation-data-to-revenue-table\n [version] => 2.9.0\n [callback] => Array\n (\n [0] => Give\Revenue\Migrations\AddPastDonationsToRevenueTable Object\n (\n )\n\n [1] => run\n )\n\n [type] => database\n )\n\n [1] => Array\n (\n [id] => migrate_existing_logs\n [version] => 2.10.0\n [callback] => Array\n (\n [0] => Give\Log\Migrations\MigrateExistingLogs Object\n (\n [logTypeHelper:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LogTypeHelper Object\n (\n )\n\n [legacyLogsTable:Give\Log\Migrations\MigrateExistingLogs:private] => Give\Log\Helpers\LegacyLogsTable Object\n (\n )\n\n )\n\n [1] => run\n )\n\n [type] => database\n )\n\n )\n\n)\n”,
“post_parent”: 0,
“log_type”: “update”,
“file”: “/home/341820.cloudwaysapps.com/ctmbdyzgqt/public_html/wp-content/plugins/give/includes/admin/upgrades/class-give-updates.php”,
“line”: 360,
“function”: “add”,
“class”: “Give_Logging”
}

I would appreciate any help you could give!

Best,
Marek

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