Title: DB tables missing after update ( 3.0.2 to 3.0.3 )
Last modified: April 15, 2017

---

# DB tables missing after update ( 3.0.2 to 3.0.3 )

 *  [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/)
 * Following table missing from multiple installations after updating WooCommerce
   from 3.0.2 to 3.0.3.
 *     ```
       wp_woocommerce_tax_rates
       wp_woocommerce_sessions
       ```
   
    -  This topic was modified 9 years, 1 month ago by [marsian](https://wordpress.org/support/users/marsian/).

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

 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033374)
 * [@partnereddecision](https://wordpress.org/support/users/partnereddecision/) 
   stop spamming over users threads with unhelpful comments.
 * [@marsian](https://wordpress.org/support/users/marsian/) tables cannot drop themselves–
   the only time these would be dropped if is you click the ‘delete plugin’ link
   on the Plugins page (since this removes/uninstalls data). I’d suggest looking
   at the DB itself to see if those tables are still there, or the system status
   report.
 * If you did use ‘delete plugin’, perhaps to install a new version you will need
   to de-activate and re-activate WooCommerce to re-run the table installer.
 * As for linking this to the point release, you can confirm here that no such ‘
   drop table’ code has been added, so I don’t think it’s related to that update
   specifically. [https://github.com/woocommerce/woocommerce/compare/3.0.2…3.0.3](https://github.com/woocommerce/woocommerce/compare/3.0.2…3.0.3)
 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033395)
 * [@partnereddecision](https://wordpress.org/support/users/partnereddecision/) 
   I get that you are frustrated right now but this is not helping you nor anyone
   else. The problems you are facing are not affecting everyone. And yes, this forum
   does indeed have threads from users having 3.0 issues, but thats because it’s
   a support forum – not an ‘everything is ok let me post about it’ forum.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033411)
 * Nope, i did auto update, let me put the exact error, the tables are actually 
   there
 * i could not fix it even after,
    1. I deactivated WooCommerce, 2. Replaced the
   plugin folder with 3.0.2, 3. Update the plugin and reactivate, still the issue
   exist.
 * the issues are in multiple installation, i have MySQL 5.5.27
 *     ```
       WordPress database error: [Incorrect information in file: '.\ispirit@002dm\wp_woocommerce_sessions.frm']
       SELECT session_value FROM wp_woocommerce_sessions WHERE session_key = '1'
       ```
   
 * and
 *     ```
       WordPress database error:
       [Incorrect information in file: '.\ispirit@002dm\wp_woocommerce_tax_rates.frm']
       SELECT tax_rates.* ...
       ```
   
 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033437)
 * [@partnereddecision](https://wordpress.org/support/users/partnereddecision/) 
   I replied to your thread but it’s pending as I included a bunch of links. Now
   please, stop hijacking other users threads.
 * [@marsian](https://wordpress.org/support/users/marsian/) thanks for clarifying.
   That one won’t be related to the update, although the cause is not clear. Go 
   into your hosting and “repair” the tables via PhpMyAdmin. Alternatively, you 
   could use something like [https://en-gb.wordpress.org/plugins/wp-dbmanager/](https://en-gb.wordpress.org/plugins/wp-dbmanager/)
   but PhpMyAdmin may be quicker.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033444)
 * thank you very much! let me try, hope that is not an issue with the update, i
   will try update few more installation.
 * i am a theme author and asked my users not to upgrade to 3.0.3
 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033463)
 * [@marsian](https://wordpress.org/support/users/marsian/) Did the repair solve
   it on this particular site?
 * [@partnereddecision](https://wordpress.org/support/users/partnereddecision/) 
   I’d rather not be shouted at so I’ll pass on that Skype invitation thanks 🙂
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033535)
 * I will update the thread once i work on them. I have some other task to finish
   before that.
 * 3 updates in a week and all of them with template updates caused me to attend
   lots of support request along with release of new versions of the themes with
   WooCommerce templates. ,🙂
 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033550)
 * Yeah there were some version bumps missing in changed template files. Just remember
   you only need to override templates you actually need to change. Filters and 
   actions are preferable.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/#post-9033670)
 * Hardly i use 10 percent of the template and reducing them as much as possible.
   Where-ever possible using filters and hooks.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/page/2/#post-9033861)
 * Not working, phpMyAdmin produces error,
    while the plugin shows repaired but 
   the error messages remain
 * ![Database error](https://i0.wp.com/templatesnext.in/download/db-repair-error.
   png)
 *  Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/)
 * (@mikejolley)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/page/2/#post-9033920)
 * I’d ask the host for advice if the repair function is not working on that table.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/page/2/#post-9034565)
 * as i said earlier, it is my localhost, apache on xampp. i will have to find a
   solution for myself.
 *  Thread Starter [marsian](https://wordpress.org/support/users/marsian/)
 * (@marsian)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/page/2/#post-9034689)
 * Had to create duplicate DB and restore the corrupt tables from backup

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

The topic ‘DB tables missing after update ( 3.0.2 to 3.0.3 )’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [missing](https://wordpress.org/support/topic-tag/missing/)
 * [table](https://wordpress.org/support/topic-tag/table/)
 * [update](https://wordpress.org/support/topic-tag/update/)

 * 19 replies
 * 2 participants
 * Last reply from: [marsian](https://wordpress.org/support/users/marsian/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/db-table-missing-after-update/page/2/#post-9034689)
 * Status: not resolved