Kim experiencing the same issue and it has also affected the pay pal gateway. Donor name and other info is properly listed but when you view the donation it shows as pending for Stripe or PayPal. Then changes to abandoned after a period of time.
Hi @doktadivah.
Yes, missing the revenue table might prevent the donation from being completed.
For a bit of context, the latest GiveWP update 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.
The first thing you need to check right now is your MySQL version (or MariaDB version, depending on the server you are using). You need to contact your host ask and them to update your MySQL version to 5.7 or later, otherwise, GiveWP will not be able to create the needed database tables.
After that, 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.
5. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.
Please let us know if you have further questions on this or need any additional assistance!
Hi @doktadivah
If the give_revenue table is missing, the fix is simple:
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. Enable Advanced Database Updates in Donations -> Settings -> Advanced:
3. Next, run the update in Donations -> Tools -> Data, find create_revenue_table and click the Re-run Update button.
4. Last, go back to in Donations -> Settings -> Advanced and disable Advanced Database Updates.
Let me know if the problem persists.
Thanks!
Ok, I’ll work on this and report back! Thanks!
