Unable to deploy

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~

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

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~

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

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~

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

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?

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

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

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

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

help tickets here

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

??