MP3 Uploads

[ethank]

I have one user who is getting database errors when he tries to upload an MP3

Database error in vBulletin: Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,visible) VALUES (NULL,5,990759186,'tusksalty84.mp3','ÿóp|\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0´>'É$nOûzÚásÒ18bâ³\0\0\0"!"dÓ³É"Cû&L\'o{î0ÀD{?»
¬
 e\\Ý7pæF^^Nî.r÷\0\0N,Ð \0¿^UÑ @
\\DáþçSô/âÿýâ!{-h\0GÇÁÏZXÏÁßÿÿ&\0t¦Û'N¹¢?¿ö8·ëYñóY!?B>YáÅÿór|¡Ayjß$Ã]S
2ÑvÄrð??,
Zèä!­¶â§Ä@.%>"¦eIm§vѼåöÊÿGBiú¯´µ)\\I¿Ú»ùäüæ"ÒWAZÚ\0$ø?*ZÈWý~¿¤äm¶ç?Ôò'¢Ò1Æ'& ,g4Êyá£?Î S¸ó²Á5Õ.êv½ZI¾ß

and it goes on

I didn't get an error, but a large file didn't show up. A small one showed up fine.

Ethan

[Mike Sullivan]

We need to see the end of the error message to be able to do troubleshooting.

[ethank]

82 2001Made with RealJukebox (tm) ÿ','1')
mysql error: MySQL server has gone away
mysql error number: 2006
Date: Thursday 24th of May 2001 08:33:15 PM
Script: /newthread.php
Referer: http://tony.murmurs.com/newthread.ph...ead&forumid=66

THe value of php.ini for upload size is 10M (10 megs). I haven't changed packet size in MySQL if that is the other step to take.

Ethan

[Mike Sullivan]

That's the other step to take -- you can confirm that it is if you look in your MySQL error log. It should basically tell you that's what you need to do

[ethank]

Should I set the mysql max packet size to 10M as well?

EThan

[Mike Sullivan]

I would assume so -- I've never really played with that option.

[ethank]

That appears to have worked. There goes my disk space!

Ethan