Database Update Error: An unexpected issue occurred during the database update

  • Resolved Dayton Design

    (@wbbuilder)


    3 years, 7 months ago

    I have a local charity site running this donations plugins for many years. All has worked fine. I just upgraded my PHP from v5.4 to v7.4. Before upgrading PHP (still on PHP v5.4) I updated Give plugin and I received this error:

    Database Update – An unexpected issue occurred during the database update which caused it to stop automatically. Please contact support for assistance.

    I followed the manual database upgrade instructions here under the solution: https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/ but it won’t update manually either. Your plugin has years worth of donations and stats, and I don’t want to lose it.

    I see these items under database updates but cannot update them: 

    Success
Create new give_migrations table
2021-04-15 18:37:39
GiveWP Core
1
Success
create_revenue_table
2021-04-15 18:37:44
GiveWP Core
2
Success
remove_revenue_foreign_keys
2021-04-15 18:37:48
GiveWP Core
3
Success
set_paypal_standard_id_to_paypal_from_paypal_standard
2021-04-15 18:37:51
GiveWP Core
4
Success
Create new give_log table
2021-04-15 18:37:55
GiveWP Core
5
Success
Migrate completed migrations to give_migrations table
2021-04-15 18:37:59
GiveWP Core
6

    I see these errors under the logs:

    Status
Category
Source
Date/Time
Description
Details
Error
Core
Revenue Migration
2021-04-15 23:38:50
An error occurred inserting data into the revenue table
Error
Migration
Give Core
2021-04-15 23:38:50
Update Pause
Error
Migration
Give Core
2021-04-15 23:38:50
Update Health Check
Error
Migration
Give Core
2021-04-15 23:38:49
Update Health Check
Error
Migration
Give Core
2021-04-15 23:38:49
Update Restart
Error
Core
Revenue Migration
2021-04-15 23:34:55
An error occurred inserting data into the revenue table
Error
Migration
Give Core
2021-04-15 23:34:55
Update Pause
Error
Migration
Give Core
2021-04-15 23:34:55
Update Health Check
Error
Migration
Give Core
2021-04-15 23:34:54
Update Health Check
Error
Migration
Give Core
2021-04-15 23:34:54
Update Restart

    What should I try next? Everything in my WordPress site is updated to the lastest versions (except your database tables) and my PHP is now v7.4. Cannot seem to get my database updated for your plugin.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Dayton Design

    (@wbbuilder)

    OH yes, I also disabled my security and any cache plugins as well. They are all off!

    Plugin Support Matheus Martins

    (@matheusfd)

    Hey @wbbuilder,

    Happy to help you.

    Something that caught my attention is the An error occurred inserting data into the revenue table error because this error will tell you what is going wrong with your application.

    If it says that there was a problem with a specific donation, you’ll need to check this donation under Donations > Donations to see if it’s corrupted. If it is, then you need to fix it by adding the necessary data or delete it, and then restart the database upgrade. You’ll need to do this process for every donation.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Update Error: An unexpected issue occurred during the database update’ is closed to new replies.