[wpmu-trac] [WordPress MU Trac] #389: Bug: Blog creation database errors

[WordPress MU Trac]

#389: Bug: Blog creation database errors
------------------------+---------------------------------------------------
 Reporter:  Vimm        |       Owner:  somebody
     Type:  defect      |      Status:  new     
 Priority:  normal      |   Milestone:  WPMU 2.0
Component:  component1  |     Version:  2.0     
 Severity:  normal      |    Keywords:          
------------------------+---------------------------------------------------
 I have noticed that after creating a new blog there is no content in the
 blog, just a "Not Found" message. After further investigation there are
 several database errors generated in install_blog_defaults() in wpmu-
 function.php. The problem is caused by the database schema having all
 fields set to NOT NULL, while the queries are missing several fields (and
 thus default to null). This causes the query to fail and the initial entry
 to not be created, among others. There are three such query errors in this
 function which are easily fixed by updating the queries as follows:

 Line numbers are referenced using the current version at:
 http://trac.mu.wordpress.org/browser/trunk/wp-includes/wpmu-functions.php

 Line 1335:
 DELETE. There is no "linkcategories" table.

 Line 1336 - 1337:
 From:
 $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,
 link_category, link_owner, link_rss) VALUES ('http://wordpress.com/',
 'WordPress.com', 1, '$user_id', 'http://wordpress.com/feed/');");
 $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,
 link_category, link_owner, link_rss) VALUES ('http://wordpress.org/',
 'WordPress.org', 1, '$user_id',
 'http://wordpress.org/development/feed/');");

 To:
 $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_image,
 link_target, link_category, link_description, link_visible, link_owner,
 link_rating, link_updated, link_rel, link_notes, link_rss) VALUES
 ('http://wordpress.com/', 'WordPress.com', '', '', 1, '', 'Y', '$user_id',
 0, 0, '', '', 'http://wordpress.com/feed/')");
 $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_image,
 link_target, link_category, link_description, link_visible, link_owner,
 link_rating, link_updated, link_rel, link_notes, link_rss) VALUES
 ('http://wordpress.org/', 'WordPress.org', '', '', 1, '', 'Y', '$user_id',
 0, 0, '', '', 'http://wordpress.org/development/feed/')");

 Line 1350:
 From:
 $wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date,
 post_date_gmt, post_content, post_title, post_category, post_name,
 post_modified, post_modified_gmt, comment_count) VALUES ('".$user_id."',
 '$now', '$now_gmt', '".addslashes($first_post)."', '".addslashes(__('Hello
 world!'))."', '0', '".addslashes(__('hello-world'))."', '$now',
 '$now_gmt', '1')");

 TO:
 $wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date,
 post_date_gmt, post_content, post_title, post_category, post_excerpt,
 post_status, comment_status, ping_status, post_password, post_name,
 to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered,
 post_parent, guid, menu_order, post_type, post_mime_type, comment_count)
 VALUES ('".$user_id."', '$now', '$now_gmt', '".addslashes($first_post)."',
 '".addslashes(__('Hello world!'))."', '0', '', 'publish', 'open', 'open',
 '', '".addslashes(__('hello-world'))."', to_ping, pinged, '$now',
 '$now_gmt', '', 0, '', 0, 'post', '', 1)");

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/389>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser