• Resolved clonemonkey23

    (@clonemonkey23)


    Hi,

    I’ve tried installing two sites on separate hosting and get the following error both times:

    server code: 200
    status: OK
    response:
    INSTALL ERROR!
    No tables where created during step 1 of the install. Please review the installer-log.txt file for sql error messages. You may have to manually run the installer-data.sql with a tool like phpmyadmin to validate the data input. If you have enabled compatibility mode during the package creation process then the database server version your using may not be compatible with this script.

    I’ve used Duplicator many times and never run into this issue and I’m not sure how to solve it. Also when looking at the wp-config file it is blank?

    Thanks

    https://wordpress.org/plugins/duplicator/

Viewing 14 replies - 1 through 14 (of 14 total)
  • Hey clonemonkey23,

    Checkout this question on the FAQs page I believe it may help or provide some clues about this issue:
    -> Browse to: http://lifeinthegrid.com/duplicator-faq
    -> Find section: “Permission & System Issues”

    With a blank file it looks like php is unable to write to it…

    Hope that helps!

    I get the same error message. Searched but can not find the answer in the “Permissions & Systems Issues”. Receive no error messages when I run the “Test connection”.
    The installer-data.sql file created is 0 kb.

    Note that I used the Duplicator before without any problems. What differs is that I have a new computer and a new installation of MAMP-Pro. Duplicator is also updated.

    Have you check the permissions of the Database User your trying to use on step 1 of the installer. That database user should have full permissions…

    I shall check again 🙂

    All Privilegies
    If the database user has enough privileges so I will surely not get forward in the installation.
    or?

    has not…

    Hi Cory,

    I am having the exact same issue as OP. I have tried changing the permissions on the site directory and files recursively to 777 and ensured that the Database User has full permissions via phpmyadmin. I still get the same error. Below is part of the log file the error produces (file name hidden under ****):

    ********************************************************************************
    ARCHIVE SETUP
    ********************************************************************************
    NAME: 20160130_******_archive.zip
    SIZE: 869.94MB
    ZIP: Enabled (ZipArchive Support)
    EXTRACTING
    ZipArchive Object
    (
    [status] => 0
    [statusSys] => 0
    [numFiles] => 19624
    [filename] => /Users/Mac/Sites/duplicator/20160130_*****_archive.zip
    [comment] =>
    )
    COMPLETE: true

    WEB SERVER CONFIGURATION FILE RESET:
    – Backup of .htaccess/web.config made to .orig
    – Reset of .htaccess/web.config files
    ERROR: Unable to read from the extracted database.sql file .
    Validate the permissions and/or group-owner rights on directory ‘/Users/Mac/Sites/duplicator’

    ERROR: Unable to create new sql file installer-data.sql.
    Validate the permissions and/or group-owner rights on directory ‘/Users/Mac/Sites/duplicator’ and file ‘installer-data.sql’

    UPDATED FILES:
    – SQL FILE: ‘/Users/Mac/Sites/duplicator/installer-data.sql’
    – WP-CONFIG: ‘/Users/Mac/Sites/duplicator/wp-config.php’

    ARCHIVE RUNTIME: 41.1835 sec.

    If the database user has full perms and the file is still empty then there is an issue where PHP is unable to write to the file system. If you have 777 try and fiddle with a different owner (chown). If you create a test.php and simply put this method in the file you can determine if PHP has access to write at this location.

    http://php.net/manual/en/function.is-writable.php

    Hi there!

    Getting the same error on two different configs – one on Ubuntu and one on MAMP. In both cases directories and files ARE writable by PHP, file installer-data.sql is created but nothing goes in.

    database.sql has all the info about tables/etc.

    Hey Salsaly,

    It could be possible that file_put_contents is having issue in your environments. That logic for the transfer of data is found in this file, around line #257 as of version 1.1.4. Not really sure what else it could be, have not been able to repro on any of our unit test environments…

    Hope that helps!

    @tobbehj
    can you please explain how did you fix the issue,
    I´m trying to replicate a site on a local host (should have all the permissions, because it´s the one I always use for developing and the root user has all the permisions over the ddbb) and I´m getting the error

    I don´t know if I should get special permissions before creating the package (something I´ve never asked for when using duplicator btw)

    thanks

    @usaginyunyu: This is not your topic. If you require assistance then, as per the Forum Welcome, please post your own topic.

    Dear all,

    I ran into the same problems, when trying to migrate a wordpress site from server to server. I am using a Mac. When using the Duplicator plugin, the default way to save the package, downloading over Safari, is actually unzipped, so you would need to zip the files again before FTP-ing to your new server. I ran into these problems when running installer.php with the package files still in a subfolder. This is the default unzipping behaviour. I fixed it by moving all the unzipped files into the folder where the installer.php file resides, removing the package zip file and its unzipped (now empty folder) and choosing the ‘manual unzip’ option from the advanced settings in the installer.php.

    Then I could run the installer again and everything went smoothly.
    Hope this solutions works for you as well!

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘No tables where created during step 1 of the install’ is closed to new replies.