[wpmu-trac] Re: [WordPress MU Trac] #945: db error on blog creation

[WordPress MU Trac]

#945: db error on blog creation
-------------------------+--------------------------------------------------
 Reporter:  frumph       |        Owner:  somebody
     Type:  defect       |       Status:  new     
 Priority:  normal       |    Milestone:  2.7.1   
Component:  General      |      Version:  2.7.1   
 Severity:  normal       |   Resolution:          
 Keywords:  blog signup  |  
-------------------------+--------------------------------------------------
Comment (by frumph):

 {{{
 CREATE TABLE IF NOT EXISTS $wpdb->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),
   UNIQUE `site_id_meta_key` (site_id, meta_key)
 ) $charset_collate;
 }}}

 I've never touched any of this, this is straight core.

 {{{
 Create Statement from MYSQL:
 DROP TABLE IF EXISTS `webcomicplanet`.`wp_sitemeta`;
 CREATE TABLE  `webcomicplanet`.`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`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1400 DEFAULT CHARSET=utf8;
 }}}

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/945#comment:2>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser