Title: Update Caused Errors To Database Last modified: August 30, 2016 --- # Update Caused Errors To Database * Resolved [Tony Bianco](https://wordpress.org/support/users/tbianco/) * (@tbianco) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/) * After upgrading from 3.8 to 3.9 I saw a message telling me to repair my database tables. I did that but there were tables that were unable to be repaired or were missing. Here’s the report: * wp_users: 3 clients are using or haven’t closed the table properly wp_usermeta: 3 clients are using or haven’t closed the table properly wp_posts: 2 clients are using or haven’t closed the table properly wp_options: 5 clients are using or haven’t closed the table properly wp_wpsc_cart_item_meta: Table ‘mydatabase. wp_wpsc_cart_item_meta’ doesn’t exist wp_wpsc_purchase_meta: Table ‘mydatabase. wp_wpsc_purchase_meta’ doesn’t exist wp_wpsc_visitors: Table ‘mydatabase.wp_wpsc_visitors’ doesn’t exist wp_wpsc_visitor_meta: Table ‘mydatabase.wp_wpsc_visitor_meta’ doesn’t exist * What is the fix here? Viewing 6 replies - 1 through 6 (of 6 total) * [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/) * (@swansonphotos) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227206) * > After upgrading from 3.8 to 3.9 * So this was a Manual Update? * Thread Starter [Tony Bianco](https://wordpress.org/support/users/tbianco/) * (@tbianco) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227207) * I’m closing this. I didn’t see the button where I needed to upgrade the database. * Thread Starter [Tony Bianco](https://wordpress.org/support/users/tbianco/) * (@tbianco) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227208) * Hey thanks Pioneer… it was an autoupdate. I saw the message to repair the database. I did. Got the error. Then I saw that I needed to upgrade the database, did that and it works. However now I have an error with the one of the files and the theme. * [http://docs.wpecommerce.org/3-8-11-user-logs/](http://docs.wpecommerce.org/3-8-11-user-logs/) * [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/) * (@swansonphotos) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227286) * The current version of WordPress is 4.2.2 so an auto-update would update to 4.2.2. * Is the link you posted the site with the issue(s)? If not please post it. * [nicola.inmateria](https://wordpress.org/support/users/nicolainmateria/) * (@nicolainmateria) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227381) * Hi, same problem for me upgrading to WP 4.2.2 and WP eCommerce 3.9.4 * wp_wpsc_cart_item_meta: Table ‘[DB].wp_wpsc_cart_item_meta’ doesn’t exist wp_wpsc_purchase_meta: Table ‘[DB].wp_wpsc_purchase_meta’ doesn’t exist wp_wpsc_visitors: Table ‘[DB]. wp_wpsc_visitors’ doesn’t exist wp_wpsc_visitor_meta: Table ‘[DB].wp_wpsc_visitor_meta’ doesn’t exist * Thread Starter [Tony Bianco](https://wordpress.org/support/users/tbianco/) * (@tbianco) * [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227389) * Hey nicola.inmateria, all you have to do is click on the upgrade database button. Once you do that then it will fix the problem. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Update Caused Errors To Database’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 6 replies * 3 participants * Last reply from: [Tony Bianco](https://wordpress.org/support/users/tbianco/) * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/update-caused-errors-to-database/#post-6227389) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics