[wp-trac] [WordPress Trac] #25298: SQL error preventing wp_signups table from being created on network install

[WordPress Trac]

#25298: SQL error preventing wp_signups table from being created on network install
--------------------------+-----------------------------
 Reporter:  gradyetc      |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  3.6.1
 Severity:  critical      |   Keywords:
--------------------------+-----------------------------
 Recent schema changes to the $ms_global_tables variable within /wp-
 admin/includes/schema.php are causing database errors when installing a
 network.  The CREATE TABLE block for $wpdb->singups contains invalid SQL.

 The resulting error:

 {{{
 WordPress database error You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near 'KEY user_login_email (user_login,user_email),\n  KEY
 domain_path (domain,path),\n)' at line 16 for query \nCREATE TABLE
 wp_signups (\n  signup_id bigint(20) NOT NULL auto_increment,\n  domain
 varchar(200) NOT NULL default '',\n  path varchar(100) NOT NULL default
 '',\n  title longtext NOT NULL,\n  user_login varchar(60) NOT NULL default
 '',\n  user_email varchar(100) NOT NULL default '',\n  registered datetime
 NOT NULL default '0000-00-00 00:00:00',\n  activated datetime NOT NULL
 default '0000-00-00 00:00:00',\n  active tinyint(1) NOT NULL default
 '0',\n  activation_key varchar(50) NOT NULL default '',\n  meta
 longtext,\n  PRIMARY KEY  (signup_id),\n  KEY activation_key
 (activation_key),\n  KEY user_email (user_email)\n  KEY user_login_email
 (user_login,user_email),\n  KEY domain_path (domain,path),\n) DEFAULT
 CHARACTER SET utf8 made by install_network, dbDelta
 }}}

 This error was introduced in [25179].  I've attached a patch against
 25338.

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