aC forum: Problem Uploading Files! MySQL? http://www.activecollab.com/forums/topic/2292/ Recent posts on topic: Problem Uploading Files! MySQL? en-us Sat, 30 Aug 2008 10:35:12 UTC http://www.activecollab.com/forums/post/11070/#post11070 http://www.activecollab.com/forums/post/11070/#post11070 Post #6 by bmartinsen bmartinsen Do you know:
What is the DEFAULT file upload size limit for activeCollab 0.7.1 ?
THANKS!

]]> Fri, 07 Dec 2007 15:47:12 UTC http://www.activecollab.com/forums/post/11004/#post11004 http://www.activecollab.com/forums/post/11004/#post11004 Post #5 by rblake rblake 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

]]> Mon, 03 Dec 2007 16:02:09 UTC http://www.activecollab.com/forums/post/10864/#post10864 http://www.activecollab.com/forums/post/10864/#post10864 Post #4 by Ilija Studen Ilija Studen 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)...

]]> Thu, 22 Nov 2007 22:50:32 UTC http://www.activecollab.com/forums/post/10863/#post10863 http://www.activecollab.com/forums/post/10863/#post10863 Post #3 by juamovi juamovi
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

]]> Thu, 22 Nov 2007 21:34:03 UTC http://www.activecollab.com/forums/post/10859/#post10859 http://www.activecollab.com/forums/post/10859/#post10859 Post #2 by Ilija Studen Ilija Studen 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).

]]> Thu, 22 Nov 2007 14:18:55 UTC http://www.activecollab.com/forums/post/10858/#post10858 http://www.activecollab.com/forums/post/10858/#post10858 Post #1 by juamovi juamovi 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

]]> Thu, 22 Nov 2007 13:00:07 UTC