Problem Uploading Files! MySQL?

avatar juamovi Nov 22. 2007. 7:00 am #1
Hi everybody,

I've just installed the v0.71 aC this week on my company. Now, I'm testing how it work before starting the normal use.

I found one problem uploading files which size is bigger than 1Mb. I've read a lot of topics about that here but I cannot correct this problem.

I've checked the following parameters:

upload_max_filesize = 200M
post_max_size = 8M
max_execution_time = 30

The application shows me the following message :

Query failed with message 'MySQL server has gone away'
Error params:
File: .\activecollab\environment\library\database\adapters\AbstractDBAdapter.class.php
Line: 371
Sql: ROLLBACK
Error number: 2006
Error message: MySQL server has gone away

I'd be pleased if sb can help me.

Thanks
avatar Ilija Studen Staff Nov 22. 2007. 8:18 am #2
The easiest possible solution would be just to change to File System Storage in General settings. If you are forced to use MySQL storage engine you should increase max_packet_size value to the max file size value you want to upload (8MB in your case).
Follow @activecollab and activeCollab on Facebook.
avatar juamovi Nov 22. 2007. 3:34 pm #3
Ilija Studen:
The easiest possible solution would be just to change to File System Storage in General settings.


Hi again,

Could you tell how could I change this? I've also been searching for the max_packet_size parameter and I didn't find it.

Sorry and thanks

avatar Ilija Studen Staff Nov 22. 2007. 4:50 pm #4
It is MySQL configuration option. You should consult MySQL documentation or Google to learn how to change it (if I remember correctly, you'll need to add it to [mysql] section of your my.cnf file).

Still, I would recommend you to use File System storage engine (you can change it in Configuration -> General)...
Follow @activecollab and activeCollab on Facebook.
avatar rblake Dec 3. 2007. 10:02 am #5
I was having the same problem. I changed the max_execution_time from 30 to 300 with no success, then I changed it to 6400 and the problem went away. If you are using IIS 6.x with the IIS lockdown tool, there is a setting that needs to be changed there as well otherwise IIS can timeout and cause errors.

Hope this helps. Here are all of the settings that I changed, which may or may not be relevant. These are on a windows machine running iis 5.0, but I believe the settings hold true for Apache installs as well. Make sure your restart your services after making the changes.

my.ini (Windows)
[mysqld]
max_allowed_packet = 100M

php.ini
:::Resource Limits:::
max_execution_time = 6400
max_input_time=60
:::Data Handling:::
post_max_size=100M
:::File Uploads:::
upload_max_filesize=100M
:::FOpen Wrappers:::
default_socket_timeout=6400
:::My SQL:::
mysql.connect_timeout=-1
[mysqld]
wait_timeout=1200000
max_allowed_packet=100M
avatar bmartinsen Dec 7. 2007. 9:47 am #6
Do you know:
What is the DEFAULT file upload size limit for activeCollab 0.7.1 ?
THANKS!