Database Update Error – tried everything

  • Resolved kerizteeun

    (@kerizteeun)


    5 years, 4 months ago

    Hello, I have an issue following update of the plugin, the database update does not run. I have been through all the documentation and other topics on the subject posted here. I have tried disabling other plugins, clearing cache, checking access to ajax, etc. Gone through the manual re-run. But still am not able to update the database. Below is the error message I am being returned.

    Close
    Update Task
    Array
    (
    [update_info] => 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
    )

    [step] => 1
    [update] => 1
    [heading] => Update 1 of 1
    [percentage] => 0
    [total_percentage] => 0
    )

    Error
    An error occurred when processing Donation #3819. To insert revenue, please provide valid donation_id, form_id, amount.

    Any help gratefully appreciated as I am in the final stages of developing the site for a small non-profit that I run and the donation facility being unavailable would be very unfortunate.

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Ben Meredith

    (@benmeredithgmailcom)

    5 years, 4 months ago

    Hi @kerizteeun!

    That error means that something has corrupted the data on that specific donation (#3819). The fix is to make sure that donation is properly associated with a donation form, and has a correct amount.

    All donations need to be properly associated with at form for this database update to run correctly.

    This issue is one that I’ve escalated to our development team to have a look at. You can follow along on this post: https://feedback.givewp.com/bug-reports/p/database-updates-should-be-able-to-proceed-despite-individual-corrupt-donation-r

    I’m going to mark this post as resolved, but only because you can follow along on the post over on the feedback site. Keep in mind that the immediate fix for you is to manually associate those donations with a form and ensure that all of them have a valid amount.

    Thanks!

    Thread Starter kerizteeun

    (@kerizteeun)

    5 years, 4 months ago

    Hi Ben,

    I’ll keep an eye on that post, thanks. I don’t actually have any real donations on the site as I have Give in test mode, if that helps at all?

    Is there any documentation about how to fix or even delete a donation in database?

    • This reply was modified 5 years, 4 months ago by kerizteeun.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database Update Error – tried everything’ is closed to new replies.