WordPress.org

Forums

install errors, "no default value" (4 posts)

  1. RTAdams89
    Member
    Posted 9 years ago #

    First, here is what is dispalyed on the second step of the install page:

    -------------------------------------------------------
    Second Step
    Now we’re going to create the database tables and fill them with some default data.

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://blog.carthik.net/index.php', 'Carthik', 1, 'http://blog.carthik.net/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://blogs.linux.ie/xeer/', 'Donncha', 1, 'http://blogs.linux.ie/xeer/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://zengun.org/weblog/', 'Michel', 1, 'http://zengun.org/weblog/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://boren.nu/', 'Ryan', 1, 'http://boren.nu/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://photomatt.net/', 'Matt', 1, 'http://xml.photomatt.net/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://zed1.com/journalized/', 'Mike', 1, 'http://zed1.com/journalized/feed/');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://www.alexking.org/', 'Alex', 1, 'http://www.alexking.org/blog/wp-rss2.php');

    WordPress database error: [Field 'link_notes' doesn't have a default value]
    INSERT INTO wp_links (link_url, link_name, link_category, link_rss) VALUES ('http://dougal.gunters.org/', 'Dougal', 1, 'http://dougal.gunters.org/feed/');

    WordPress database error: [Field 'category_description' doesn't have a default value]
    INSERT INTO wp_categories (cat_ID, cat_name, category_nicename) VALUES ('0', 'Uncategorized', 'uncategorized')

    WordPress database error: [Field 'post_excerpt' doesn't have a default value]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_name, post_modified, post_modified_gmt) VALUES ('1', '2005-12-19 10:26:24', '2005-12-19 17:26:24', 'Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!', 'Hello world!', '0', 'hello-world', '2005-12-19 10:26:24', '2005-12-19 17:26:24')

    Finished!
    --------------------------------------------

    They al lseam to be tellig nem that the fields have no defautl value. Is this a problem with MySQL? If so, what do i do?

  2. Mark (podz)
    Support Maven
    Posted 9 years ago #

    You are running mySQL 5 in Strict mode. If you can drop to whatever level is below Strict, all should be fine.

  3. RTAdams89
    Member
    Posted 9 years ago #

    Just as you posted that I found another post that says the same thing. How do I go about changing SQL out of strict mode?

  4. RTAdams89
    Member
    Posted 9 years ago #

    I got it. I used the instance configuration GUI to take it out of strict mode. Thanks for the help.

Topic Closed

This topic has been closed to new replies.

About this Topic