DB tables missing after update ( 3.0.2 to 3.0.3 )
-
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.
-
This topic was modified 9 years, 1 month ago by
-
@partnereddecision stop spamming over users threads with unhelpful comments.
@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
@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.
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.* ...@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 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.ww.wp.xz.cn/plugins/wp-dbmanager/ but PhpMyAdmin may be quicker.
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
@marsian Did the repair solve it on this particular site?
@partnereddecision I’d rather not be shouted at so I’ll pass on that Skype invitation thanks 🙂
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. ,🙂
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.
Hardly i use 10 percent of the template and reducing them as much as possible. Where-ever possible using filters and hooks.
Not working, phpMyAdmin produces error,
while the plugin shows repaired but the error messages remain
I’d ask the host for advice if the repair function is not working on that table.
as i said earlier, it is my localhost, apache on xampp. i will have to find a solution for myself.
Had to create duplicate DB and restore the corrupt tables from backup
The topic ‘DB tables missing after update ( 3.0.2 to 3.0.3 )’ is closed to new replies.