Database Error
-
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 TABLEwp_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 TABLEwp_woocommerce_downloadable_product_permissions
(
`permis…]
**ERROR** database error write ‘Table ‘demo.wp_comments’ doesn’t exist’ – [sql=/* INSERT TABLE DATA: wp_comments */
INSERT INTOwp_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 INTOwp_posts
VALUES(“1”, “1”, …]
**ERROR** database error write ‘Table ‘demo.wp_posts’ doesn’t exist’ – [sql=INSERT INTOwp_posts
VALUES(“2”, “1”, “2017-03-28 09:12:24”, “2017-03-28 …]someone got similar issues? Probably my webserver is not configured properly
- The topic ‘Database Error’ is closed to new replies.