Database repair failed following upgrade to 3.9.4

  • Hi …

    I just upgraded to version WP eCommerce v3.9.4 and a message said it needed to repair the Dtb. I see this advice in the upgrade notes for 3.9.4 so ran the repair process.

    It reported all the tables were Ok except for ..
    ” The wpsc_visitors table is not okay. It is reporting the following error: Found row where the auto_increment column has the value 0. WordPress will attempt to repair this table…
    Failed to repair the wpsc_visitors table. Error: Found row where the auto_increment column has the value 0″

    * The wpsc_visitor_meta table is okay.

    I refreshed the page but to no avail. Can anyone suggest a solution please.
    Regards
    GFHS

    https://www.ads-software.com/plugins/wp-e-commerce/

Viewing 1 replies (of 1 total)
  • Thread Starter GFHS

    (@gfhs)

    Hi ..

    I’ve noticed in the wpsc_visitors table, there is a row with ..

      Id = 0
      user_id = 0
      last_active = 5/22/2015 8:29:44 PM
      expires = = 5/22/2015 10:29:44 PM
      created = = 5/22/2015 8:29:44 PM

    If I delete this row .. the “repair process” says everything is Ok. Is this all I need to do to get it up and running ?

    All help gratefully received.
    Regards
    GFHS

Viewing 1 replies (of 1 total)
  • The topic ‘Database repair failed following upgrade to 3.9.4’ is closed to new replies.