slynn

I had this same problem with MySQL 5.0.13-rc-Max. After some investigation, I found that it is not a ‘bad’ thing. It did not insert those records into the table. It is one of the many strange things that I have found using MySQL5…

The work around, is to just insert those records by hand and add the column that it says does not have a default value and force the field to ”. Here are all the queries.

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://blogs.linux.ie/xeer/’, ‘Donncha’, 1, ‘https://blogs.linux.ie/xeer/feed/’, ”);

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://zengun.org/weblog/’, ‘Michel’, 1, ‘https://zengun.org/weblog/feed/’, ”);

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://boren.nu/’, ‘Ryan’, 1, ‘https://boren.nu/feed/’, ”);

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://photomatt.net/’, ‘Matt’, 1, ‘https://xml.photomatt.net/feed/’, ”);

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://zed1.com/journalized/’, ‘Mike’, 1, ‘https://zed1.com/journalized/feed/’, ”);

INSERT INTO wp_links (link_url, link_name, link_category, link_rss, link_notes) VALUES (‘https://www.alexking.org/’, ‘Alex’, 1, ‘https://www.alexking.org/blog/wp-rss2.php’, ”);

INSERT INTO wp_categories (cat_ID, cat_name, category_nicename, category_description) VALUES (‘0’, ‘Uncategorized’, ‘uncategorized’, ”)

INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_name, post_modified, post_modified_gmt, post_excerpt) VALUES (‘1’, ‘2005-10-03 21:32:49’, ‘2005-10-03 19:32:49’, ‘Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!’, ‘Hello world!’, ‘0’, ‘hello-world’, ‘2005-10-03 21:32:49’, ‘2005-10-03 19:32:49’, ”)