[wp-trac] [WordPress Trac] #22134: Update Network causes "WordPress database error Table 'wp_signups' already exists for query"

WordPress Trac noreply at wordpress.org
Wed Dec 12 18:52:46 UTC 2012 

#22134: Update Network causes "WordPress database error Table 'wp_signups' already
exists for query"
---------------------------+------------------------------
 Reporter:  tomdxw         |       Owner:
     Type:  defect (bug)   |      Status:  new
 Priority:  normal         |   Milestone:  Awaiting Review
Component:  Network Admin  |     Version:
 Severity:  normal         |  Resolution:
 Keywords:  has-patch      |
---------------------------+------------------------------

Comment (by charlie_hun):

 Replying to [comment:1 nacin]:
 > Can you describe the rest of the error? For what query is it failing,
 what's the backtrace and when exactly does it occur?
 >
 > These statements do not use IF NOT EXISTS because they go through
 dbDelta(), which handles various DB upgrades (new indexes, new or changed
 fields, new tables). These are not SQL statements that are directly and
 unconditionally run.

 I can confirm this error.

 {{{
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table 'wp_users'
 already exists a lekérdezésben CREATE TABLE wp_users (
   ID bigint(20) unsigned NOT NULL auto_increment,
   user_login varchar(60) NOT NULL default '',
   user_pass varchar(64) NOT NULL default '',
   user_nicename varchar(50) NOT NULL default '',
   user_email varchar(100) NOT NULL default '',
   user_url varchar(100) NOT NULL default '',
   user_registered datetime NOT NULL default '0000-00-00 00:00:00',
   user_activation_key varchar(60) NOT NULL default '',
   user_status int(11) NOT NULL default '0',
   display_name varchar(250) NOT NULL default '',
   spam tinyint(2) NOT NULL default '0',
   deleted tinyint(2) NOT NULL default '0',
   PRIMARY KEY  (ID),
   KEY user_login_key (user_login),
   KEY user_nicename (user_nicename)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table
 'wp_usermeta' already exists a lekérdezésben
 CREATE TABLE wp_usermeta (
   umeta_id bigint(20) unsigned NOT NULL auto_increment,
   user_id bigint(20) unsigned NOT NULL default '0',
   meta_key varchar(255) default NULL,
   meta_value longtext,
   PRIMARY KEY  (umeta_id),
   KEY user_id (user_id),
   KEY meta_key (meta_key)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table 'wp_blogs'
 already exists a lekérdezésben
 CREATE TABLE wp_blogs (
   blog_id bigint(20) NOT NULL auto_increment,
   site_id bigint(20) NOT NULL default '0',
   domain varchar(200) NOT NULL default '',
   path varchar(100) NOT NULL default '',
   registered datetime NOT NULL default '0000-00-00 00:00:00',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   public tinyint(2) NOT NULL default '1',
   archived enum('0','1') NOT NULL default '0',
   mature tinyint(2) NOT NULL default '0',
   spam tinyint(2) NOT NULL default '0',
   deleted tinyint(2) NOT NULL default '0',
   lang_id int(11) NOT NULL default '0',
   PRIMARY KEY  (blog_id),
   KEY domain (domain(50),path(5)),
   KEY lang_id (lang_id)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table
 'wp_blog_versions' already exists a lekérdezésben
 CREATE TABLE wp_blog_versions (
   blog_id bigint(20) NOT NULL default '0',
   db_version varchar(20) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (blog_id),
   KEY db_version (db_version)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table
 'wp_registration_log' already exists a lekérdezésben
 CREATE TABLE wp_registration_log (
   ID bigint(20) NOT NULL auto_increment,
   email varchar(255) NOT NULL default '',
   IP varchar(30) NOT NULL default '',
   blog_id bigint(20) NOT NULL default '0',
   date_registered datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (ID),
   KEY IP (IP)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table 'wp_site'
 already exists a lekérdezésben
 CREATE TABLE wp_site (
   id bigint(20) NOT NULL auto_increment,
   domain varchar(200) NOT NULL default '',
   path varchar(100) NOT NULL default '',
   PRIMARY KEY  (id),
   KEY domain (domain,path)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table
 'wp_sitemeta' already exists a lekérdezésben
 CREATE TABLE wp_sitemeta (
   meta_id bigint(20) NOT NULL auto_increment,
   site_id bigint(20) NOT NULL default '0',
   meta_key varchar(255) default NULL,
   meta_value longtext,
   PRIMARY KEY  (meta_id),
   KEY meta_key (meta_key),
   KEY site_id (site_id)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:02 blogolj ool www: WordPress adatbázis hiba Table
 'wp_signups' already exists a lekérdezésben
 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)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table 'wp_users'
 already exists a lekérdezésben CREATE TABLE wp_users (
   ID bigint(20) unsigned NOT NULL auto_increment,
   user_login varchar(60) NOT NULL default '',
   user_pass varchar(64) NOT NULL default '',
   user_nicename varchar(50) NOT NULL default '',
   user_email varchar(100) NOT NULL default '',
   user_url varchar(100) NOT NULL default '',
   user_registered datetime NOT NULL default '0000-00-00 00:00:00',
   user_activation_key varchar(60) NOT NULL default '',
   user_status int(11) NOT NULL default '0',
   display_name varchar(250) NOT NULL default '',
   spam tinyint(2) NOT NULL default '0',
   deleted tinyint(2) NOT NULL default '0',
   PRIMARY KEY  (ID),
   KEY user_login_key (user_login),
   KEY user_nicename (user_nicename)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table
 'wp_usermeta' already exists a lekérdezésben
 CREATE TABLE wp_usermeta (
   umeta_id bigint(20) unsigned NOT NULL auto_increment,
   user_id bigint(20) unsigned NOT NULL default '0',
   meta_key varchar(255) default NULL,
   meta_value longtext,
   PRIMARY KEY  (umeta_id),
   KEY user_id (user_id),
   KEY meta_key (meta_key)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table 'wp_blogs'
 already exists a lekérdezésben
 CREATE TABLE wp_blogs (
   blog_id bigint(20) NOT NULL auto_increment,
   site_id bigint(20) NOT NULL default '0',
   domain varchar(200) NOT NULL default '',
   path varchar(100) NOT NULL default '',
   registered datetime NOT NULL default '0000-00-00 00:00:00',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   public tinyint(2) NOT NULL default '1',
   archived enum('0','1') NOT NULL default '0',
   mature tinyint(2) NOT NULL default '0',
   spam tinyint(2) NOT NULL default '0',
   deleted tinyint(2) NOT NULL default '0',
   lang_id int(11) NOT NULL default '0',
   PRIMARY KEY  (blog_id),
   KEY domain (domain(50),path(5)),
   KEY lang_id (lang_id)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table
 'wp_blog_versions' already exists a lekérdezésben
 CREATE TABLE wp_blog_versions (
   blog_id bigint(20) NOT NULL default '0',
   db_version varchar(20) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (blog_id),
   KEY db_version (db_version)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table
 'wp_registration_log' already exists a lekérdezésben
 CREATE TABLE wp_registration_log (
   ID bigint(20) NOT NULL auto_increment,
   email varchar(255) NOT NULL default '',
   IP varchar(30) NOT NULL default '',
   blog_id bigint(20) NOT NULL default '0',
   date_registered datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (ID),
   KEY IP (IP)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table 'wp_site'
 already exists a lekérdezésben
 CREATE TABLE wp_site (
   id bigint(20) NOT NULL auto_increment,
   domain varchar(200) NOT NULL default '',
   path varchar(100) NOT NULL default '',
   PRIMARY KEY  (id),
   KEY domain (domain,path)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table
 'wp_sitemeta' already exists a lekérdezésben
 CREATE TABLE wp_sitemeta (
   meta_id bigint(20) NOT NULL auto_increment,
   site_id bigint(20) NOT NULL default '0',
   meta_key varchar(255) default NULL,
   meta_value longtext,
   PRIMARY KEY  (meta_id),
   KEY meta_key (meta_key),
   KEY site_id (site_id)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta
 Dec 12 18:52:04 blogolj ool www: WordPress adatbázis hiba Table
 'wp_signups' already exists a lekérdezésben
 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)
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci készítette
 wp_upgrade, make_db_current_silent, dbDelta

 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/22134#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software

More information about the wp-trac mailing list