WordPress.org

Support

Support » Installation » MYSql Errors

MYSql Errors

  • OS: Server 2003 IIS 6.0
    MySQL 5.0

    When preforming the installation I keep getting:

    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-10-29 13:57:49’, ‘2005-10-29 20:57:49’, ‘Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!’, ‘Hello world!’, ‘0’, ‘hello-world’, ‘2005-10-29 13:57:49’, ‘2005-10-29 20:57:49’)

    Warning: Invalid argument supplied for foreach() in c:\Inetpub\wwwroot\wp-admin\upgrade-functions.php on line 30

Viewing 1 replies (of 1 total)
  • Figured out my problem. It had to do with the MySQL instance configuration. I had to turn off Enable Strict Mode.

Viewing 1 replies (of 1 total)
  • The topic ‘MYSql Errors’ is closed to new replies.
Skip to toolbar