Title: install errors, “no default value” Last modified: August 18, 2016 --- # install errors, “no default value” * [RTAdams89](https://wordpress.org/support/users/rtadams89/) * (@rtadams89) * [20 years, 5 months ago](https://wordpress.org/support/topic/install-errors-no-default-value/) * 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’](http://blog.carthik.net/index.php’);,‘ Carthik’, 1, ‘[http://blog.carthik.net/feed/’](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/’](http://blogs.linux.ie/xeer/’);, ‘Donncha’, 1, ‘[http://blogs.linux.ie/xeer/feed/’](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/’](http://zengun.org/weblog/’);, ‘Michel’, 1, ‘[http://zengun.org/weblog/feed/’](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/’](http://boren.nu/’);, ‘Ryan’, 1, ‘[http://boren.nu/feed/’](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/’](http://photomatt.net/’);, ‘Matt’, 1, ‘[http://xml.photomatt.net/feed/’](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/’](http://zed1.com/journalized/’);, ‘Mike’, 1, ‘[http://zed1.com/journalized/feed/’](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/’](http://www.alexking.org/’);, ‘Alex’, 1,‘ [http://www.alexking.org/blog/wp-rss2.php’](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/’](http://dougal.gunters.org/’);, ‘Dougal’, 1, ‘[http://dougal.gunters.org/feed/’](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? Viewing 3 replies - 1 through 3 (of 3 total) * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [20 years, 5 months ago](https://wordpress.org/support/topic/install-errors-no-default-value/#post-298115) * You are running mySQL 5 in Strict mode. If you can drop to whatever level is below Strict, all should be fine. * Thread Starter [RTAdams89](https://wordpress.org/support/users/rtadams89/) * (@rtadams89) * [20 years, 5 months ago](https://wordpress.org/support/topic/install-errors-no-default-value/#post-298120) * 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? * Thread Starter [RTAdams89](https://wordpress.org/support/users/rtadams89/) * (@rtadams89) * [20 years, 5 months ago](https://wordpress.org/support/topic/install-errors-no-default-value/#post-298122) * I got it. I used the instance configuration GUI to take it out of strict mode. Thanks for the help. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘install errors, “no default value”’ is closed to new replies. ## Tags * [default](https://wordpress.org/support/topic-tag/default/) * [installation](https://wordpress.org/support/topic-tag/installation/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 3 replies * 2 participants * Last reply from: [RTAdams89](https://wordpress.org/support/users/rtadams89/) * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/install-errors-no-default-value/#post-298122) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics