[wp-trac] [WordPress Trac] #27855: Database errors when promoting WP 3.9 to multisite

[WordPress Trac]

#27855: Database errors when promoting WP 3.9 to multisite
--------------------------+-----------------------------
 Reporter:  l3rady        |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  3.9
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Developed a single site install in version 3.8 and kept it updated through
 to 3.8.3

 Then I needed to promote the site to multisite but before doing so I first
 upgraded the website to 3.9.

 Upon promoting the site to multisite I got this error:


 {{{
 WordPress database error: [Incorrect table definition; there can be only
 one auto column and it must be defined as a key]
 ALTER TABLE wp_signups ADD COLUMN signup_id bigint(20) NOT NULL
 auto_increment

 WordPress database error: [Key column 'signup_id' doesn't exist in table]
 ALTER TABLE wp_signups ADD PRIMARY KEY (signup_id)
 }}}


 After the table upgrade it has left the signup table in the following
 state:


 {{{
 CREATE TABLE `wp_signups` (
   `domain` varchar(200) NOT NULL default '',
   `path` varchar(100) NOT NULL default '',
   `title` longtext NOT NULL,
   `user_login` varchar(60) NOT NULL default '',
   `user_email` varchar(100) NOT NULL default '',
   `registered` datetime NOT NULL default '0000-00-00 00:00:00',
   `activated` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '0',
   `activation_key` varchar(50) NOT NULL default '',
   `meta` longtext,
   KEY `activation_key` (`activation_key`),
   KEY `domain` (`domain`),
   KEY `user_email` (`user_email`),
   KEY `user_login_email` (`user_login`,`user_email`),
   KEY `domain_path` (`domain`,`path`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 }}}

 I'm not using the signup functionality so this broken table won't affect
 me but certainly needs investigating into why this has happened.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/27855>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform