[wp-trac] [WordPress Trac] #21036: DB Repair on Multisite looks for wp_1_....

[WordPress Trac]

#21036: DB Repair on Multisite looks for wp_1_....
--------------------------+-----------------------------
 Reporter:  Ipstenu       |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Multisite     |    Version:  3.0
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 Log in to your site and need to repair. WP nicely prompts you, so you
 click the repair button and get this:


 {{{
 wp_1_posts: Table 'wordpress.wp_1_posts' doesn't exist
 wp_1_comments: Table 'wordpress.wp_1_comments' doesn't exist
 wp_1_links: Table 'wordpress.wp_1_links' doesn't exist
 wp_1_options: Table 'wordpress.wp_1_options' doesn't exist
 wp_1_postmeta: Table 'wordpress.wp_1_postmeta' doesn't exist
 wp_1_terms: Table 'wordpress.wp_1_terms' doesn't exist
 wp_1_term_taxonomy: Table 'wordpress.wp_1_term_taxonomy' doesn't exist
 wp_1_term_relationships: Table 'wordpress.wp_1_term_relationships' doesn't
 exist
 wp_1_commentmeta: Table 'wordpress.wp_1_commentmeta' doesn't exist
 }}}


 I've seen this over and over again, and generally I tell people to go into
 phpMyAdmin and repair there, which works. But clearly looking for wp_1_ is
 going to be problematic for non-WPMU upgraded sites. Which are quickly
 becoming the majority.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21036>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software