WordPress.org

Support

Support » Installation » WordPress database error:

WordPress database error:

  • I am trying to install wordpress multi user, using the url http://<sitename>/wp-inst/wp-admin/install.php?step=2.
    I created the database and managed to get to the second step where wordpress automatically creates inital blogs.

    But i kept getting the errors like the one i pasted below.

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

    WordPress database error: [Field ‘link_notes’ doesn’t have a default value]
    INSERT INTO wp_1_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_1_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_1_links (link_url, link_name, link_category, link_rss) VALUES (‘http://boren.nu/’, ‘Ryan’, 1, ‘http://boren.nu/feed/’);
    ……………..
    WordPress database error: [Field ‘category_description’ doesn’t have a default value]
    INSERT INTO wp_1_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_1_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-07 18:01:53’, ‘2005-10-07 22:01:53’, ‘Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!’, ‘Hello world!’, ‘0’, ‘hello-world’, ‘2005-10-07 18:01:53’, ‘2005-10-07 22:01:53’)
    …………………………….
    Now you can log in with the username “admin” and password ‘pwd’
    Finished!

    This one doesnt create the .htaccess file.

    I have no idea what is going on, i suspect the table creation scripts and the insert statements are not in synch?

    If i use the url http://blogs.webmd.net/index.php, i get the same error, but creates the .htaccess file and clicking on any link further on the site gives 500 error until i delete the .htaccess file.

    Any help is appreciated.

    Thanks
    Shahin

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error:’ is closed to new replies.
Skip to toolbar