wmv upload, database error

[SpeakeasyMedia]

I just added wmv to the file extensions users can upload, and set the max size to 4 MB. When I tested it with a 2 MB file, I got a database error message.

<!-- Database error in vBulletin 3.6.8: Invalid SQL: INSERT INTO attachment (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata) VALUES (1206887024, 1206887024, 1, 3, 'wmv', [attachment name]

I've tried it several times with the same result, and attaching other file types works fine. What did I do wrong?

[MiahBeSmokin420]

go to the main page of your acp

there should be like 4 columns

the one on the left should say something like php upload size

make sure that is larger then the size of the fie you are uploading

if it is not the you need to change that and to do that you need to edit your httaccess file

i got to go hope that helps

[Opserty]

Please post the complete error message. Edit it out any long pieces of text. Also ensure that you post the bit which says "MySQL error:"

[SpeakeasyMedia]

Here is the message:

<!-- Database error in vBulletin 3.6.8: Invalid SQL: INSERT INTO attachment (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata) VALUES (1206900331, 1206900331, 1, 3, 'wmv', 'Greatest_Movie_Line_Ever.wmv', 'e48208662d9c449c6051ad396e52fe1a', '81d4b948778eb0f4d5336d5cd87fbf69', 1113146,

[thousands of characters of gobbledygook]

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes Error Number : 1153 Date : Sunday, March 30th 2008 @ 02:05:31 PM Script : http://www.therealnicaragua.com/vb/forums/newattachment.php?do=manageattach&p= Referrer : http://www.therealnicaragua.com/vb/forums/newattachment.php?f=2&poststarttime=1206900215&posthash=e48208662d9c449c6051ad396e52fe1a IP Address : 75.92.125.228 Username : John Classname : vB_Database -->

[Dismounted]

That means that the attachment you have uploaded is bigger than the size MySQL can accept. You can either store attachments in the file system, or increase the packet size in the MySQL configuration file.

[Medtech]

I store attachments in my file system, have my php set for 1 gig. all my other file size settings are at 1 gig. i can upload a 16 meg file just fine, 17 meg errors out. you should be able to do the same.