Downloading Images For Multiple Orders At Once Not Working

I have selected multiple orders to download the original images. I see the bar countup then goes to zipping and just sits there spinning. it says 5 mins but I let it go for 6hrs and it never finished zipping the files. 67 files 700mb

If I go into one of the jobs and select download images it takes less than minute to show the Download button. 

These are all store on an Amazon S3 container, if that makes a difference

Has it worked before and does it do it every time?

Are you able to duplicate it happening if it doesn't do it every time? 

If so, let me know what orders to select.

Looks like it happens every time I select more than 2 orders from the Open orders page. I've tried the 27 I need to download, then 10, 4, 3 and then selecting 2 orders finally worked. 

Orders 10726-10754 and with and without 10728 which I already downloaded by itself.

The MySQL server is timing out while creating the zip file if there is more than so many photos being zipped up.

This is a server issue / setting. You check with your host and see if they can increase the connect timeout  / socket timeout settings.

You can aleternativly try adding these lines code code to your sy-config.php file through the file manager in your hosting control panel to see if it increases it. 

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300); 

My hosting company is asking what program is performing the zipping of the images. Is there a certain function I should have them look at to make adjustments on MySQL timeout 

PHP is generating the zip file with the ZIP functions. 

I don't know of a certain function. It is the timeout of the MySQL database.

Still having issues. The last tech said it wasn't MySQL timeout this is what he said he did and I was able to download one of my orders that has 15 images in it, which before the changes I could not upload. 

From Inmotion Hosting Tech Support:

"Previously, it was on 8.0... now it's on 7.4  

I mentioned it... PHP error logs are still enabled.  

Increased timeouts in MultiPHP INI Editor  

Fix was to set older PHP version in cPanel | MultiPHP Manager.  

Possible cause: old software...."

A tech today said the developer needs to change it because it's on a shared hosting plan and they can't change it.

Not sure where else to do with this issue.

Attached is a screenshot of the error "MYSQL ERROR: MySQL server has gone away".

This is because the actual zip process (when it is just zipping the photos it copied over) is taking way too long and then the MySQL database is timing out because of it.

Nothing in the code I can change to change that. If the zip function didn't take so long then maybe the database connection will not time out.

Probably the server doesn't have the power to create the zip any faster.

In comparison, on your site it took 1.2 minutes for the ZIP process to run before it errored out for 26 photos.

With another installation, the zip process took 3 seconds for the same amount of photos.

Here is the latest response from inmotion hosting.

"I just wanted to send you this email to let you know that reviewing the code of your website and writing code is beyond the scope of what we normally provide support for. Other support agents will not review the code of your site for you or write test code, this is beyond the scope of what we normally do.

That said, I have created a test PHP page at https://cperkinsphotography.com/zip-test/ which creates a .zip file using files in the "public_html/zip-test/FILES" directory and displays how long it took to create the .zip file.

When I had the test page create a .zip file from 10 10MB files, it took 20 seconds to create the 100MB .zip file. When I had the test page create a .zip file using 20 10MB files, it took 28 seconds to create the .zip file.

The test page that I created demonstrates that the zipping files using PHP is working correctly and is not taking an unusually long time. Everything is working as expected on the server.

If you are experiencing issues with your site creating .zip files, you will need to have your web developer review and optimize the code for your site. Everything is working correctly on our server."

Not sure where else to go with this, wish I could make use of the zip all function from multiple orders.