Additional info regarding error:
Error Details
=============
An error of type E_ERROR was caused in line 32 of the file …/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php. Error message: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in …/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:32
-
This reply was modified 5 years, 5 months ago by
dheatherly.
Hey @dheatherly,
Glad you reached out!
The latest releases of GiveWP included a new database table, so we could perform more advanced actions on the website and create new features too. However, some hosting companies prevented this database table from being created. And it’s possibly what is happening on your site. But to fix it, you need to 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§ion=updates (this checks the logs to see if there were any errors. If you see errors, pass them along in a reply here).
Please let us know if you have further questions on this or need any additional assistance!
Thank you! That’s resolved the issue. Have a great holiday.
Hey @dheatherly,
Happy to hear that! I wish you happy fundraising 🎉
If we were helpful and you are happy with our support and service, I’d like to ask you if you can write a review about us.
We’d love to get a public review about what you think of GiveWP both from a product standpoint as well as how it is to deal with our team. Here are some options:
WordPress: https://ww.wp.xz.cn/support/view/plugin-reviews/give
Google: https://g.page/givewp/review?rc
Facebook: https://www.facebook.com/pg/wpgive/reviews/
The reviews help others to decide if it’s worth doing business with us!
Have a great day!