Page 1 of 1
upload problem
Posted: 08 Jul 2005, 20:23
by selim
I set my upload limit to 5MB but every time I try to upload a lager file let's say 4MB I get this error. Does anyone now how I could fix the Problem?
APPLICATION ERROR #401
Database query failed. Error received from database was #1153: Got a packet bigger than 'max_allowed_packet' for the query: INSERT INTO mantis_bug_file_table
(bug_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)
VALUES
(396, '', '', '/www/mantis/htdocs/uploads/c0d4d441216494b673f50fa70cdf0d0a', 'intpack.msi', '/www/mantis/htdocs/uploads/', 4329472, 'application/octet-stream', '2005-07-08 22:10:16', 'Ã
Posted: 10 Jul 2005, 18:19
by thraxisp
MySQL has a setting for 'max_allowed_packet'. You probably need to add
max_allowed_packet=5M
to the mysqld section of your my.cnf and restart the server.
humm
Posted: 06 Apr 2006, 02:35
by atomoid
Im getting this same error as well, but the threshold is about 8mb, below that its fine. This used to work fine with 40+ mb attachments.
php.ini: post_max_size = 90M
php.ini: upload_max_filesize = 90M
my.cnf: max_allowed_packets = 90M
config_inc.php: $g_max_file_size = 90M
(yes, my $g_file_upload_method = DATABASE;)
Looked everywhere, cant figure it out, it used to work fine, any pearls of wisdom?
[Mantis 101, MySQL 4.0.25-standard, PHP Version 4.3.11]
Re: humm
Posted: 17 Apr 2006, 22:49
by thraxisp
atomoid wrote:Im getting this same error as well, but the threshold is about 8mb, below that its fine. This used to work fine with 40+ mb attachments.
php.ini: post_max_size = 90M
php.ini: upload_max_filesize = 90M
my.cnf: max_allowed_packets = 90M
config_inc.php: $g_max_file_size = 90M
(yes, my $g_file_upload_method = DATABASE;)
Looked everywhere, cant figure it out, it used to work fine, any pearls of wisdom?
[Mantis 101, MySQL 4.0.25-standard, PHP Version 4.3.11]
Have you restarted both MySQL annd Apache before testing this? I would expect that you are running out of memory when uploading the file. If the machine is hosting both processes, you will need to have lots of memory as the file will be buffered there at least twice before storing it in the database. If you are storing large files, I would consider using "DISK" as the storage media.
Re: upload problem
Posted: 21 May 2008, 15:10
by tju
I do have a similar problem.
Uploading a (binary) file with approx. 28M causes the page:
bug_file_add.php
to be shown with NO content (i.e. empty page) after upload has finished,
but no file has been uploaded.
I've configured DATABASE upload method and setup all required parameters in my.cnf and php.ini
Any help appreciated.
BTW: Mantis rel. 1.1.1