[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.7
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by leiascofield):

 This has happened on one of our sites also. We are not running multisite,
 but are running Buddypress.

 This affected both 3.8.3 and 3.9.

 From the error log:

 [Thu Apr 17 17:23:40 2014] [warn] [client XX.XX.XX.XX] mod_fcgid: stderr:
 WordPress database error Incorrect table definition; there can be only one
 auto column and it must be defined as a key for query ALTER TABLE
 wp_signups ADD COLUMN signup_id bigint(20) NOT NULL auto_increment made by
 do_action('admin_init'), call_user_func_array, bp_admin_init,
 do_action('bp_admin_init'), call_user_func_array,
 bp_core_admin_components_settings_handler, bp_core_install,
 bp_core_install_signups, dbDelta, referer: http://URL/wp-
 admin/admin.php?page=bp-components&updated=true
 [Thu Apr 17 17:23:40 2014] [warn] [client XX.XX.XX.XX] mod_fcgid: stderr:
 WordPress database error Key column 'signup_id' doesn't exist in table for
 query ALTER TABLE wp_signups ADD PRIMARY KEY  (signup_id) made by
 do_action('admin_init'), call_user_func_array, bp_admin_init,
 do_action('bp_admin_init'), call_user_func_array,
 bp_core_admin_components_settings_handler, bp_core_install,
 bp_core_install_signups, dbDelta, referer: http://URL/wp-
 admin/admin.php?page=bp-components&updated=true

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