Two database update errors in plugin

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:

1. 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/.
2. 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:

1. 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/.
2. Enable Advanced Database Updates in Donations → Settings → Advanced.
3. 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).
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.

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!