‘wp_give_revenue’ doesn’t exist

  • Resolved gresakg

    (@gresakg)


    3 years, 12 months ago

    Hi,
    thanks for your beautyfull plugin!

    I got this in the administration section.

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

    I checked my error logs and found this 

    wp_give_revenue doesn't exist for the query

				SELECT donation_id

				FROM wp_give_revenue

				WHERE donation_id = 8354

    I am usually upgrading my plugins using wp-cli. As sidenote: since Give actually supports wp-cli it would be handy to have a command for post-install actions (like update-db or similar … ).
    Thanks and regards, Greg

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

    (@gresakg)

    Any help or hint would be apreciated.

    Plugin Support Matheus Martins

    (@matheusfd)

    Hey @gresakg,

    Happy to help you.

    The latest updates of GiveWP included a few database upgrades, but some hosts prevented it from completing correctly. To fix it, after you update GiveWP, do the following:

    1. Go to the following URLs, in order: (add your base URL to each)
    /wp-admin/?give-run-migration=create_revenue_table (this manually forces the database routine again)
    /wp-admin/?give-clear-update=add-past-donation-data-to-revenue-table (this clears the update so that your site can try again. You should see an update alert after this one runs. If you get a message like “No upgrade for the given ID” it should mean that you already see some updates ready to run. Proceed to the next step)
    2. Run the update at Donations > Updates or by clicking the message at the top of the admin screens.
    3. Go to this URL:
    /wp-admin/edit.php?post_type=give_forms&page=give-tools&tab=logs&section=updates (this checks the logs to see if there were any errors. If you see errors, pass them along in a reply here.

    I do apologize for my slow turnaround on this one.

    Have a great day! ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘‘wp_give_revenue’ doesn’t exist’ is closed to new replies.

Tags