• Resolved pixelnik

    (@pixelnik)


    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)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Error’ is closed to new replies.