Database error after uploading a attachment ( .mp3 )

[pxtek]

I m getting database error when i upload a mp3 attachment to my forum anyone have ideas? the file is 4 MB my server's php.ini is 20M so Im pretty sure I can upload that, and yes the .mp3 extension is added in the admin section for allowed attachments. any ideas? Thanks

[Steve Machol]

In addition to the vB settings, the allowed size of the attachments depends on the PHP and MySQL configuration. You may need to check and change the upload size for both PHP and for MySQL. Note, you'll need to have root access to the server to do this (or have your host do it.) Make these changes to php.ini:

upload_max_filesize = xM

..and my.cnf (or my.ini for Windows systems)

set-variable=max_allowed_packet=xM

Change it to the size ('x') you want in Megabytes. Restart the webserver and MySQL after making these changes.

Note: You may also need to increase the max_execution_time and max_input_time variables in php.ini.

Also you might want to take a look at this for other settings that affect file uploads:

http://www.vbulletin.com/forum/showpost.php?p=594570&postcount=12

http://www.vbulletin.com/forum/showthread.php?p=748319#post748319

[pxtek]

This is the screenshot of the error it might help with my attachment problem.


I believe this is not a server side error I've check with other vb forum I have in the same server, attachment works fine ( old version ). this is the upgraded version, just having few problems.


Btw Steve thank u very much steve for that problem I had eariler, I really appreciate your help.

[Steve Machol]

We would need to see that error message - at least the last 5 or 6 lines of it.

[pxtek]

Unfortunately, that's the most I can see, my IE and Firefox frozes, if I scroll down it frozes if I do anything to that screen it freezes, so thats the most I can give you unless you want to visit my website and try and upload a mp3 and see it yourself.

[pxtek]

Database error in vBulletin 3.5.1:Invalid SQL:INSERT INTO vb3_attachment (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)VALUES (1133074674, 1133074674, 1, 8236, 'mp3', 'bbqd.mp3', '623e0ad6832d6373395c2a71696a3dfb', '1227bbc51a1c7890a47480355a25fc7d', 2971191, 'ÿûp\0\0\0\0\0i\0\0\0\0\0\r À\0\0\0\0¤\0\0\0\0\04ƒ€\0\0LAME3.89 (beta)UUUUUUUUUUUUUUUUUUU and the random letters keep going on and on.. that's pretty much the errors I can grab.

[Steve Machol]

Unfortunately we need to see the end of the error message to know what the specific problem is.