Update Caused Errors To Database

  • Resolved Tony Bianco

    (@tbianco)


    9 years, 9 months ago

    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)

  • After upgrading from 3.8 to 3.9

    So this was a Manual Update?

    Thread Starter Tony Bianco

    (@tbianco)

    I’m closing this. I didn’t see the button where I needed to upgrade the database.

    Thread Starter Tony Bianco

    (@tbianco)

    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.

    https://docs.wpecommerce.org/3-8-11-user-logs/

    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.

    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

    (@tbianco)

    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.