To post a new support question, click the Post New Topic button below.
Current Version: 4.7.1 | Sytist Manual | Common  Issues | Feature Requests

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Downloading Images For Multiple Orders At Once Not Working

76 posts
Tue Apr 25, 23 7:49 AM CST

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

Edited Tue Apr 25, 23 7:50 AM by Chuck Perkins
15,854 posts (admin)
Tue Apr 25, 23 10:51 AM CST

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.

Tim Grissett, DIA -
My Email Address:
76 posts
Tue Apr 25, 23 5:45 PM CST

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.

15,854 posts (admin)
Thu Apr 27, 23 8:03 AM CST

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); 

Tim Grissett, DIA -
My Email Address:
76 posts
Tue May 02, 23 8:25 AM CST

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 

15,854 posts (admin)
Tue May 02, 23 12:57 PM CST

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.

Tim Grissett, DIA -
My Email Address:
76 posts
Mon May 08, 23 9:20 AM CST

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.

15,854 posts (admin)
Mon May 08, 23 12:34 PM CST

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.

Attached Photos

Tim Grissett, DIA -
My Email Address:
76 posts
Fri May 12, 23 7:45 PM CST

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 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. 

9 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 358 times
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window