• 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.
Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    @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

    Plugin Contributor Mike Jolley

    (@mikejolley)

    @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

    (@marsian)

    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

    (@mikejolley)

    @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.

    Thread Starter marsian

    (@marsian)

    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

    (@mikejolley)

    @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 🙂

    Thread Starter marsian

    (@marsian)

    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

    (@mikejolley)

    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

    (@marsian)

    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

    (@marsian)

    Not working, phpMyAdmin produces error,
    while the plugin shows repaired but the error messages remain

    Database error

    Plugin Contributor Mike Jolley

    (@mikejolley)

    I’d ask the host for advice if the repair function is not working on that table.

    Thread Starter marsian

    (@marsian)

    as i said earlier, it is my localhost, apache on xampp. i will have to find a solution for myself.

    Thread Starter marsian

    (@marsian)

    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.