[wp-trac] [WordPress Trac] #15210: If your table prefix ends with a number, you can't use MultiSite

[WordPress Trac]

#15210: If your table prefix ends with a number, you can't use MultiSite
--------------------------+-------------------------------------------------
 Reporter:  ipstenu       |       Owner:                 
     Type:  defect (bug)  |      Status:  new            
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:                 
 Severity:  normal        |    Keywords:                 
--------------------------+-------------------------------------------------
 in the wp-config.php, if you set your prefix like this:

 {{{
 $table_prefix = 'wp_1';
 }}}

 as many people do for the old days of multiple installs in one DB, you
 can't use MultiSite, because it saves each sub-site as 'wp_1n' and then
 you get wp_12 for sub-site #2, which confuses the MultiSite and it can't
 find anything.

 Frankly, I can't think of a way around that easily, and it may be a known
 bug, but... maybe someone smart can go 'Ah hah!'

 The 'fix' is to rename your prefix so it DOES NOT end with a number, and
 then rename your tables.

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