Title: 'Invalid default value' = database install fail Last modified: August 31, 2016 --- # 'Invalid default value' = database install fail * Resolved Anonymous User * (@anonymized-10133093) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/) * hello, i used to use this plugin with 100% success on my localhost until i updated my WAMP install to the new 3.01 version that has all the latest versions of PHP etc. * Now when I try to create the site on my local host I get the errors below and can’t even log into the new site. Really need some help! THANKS! (I just copied what I thought was relevant) * ********************************************************************** VERSION: 1.1.0 PHP: 7.0.2 | SAPI: apache2handler SERVER: Apache/2.4.17 (Win64) PHP/7.0.2******************************************************************************************************************************************** DATABASE-ROUTINES **********************************************************************————————————– SERVER ENVIROMENT ————————————– MYSQL VERSION: 5.7.9 TIMEOUT: 5000 MAXPACK: 1048576————————————– DATABASE RESULTS ————————————– **ERROR** database error write ‘Invalid default value for ‘comment_date” – [sql= CREATE TABLE `wp_comments` ( `comment_ID` bigint( 20) unsigned NOT NULL A…] **ERROR** database error write ‘Invalid default value for ‘created” – [sql= CREATE TABLE `wp_duplicator_packages` ( `id` bigint(20) unsigned NOT NUL…] **ERROR** database error write ‘Invalid default value for ‘ link_updated” – [sql= CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL AUTO_IN…] **ERROR** database error write ‘Invalid default value for ‘ post_date” – [sql= CREATE TABLE `wp_posts` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREME…] **ERROR** database error write ‘Invalid default value for ‘user_registered”–[ sql= CREATE TABLE `wp_users` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREME…]** ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’–[ sql= * /* INSERT TABLE DATA: wp_duplicator_packages */ INSERT INTO `wp_duplicato…] ** ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’–[ sql=INSERT INTO `wp_duplicator_packages` VALUES(“2”, “20151126_naturalexpressio…]** ERROR** database error write ‘Table ‘ne.wp_duplicator_packages’ doesn’t exist’–[ sql=INSERT INTO `wp_duplicator_packages` VALUES(“3”, “20151126_naturalexpressio…]** ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql= /* INSERT TABLE DATA: wp_posts */ INSERT INTO `wp_posts` VALUES(“4”, “1”, …] **ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO ` wp_posts` VALUES(“5”, “1”, “2015-09-07 14:22:39”, “2015-09-07 …] **ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“7”, “1”, “2015-09-07 14:30:51”, “2015-09-07 …] **ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“ 8”, “1”, “2015-09-07 14:32:08”, “2015-09-07 …] **ERROR** database error write‘ Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“9”, “ 1”, “2015-09-07 14:32:36”, “2015-09-07 …] **ERROR** database error write ‘Table‘ ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“10”, “1”, “ 2015-09-07 14:33:05”, “2015-09-07…] **ERROR** database error write ‘Table ‘ne. wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“11”, “1”, “2015- 09-07 14:34:39”, “2015-09-07…] **ERROR** database error write ‘Table ‘ne.wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“19”, “1”, “2015-09-09 08: 33:24”, “2015-09-09…] * … and this continues with Errors: Deploy (121) * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/) Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/page/2/?output_format=md) [→](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/page/2/?output_format=md) * [madla](https://wordpress.org/support/users/madla/) * (@madla) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948785) * Running into the same issue when trying to pull my site onto my local computer( Mac OS X El Capitan). * I installed the latest version of MySQL and ran into the same errors. * I’m wondering if it has anything to do with the SQL Modes: [docs](http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html) mysql> SELECT @@GLOBAL.sql_mode; Mine look like this: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION * ******************************************************************************** DATABASE-ROUTINES ********************************************************************************————————————– SERVER ENVIROMENT ————————————– MYSQL VERSION: 5.7.10 TIMEOUT: 5000 MAXPACK: 4194304 ————————————– DATABASE RESULTS ————————————– **ERROR** database error write ‘Invalid default value for ‘comment_date” – [sql= CREATE TABLE `wp_comments`(` comment_ID` bigint(20) unsigned NOT NULL A…] **ERROR** database error write ‘ Invalid default value for ‘created” – [sql= CREATE TABLE `wp_duplicator_packages`(` id` bigint(20) unsigned NOT NUL…] **ERROR** database error write ‘Invalid default value for ‘link_updated” – [sql= CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL AUTO_IN…] **ERROR** database error write ‘Invalid default value for ‘post_date” – [sql= CREATE TABLE `wp_posts` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREME…] **ERROR** database error write ‘Invalid default value for‘ user_registered” – [sql= CREATE TABLE `wp_users` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREME…] **ERROR** database error write ‘Table ‘shenatest.wp_duplicator_packages’ doesn’t exist’ – [sql= * /* INSERT TABLE DATA: wp_duplicator_packages */ INSERT INTO ` wp_duplicato…]** ERROR** database error write ‘Table ‘shenatest.wp_duplicator_packages’ doesn’t exist’ – [sql=INSERT INTO `wp_duplicator_packages` VALUES(“20”, “20151221_shenatschofen_c…]** ERROR** database error write ‘Table ‘shenatest.wp_duplicator_packages’ doesn’t exist’ – [sql=INSERT INTO `wp_duplicator_packages` VALUES(“21”, “20151221_shenatschofen_c…]** ERROR** database error write ‘Incorrect string value: ‘\xF0\x9F\x91\x8D” …’ for column ‘option_value’ at row 1′ – [sql=INSERT INTO `wp_options` VALUES(“8080”,“ _transient_feed_ac0b00fe65abe10e0c…] **ERROR** database error write ‘Table ‘shenatest. wp_posts’ doesn’t exist’ – [sql= /* INSERT TABLE DATA: wp_posts */ INSERT INTO` wp_posts` VALUES(“49”, “2”,…] **ERROR** database error write ‘Table ‘shenatest. wp_posts’ doesn’t exist’ – [sql=INSERT INTO `wp_posts` VALUES(“55”, “2”, “2013- 02-05 16:24:35”, “2013-02-05…] * [madla](https://wordpress.org/support/users/madla/) * (@madla) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948788) * More details: The script created tables in the database. I tried running the process with the mySql root account with the same errors…so I don’t think it’s a permissions issue. * The mySQL version that HostGator uses is 5.5.42-37.1 which is older than the installed version on my mac. However, I’ve been running a version of 5.7x on another mac and that has been working. * [madla](https://wordpress.org/support/users/madla/) * (@madla) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948813) * I got it to work again. It was the SQL mode. It was too strict to allow the script to run. As my install is only local for testing, I just set the mode to: * sql_mode=NO_ENGINE_SUBSTITUTION in the my.cnf file * That did the trick. * Thread Starter Anonymous User * (@anonymized-10133093) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948841) * THANKS madla!!! You sorted it, now works fine 🙂 * For anyone else with this problem, I opened this file in notepad: * C:\wamp64\bin\mysql\mysql5.7.9\my.ini * and added the final line to the file: * [mysqld] port = 3306 sql_mode=NO_ENGINE_SUBSTITUTION * All seems well now. * It would be great if this could be addressed in the Duplicator FAQ or by some automatic means, was a huge waste of time and energy fixing manually. * I will not mark it resolved yet in the hope one of the duplicator guys could comment on this, cheers! * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948916) * Hey Guys, * Thanks for providing your solutions/work-a-rounds. I have added this thread to the todo list of items to look into, it may take some time but if there is a solution in code we will try and automate it for you.. * thanks * [esseamme](https://wordpress.org/support/users/esseamme/) * (@esseamme) * [10 years, 2 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948979) * Thanks a lot David, you help me!!! Thanks 😀 * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [10 years, 1 month ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948980) * Updated on the FAQ as well! * [maylene](https://wordpress.org/support/users/maylene/) * (@maylene) * [10 years ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-6948996) * I’m new to DigitalOcean and using ServerPilot to manage my Ubuntu 16.04 droplet. The above workarounds didn’t work for me though I had a ton of similar Deploy errors on two separate site installs. * Thanks to the clues above, I found [this ServerPilot article](https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7.html) about disabling Strict Mode in MySQL 5.7. Worked like a charm. Hope this helps someone else! * [BenM](https://wordpress.org/support/users/alysko/) * (@alysko) * [9 years, 8 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8209671) * Hi, * Ok for this fix but why Duplicator doesn’t display any errors ?! I lost a lot of time, trying many password, checking folder md5, etc. * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [9 years, 7 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8247521) * Hey Alysko, * Duplicator does display errors, however its in the form of SQL errors in the the installer-log.txt. We are looking for a way to try and display it in the UI as well if its possible to detect the setting from SQL. * Thanks - This reply was modified 9 years, 7 months ago by [Cory Lamle](https://wordpress.org/support/users/corylamleorg/). * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [9 years, 7 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8251842) * There is now a possible fix for this in developer version, if anyone wants to give it a try and provide feedback that will allow us to get it pushed out in the next version. Instructions for using/testing can be found on [this thread](https://wordpress.org/support/topic/duplicate-from-ubuntu-to-xxserver/). * Thanks - This reply was modified 9 years, 7 months ago by [Cory Lamle](https://wordpress.org/support/users/corylamleorg/). * [BenM](https://wordpress.org/support/users/alysko/) * (@alysko) * [9 years, 7 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8257750) * Great, I will try it. * [najhal](https://wordpress.org/support/users/najhal/) * (@najhal) * [9 years, 7 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8268710) * just to let you know : i’ve got the same problem and i’m on a shared server ( sql private OVH) so no my.ini, etc… * to resolve the problem, i just : 1/ open the database.sql in the archive 2/ add on the top on the file : SET SESSION sql_mode=’NO_ENGINE_SUBSTITUTION’; 3/ saved the file * then the installation worked like a charm. * great pluging by the way really usefull 😉 * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [9 years, 7 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8377772) * Hi [@najhal](https://wordpress.org/support/users/najhal/), * With version 1.1.20 there is now a new option under advanced settings in the installer called MySQL mode that will allow you to pass in custom sql_modes… * Hope this helps everyone on this thread, any issues please let me know~ * [hamalaisenmika](https://wordpress.org/support/users/hamalaisenmika/) * (@hamalaisenmika) * [9 years, 6 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/#post-8443902) * Remember to restart server after mode change… Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/page/2/?output_format=md) [→](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/page/2/?output_format=md) The topic ‘'Invalid default value' = database install fail’ is closed to new replies. * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985) * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/) * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq) * [Support Threads](https://wordpress.org/support/plugin/duplicator/) * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/) * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/) * 23 replies * 14 participants * Last reply from: [razvancs](https://wordpress.org/support/users/razvancs/) * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/invalid-default-value-database-install-fail/page/2/#post-9353390) * Status: resolved