Title: Database Error
Last modified: April 25, 2017

---

# Database Error

 *  Resolved [pixelnik](https://wordpress.org/support/users/pixelnik/)
 * (@pixelnik)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-error-237/)
 * Hello,
    i used duplicator until today without any problems. But today i wanted
   to restore a page to a webserver i installed at home. (ubuntu, apache, etc. all
   the latest versions) and got errors, importing the database. the name of the 
   database is demo. (importing the sql-file with phpmyadmin works)
 * this is a short overview of the installer.log:
 * ————————————–
    DATABASE ENVIRONMENT ————————————– MYSQL VERSION: This Server:
   5.7.17 — Build Server: 5.6.35 FILE SIZE: database.sql (5.89MB) – installer-data.
   sql (5.89MB) TIMEOUT: 5000 MAXPACK: 16777216 SQLMODE: 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
   NEW SQL FILE: [/var/www/html/demo/installer-data.sql] ————————————– 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…] . .
 * CREATE TABLE `wp_users` (
    `ID` bigint(20) unsigned NOT NULL AUTO_INCREME…] **
   ERROR** database error write ‘Invalid default value for ‘access_granted” – [sql
   = CREATE TABLE `wp_woocommerce_downloadable_product_permissions` ( `permis…] **
   ERROR** database error write ‘Table ‘demo.wp_comments’ doesn’t exist’ – [sql=
 * /* INSERT TABLE DATA: wp_comments */
    INSERT INTO `wp_comments` VALUES(“1″…] **
   ERROR** database error write ‘Table ‘demo.wp_duplicator_packages’ doesn’t exist’–[
   sql= /* INSERT TABLE DATA: wp_duplicator_packages */ INSERT INTO `wp_duplicator…]**
   ERROR** database error write ‘Table ‘demo.wp_posts’ doesn’t exist’ – [sql= /*
   INSERT TABLE DATA: wp_posts */ INSERT INTO `wp_posts` VALUES(“1”, “1”, …] **ERROR**
   database error write ‘Table ‘demo.wp_posts’ doesn’t exist’ – [sql=INSERT INTO`
   wp_posts` VALUES(“2”, “1”, “2017-03-28 09:12:24”, “2017-03-28 …]
 * someone got similar issues? Probably my webserver is not configured properly

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/database-error-237/#post-9065646)
 * Hey [@pixelnik](https://wordpress.org/support/users/pixelnik/),
 * On Step 2 > Options > Mode > Custom Enter in only ‘NO_ENGINE_SUBSTITUTION’ that
   should fix the date error…
 * Let me know if that helps~
    -  This reply was modified 9 years, 1 month ago by [Cory Lamle](https://wordpress.org/support/users/corylamleorg/).
      Reason: spelling
 *  Thread Starter [pixelnik](https://wordpress.org/support/users/pixelnik/)
 * (@pixelnik)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/database-error-237/#post-9067316)
 * Hy [@corylamleorg](https://wordpress.org/support/users/corylamleorg/)
    thank 
   you very much!!!!! This helped indeed.
 * I am curious, what this Parameter does, I’ll investigate 🙂
 * Best regards from Vienna
    Chris(Pixelnik)
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/database-error-237/#post-9067644)
 * Here is an overview…
 * [https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_engine_substitution](https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_engine_substitution)
 * In future versions we are planning to help with some checks that will help people
   to better identify the issue…

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database Error’ 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/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 3 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/database-error-237/#post-9067644)
 * Status: resolved