Title: Two database update errors in plugin
Last modified: March 17, 2025

---

# Two database update errors in plugin

 *  Resolved [markvtswp](https://wordpress.org/support/users/markvtswp/)
 * (@markvtswp)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/)
 * Hi – I’ve been through all the updates and they’ve all worked okay except
 * 
   Add phone column to donors table
 * 
   Add payment mode column to subscription table
 * Is there an SQL query that I can run to do these manually?
 * Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Support [Robin Joshua Del Mundo](https://wordpress.org/support/users/robindelmundo/)
 * (@robindelmundo)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18366351)
 * Hi [@markvtswp](https://wordpress.org/support/users/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:
 *     ```wp-block-code
       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/](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!
 *  Thread Starter [markvtswp](https://wordpress.org/support/users/markvtswp/)
 * (@markvtswp)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18367275)
 * 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
 *  Plugin Support [Robin Joshua Del Mundo](https://wordpress.org/support/users/robindelmundo/)
 * (@robindelmundo)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18368870)
 * Hi [@markvtswp](https://wordpress.org/support/users/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/](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](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!
 *  Plugin Support [Robin Joshua Del Mundo](https://wordpress.org/support/users/robindelmundo/)
 * (@robindelmundo)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18373550)
 * Hi [@markvtswp](https://wordpress.org/support/users/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!
 *  Thread Starter [markvtswp](https://wordpress.org/support/users/markvtswp/)
 * (@markvtswp)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18373583)
 * 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 »](http://docs.givewp.com/troubleshooting-db-updates)
   The update date on the tool doesn’t update for those two.
 * Thanks so much for your help

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Two database update errors in plugin’ is closed to new replies.

 * ![](https://ps.w.org/give/assets/icon-256x256.jpg?rev=2873287)
 * [GiveWP - Donation Plugin and Fundraising Platform](https://wordpress.org/plugins/give/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/give/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/give/)
 * [Active Topics](https://wordpress.org/support/plugin/give/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/give/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/give/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [markvtswp](https://wordpress.org/support/users/markvtswp/)
 * Last activity: [1 year, 2 months ago](https://wordpress.org/support/topic/two-database-update-errors-in-plugin/#post-18373583)
 * Status: resolved