Support » Plugin: Duplicator - WordPress Migration Plugin » Unable to deploy

  • grahammansfieldphotography

    (@grahammansfieldphotography)


    Hi Have constructed my new WordPress website using xamp on a Mac. I am now ready to deploy it however wanted to Duplicator out before trying to deploy on live system. I have another clean windows machine where I have installed xampp. I know that creating a Database is tricky so made sure i created a new database on the clean windows machine. I ensured that all my permissions were set correctly on the DB. I also ensured that HTTPDOCS folder permissions were set to write/read etc for EVERYONE.
    Every time I try and deploy I get the message
    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.

    On examining the install log I get this m,essage

    WARNING: Unable to locate wp-config.php file. Be sure the file is present in your archive.

    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 ‘C:/xampp/htdocs’

    ERROR: Unable to create new sql file installer-data.sql.
    Validate the permissions and/or group-owner rights on directory ‘C:/xampp/htdocs’ and file ‘installer-data.sql’

    UPDATED FILES:
    – SQL FILE: ‘C:/xampp/htdocs/installer-data.sql’
    – WP-CONFIG: ‘C:/xampp/htdocs/wp-config.php’

    I realise that it is all about permissions but believe that I have set them correctly.
    can anyone help me please.

    Regards
    Graham

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author Cory Lamle

    (@corylamleorg)

    A couple of things to try:

    1. Double check the archive.zip file has the database.sql and wp-config.php files in it with data in the database.sql file. If they don’t then the package is having issues at build time. If they are there then goto step 2.

    2. After the archive has been extracted (installer step 1) check the installer-data.sql file and make sure it has data in it. If it doesn’t then PHP is having permission writing to the directory where its deployed. If it does have data then goto step 3

    3. Double check your DB users permissions to make sure they have the correct perms to create tables.

    Let me know if that gets you going…

    Thanks~

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Hi Cory,
    Thanks for your fast response.
    I can confirm that Database.sql and we-configure.php are in the zip and that the database.sql has data in it.
    I have checked the installer-data.sql and it is empty so clearly this is the issue.
    Is PHP have issues writing to the database or to the installer–data.sql file?
    Regards
    Graham

    Plugin Author Cory Lamle

    (@corylamleorg)

    Yes PHP can’t write to the file, because it most likely doesn’t have enough memory, because the database.sql file is rather large… You will need to increase the PHP memory on your local machine.

    Let me know if that helps~

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Cory, I have increased it from 128 to 512k but still the same. What size do you suggest.
    Thanks for your help.
    Graham

    Plugin Author Cory Lamle

    (@corylamleorg)

    It depends on how large your database.sql file is. Double check the size of that file (it will be inside of the archive.zip file) and then tack on an additional 100MB. Unfortunately right now we use file_get_contents to read in that file which is a byte for byte read. We hope to try and create a stream reader in the feature to not require so much memory.

    Also if you have a really large table (such as a log or stats table) that doesn’t have data you need, then you can filter that table when you create the package and that should decrease the overall size of the database.sql file

    Hope that helps~

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Hi Cory,
    The database is 1,118,049 so in the php.ini file so I increased it to 1,300m but I still get exactly the same error. Sorry to keep pestering you but just not sure what else I can do!

    Regards
    Graham

    Plugin Author Cory Lamle

    (@corylamleorg)

    Try something like 2,400mb just to get over any threshold. Do you have any log or stats tables that your trying to backup that you probably don’t need?

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Hi Cory,
    Well I did as you said and still exactly the same error.
    No I don’t have any log or stats tables. I think the reason the DB is so large is that I have a lot of images in the blogs.
    Is there a constraint in the DB size for Duplicator?

    Graham

    Plugin Author Cory Lamle

    (@corylamleorg)

    Is the 1,118,049 in KB, MB? Technically you can try as high as PHP will allow. If your on your own server you can easily bump it upto 10,000MB or higher. If your not on your own sever then it may be likely that the host has a cap and no matter what you set it to its not going to go above that threshold. If you want to submit a support ticket I can have a look, just refer to this thread.

    Thanks

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Hi Cory
    Well I was trying to do this on a another machine using localhost and I wondered if the problem was with the local deployment. I therefore decided to try it on a sub directory of my main domain. I repackaged everything make sure that there were no errors. I also deleted some of the images to try and reduce the size. Once packaged I uploaded to the sub directory of the main domain and ran the installer. Sadly again I am getting the exact same error message. Oh and I also updated Duplicator to the latest version just to be on the safe side.
    I want to get this working and am happy to upgrade to pro providing I can get it to work.
    Ok I will do that and thanks again.
    Regards

    Graham

    grahammansfieldphotography

    (@grahammansfieldphotography)

    Hi Cory,
    Where do I lodge a support ticket?
    Graham

    Plugin Author Cory Lamle

    (@corylamleorg)

    Hey Cory,

    I think I am having pretty much the same issue… I also get the error 200 with the same ERRORS:
    ERROR: Unable to read from the extracted database.sql file .
    Validate the permissions and/or group-owner rights on directory ‘/home2/…./public_html/….’

    ERROR: Unable to create new sql file installer-data.sql.
    Validate the permissions and/or group-owner rights on directory ‘/home2/…./public_html/….’ and file ‘installer-data.sql’

    I read through your responses of helping Graham out and checked that my archive.zip file has the database.sql and wp-config.php – they do. so it’s step 2, like Graham that I am stuck on. My web host allowed me to raise my php.ini file to 1024MB (my database.sql is 2MB) but it is still showing the same errors… My web host support told me I should update the database in the installer.php but didn’t give me details of how to actually do it since it was a third party and they couldn’t provide me further support.

    How can I sort this out?

    Thanks for your help!

    Cory replied to me on my help ticket and I got it all sorted.
    If anyone out there is struggling with the same “error” and you’re using Safari on a Mac, try disabling Safari to automatically unzip downloaded files. There’s detailed instructions on how to do that here: https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-020-q

    🙂

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Unable to deploy’ is closed to new replies.