Hi @markvtswp ,
Glad you reached out! Happy to help.
You’re on the right track! This means that the “phone” field was not added to the database, and that will prevent GiveWP from creating the donor and donation records.
You can use this SQL command to manually create the missing column:
ALTER TABLE 83OZ6Fw8pS_give_donors ADD COLUMN phone varchar(50) NOT NULL DEFAULT '' AFTER name
Moreover, here are my recommendations:
- 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/.
- Run the SQL query in your database on a staging site and test thoroughly while logged out
Let me know once you’ve implemented and tested the above. I’m here for any further questions or additional assistance.
Have a good day!
Hi – thanks so much for your reply. I tried the query but it turns out the phone column and the payment_mode column in the subscriptions table are already present so I’m not sure why it’s still showing a database error and failure for those two upgrade steps?
Any ideas? thanks
Hi @markvtswp ,
There might be some more database updates aside from those two.
Can you try the following steps on your website:
- 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/.
- Enable Advanced Database Updates in Donations → Settings → Advanced.
- Next, you can run the update in Donations → Tools → Data, and based on the Run Order columns, re-run the upgrades (start from number one and go until the end).
- Check the logs at Donations → Tools → Logs for errors. If there are any errors, pass those along here.
- Last, navigate back to Donations → Settings → Advanced and disable Advanced Database Updates.
Thereafter, try to see if all the updates will be successful.
You can also read this (and much more information!) in our documentation in here — https://givewp.com/documentation/core/frequent-troubleshooting-issues/handling-database-update-issues/#database-updates-migrations.
Please let me know once you implemented and tested the above.
Meanwhile, I’m here for further questions or additional assistance.
Have a lovely day!
Hi @markvtswp ,
It’s been a while since we’ve heard back, and I know troubleshooting needs a little extra time. I’m marking this as resolved for now, but if you still have questions, you can send them along right here, and I’ll be happy to hop back in.
Have a great day!
Hi, sorry for slow reply – been through them all again and it’s still fails on the two mentioned above and says at the top Database Update – An unexpected issue occurred during the database update which caused it to stop automatically. Please contact support for assistance. Read More » The update date on the tool doesn’t update for those two.
Thanks so much for your help
