Error when loading large attatchment

[bglynn]

When I try an attatchment more than 10MB or so, the upload page goes blank after a few min of uploading, and I get a huge email with an error and the attachment sent back:

Invalid SQL:
INSERT INTO attachment
(userid, dateline, filename, filedata, filesize, visible, filehash, posthash, thumbnail, thumbnail_dateline, thumbnail_filesize)
VALUES
(3, 1102685292, 'musclebossanova.wmv'

[Steve Machol]

First, check your attachment size setting in the Admin CP and make sure it's large enough. If that is fine, then you need to change the upload size for both PHP and for MySQL. You need to have root access to the server to do this. Make these changes to php.ini:

upload_max_filesize = xM

..and my.cnf

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

[bglynn]

Thank you!

[bglynn]

OK, I'm on a new box, and I'm having this problem again. I have gone through all the settings mentioned in this thread and the links provided - yet it still happens - help!

[Steve Machol]

Those are all the settings I know of that will affect file uploads. How large is this file?

[bglynn]

Well, I have used several test files. Everything up to about 16MB works, fine.

[Steve Machol]

Then realistically that is your upper limit.

[bglynn]

Yes...but on my old box, it wasn't, it was 200. I have set everything back to 200, I just don't know what I'm missing - obviously something is still limiting me.

[bglynn]

bump

[Steve Machol]

Sorry but I have already posted all the settings I know of that would affect this.