- This topic has 9 replies, 2 voices, and was last updated 4 weeks, 1 day ago by
.
-
Posts
-
Hello
On a big folder (850 Mo / 247 Files) , I have the error
2006
MySQL server has gone away
What can I do to correct the problem ?
Thank you for your help
Serge
@serge73. Thanks for posting.
There is nothing that I can think of with my extension that would trigger that error, regardless of how many files or how large the files are. There is no database interaction that is dependent on the number or size of the files.
So, you should probably check your error logs or Joomla debug info to find out what triggered that error.
Sorry for my late response, but I was seek.
As I see the problem come from timeout with the bdd
I see a solution :
Either your processing takes too long, in which case you should maintain regular exchanges with the database via mysql_ping().
Is it possible for you to do it regularly during the creation of the archive file ?
Best Regards
Serge
@serge73. Thanks for following up.
You will need to describe what you are doing when the error is displayed. Also, you need to provide PHP error log information so, we can see what line of code the error is triggered at.
Is this related to only when you attempt to download a zip archive of a set of files? How many files are you allowing to be zipped up and what is the maximum size of the zip file that you set?
Hello Micheal
The problem arises when there are a lot of photo files to download and the host’s server is loaded, the file download process falls into a MySQL time-out when the archive file is created.The solution on a dedicated server would be to modify the Mysql settings.
But on a shared server like ours, like many Joomla users, it’s impossible to change the Mysql settings.
The recommended solution, then, is to add regular exchanges with the database using mysql_ping() to avoid time-out.Thanks for finding a solution
Hi Serge. Could you please respond to my questions? I can’t help you if I can’t replicate the problem. I need to know what you are doing that triggers your error.
You haven’t provided any error log entries, which would typically list what line the error occurs at. Nor have you told me what steps you have taken to trigger that error. Nor what settings you have used for creating the archive (zip file).
In creating a zip archive, the extension records which files are downloaded, which is the only reference to updating the MySQL database. It would be important to know what settings you used, as well as how many files you are attempting to zip in one archive, and the total size of those files.
Even if I was attempting to change the code, I need to know how to test it. I need to know how to replicate the error, so that I can test if the error is fixed. Otherwise, I would be making changes and guessing whether they worked or not. I trust you understand my point of view.
Kind regards
@serge73. Thanks, I responded to your email.
- You must be logged in to reply to this topic.