Hi, @roia.
I’m glad you reached out. I can certainly help you.
There is a failure regarding a field missing in your database. What likely happened here is that you did not run the database upgrades even though you had the latest version of the GiveWP plugins on your site. For example, if you navigate to donations > tools > data > database updates, you will find a migration called Add phone column to donors table, and that’s likely the migration that did not occur or failed.
You can fix it by navigating to donations > settings > advanced > advanced options and there you enable the Advanced Database Updates. Then, navigate to donations > tools > data > database updates, look for Add phone column to donors table and re-run this update.
Before taking any steps for troubleshooting or updating, I highly recommend taking a good backup of the site you can confidently restore from. Having a backup of your site is essential to a solid workflow, and will allow you to restore to a previous version of the site if you run into any issues. You can read more about our top recommendations for taking a backup here: https://givewp.com/backup-for-faster-troubleshooting/
Feel free to reach out to us if you have any further inquiries or require additional assistance. We’re always happy to help!
Thread Starter
roia
(@roia)
Thank you very much Matheus Martins
I re-run most of the updates and the following 3 updates have refused running
Create_subscription_tables – the status is Failed
Add payment mode column to subscription table – status Pending
Add phone column to donors table – status Pending
The error I receive from the last one is as follows:
Database update failed!
Check migration details for more information
And according to the logs the errror is as follows:
Donation Route Error: unknown_error
{ “error_type”: “unknown_error”, “exceptionMessage”: “Database Query”, “formData”: { “gatewayId”: “offline”, “requestData”: { “givewp-route”: “donate”, “givewp-route-signature”: “ae76f185db8b9c66f904400a123bb1d1”, “givewp-route-signature-id”: “givewp-donate”, “givewp-route-signature-expiration”: “1720644086”, “amount”: “10”, “currency”: “USD”, “donationType”: “single”, “formId”: “10235”, “firstName”: “Dolly”, “lastName”: “K”, “email”: “**********”, “gatewayId”: “offline”, “phone”: “”, “originUrl”: “https://healthyplacesbydesign.org/donations/givewp-donation-form/”, “isEmbed”: “true”, “embedId”: “10235” }, “formId”: 10235, “originUrl”: “https://healthyplacesbydesign.org/donations/givewp-donation-form/”, “embedId”: “10235”, “isEmbed”: true } }
