unexpected issue occurred during the database update

  • Resolved sophisticationdesign

    (@sophisticationdesign)


    3 years, 2 months ago

    I have an unexpected update error that keeps occurring for the Give WP plugin. I have tried multiple fixes and nothing works. I even tried the health check plugin for Give WP and nothing happens. I don’t even know how to tell what is wrong there is no additional info message just reads:

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Rick Alday

    (@mrdaro)

    Hi @sophisticationdesign,

    Happy to help.

    For a bit of context, GiveWP 2.10 included some database upgrades in order to provide new features right now and for the future, but some hosts prevented the upgrade from being completed correctly. You’re getting that error that means the migrations didn’t run successfully.

    To fix it, do the following:

    1. First, I’d recommend taking a backup of the site that you can confidently restore from. Here’s an article we wrote that explains more clearly how to do that: https://givewp.com/backup-for-faster-troubleshooting/
    2. Next, enable Advanced Database Updates in Donations > Settings > Advanced.
    3. Next, run the update in Donations -> Tools -> Data, and based on the Run Order columns, re-run the create_revenue_table update. If you notice any pending updates, run them as well.
    4. Check the logs at Donations > Tools > Logs for errors. If there are any errors, pass those along here.
    4. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.

    Thanks!

    Thread Starter sophisticationdesign

    (@sophisticationdesign)

    So, I tried the instructions you sent. Under data, all of the columns say “Success” but I still got the error. Here’s the log from today –

    Error
    Core
    Revenue Migration
    2021-09-13 14:24:33
    An error occurred inserting data into the revenue table

    Error
    Migration
    Give Core
    2021-09-13 14:24:33
    Update Pause

    Error
    Migration
    Give Core
    2021-09-13 14:24:33
    Update Health Check

    Error
    Migration
    Give Core
    2021-09-13 14:24:29
    Update Health Check

    Error
    Migration
    Give Core
    2021-09-13 14:24:29
    Update Restart`

    Plugin Support Matheus Martins

    (@matheusfd)

    Hey @sophisticationdesign,

    The error: “An error occurred inserting data into the revenue table” means that something is missing for a donation and the database update won’t continue until it’s fixed.

    Probably, you’ll have a similar error to the following: Error: An error occurred when processing Donation #1575.

    It means that donation #1575 is probably missing some essential data and this is preventing you from running the database upgrade.

    Navigate to Donations > Donations and search for 1575. 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.

    The donation number here is only an example, so you need to see which is the corrupted donation on your site.

    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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘unexpected issue occurred during the database update’ is closed to new replies.