upload problem

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
selim

upload problem

Post 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', 'Ã
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Post 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.
atomoid
Posts: 108
Joined: 18 Aug 2005, 00:46
Location: santa cruz, ca

humm

Post 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]
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Re: humm

Post 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.
--
Glenn Henshaw Logical Outcome Ltd.
Mantis developer and user w: http://www.logicaloutcome.ca
tju
Posts: 5
Joined: 21 May 2008, 13:33

Re: upload problem

Post 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
Post Reply