"Table doesn't exist error" on database repair

  • Resolved lintunen

    (@lintunen)


    14 years, 9 months ago

    In attempting to upgrade WordPress, I am prompted to repair the database. I am getting a series of errors as given in the sample below:

    The bb_1_posts table is not okay. It is reporting the following error: Table 'db.wp_1_posts' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_1_posts table. Error: Table 'db.wp_1_posts' doesn't exist

    Understandably, this isn’t working because the table doesn’t exist but I don’t understand why it is looking for tables marked with _1.

Viewing 5 replies - 1 through 5 (of 5 total)
  • TCBarrett

    (@tcbarrett)

    14 years, 9 months ago

    It is network (multi-site) related. For example, if your prefix is ‘wp_’ and you switch on network (multi-site) then each site gets an additional sequential number added to the prefix, so site 2 would be ‘wp_2_’.

    However, when ‘MU’ (multi-site) was incorporated into WP3, the first, original, site was no longer renamed ‘wp_1_’.

    So instead of having wp_1_, wp_2_, wp_3 (pre WP3) you now have wp_, wp_2_, wp_3_ (WP3 onwards).

    Perhaps there is an issue with one of your plugins regarding this.

    Thread Starter lintunen

    (@lintunen)

    14 years, 9 months ago

    I had a feeling it was something to do with multisite – although I never ran multisite I may have enabled it once to see how it worked. But this doesn’t really answer my question on how to fix this problem and proceed with the database repair. Any suggestions?

    Thread Starter lintunen

    (@lintunen)

    14 years, 9 months ago

    I was able to resolve this particular issue by following the steps in this post: http://ww.wp.xz.cn/support/topic/remove-multiple-sitesturn-off-network

    deanpence

    (@deanpence)

    14 years, 8 months ago

    I encountered this as well. It was because I was missing “define(‘MULTISITE’, true);” in wp-config.php.

    Kresimir Pendic

    (@gorostas)

    14 years, 2 months ago

    Hey deanpence, thans for help.. after adding that line it all works!

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

The topic ‘"Table doesn't exist error" on database repair’ is closed to new replies.