Log in

View Full Version : Attachment Size - MySQL Error


dseften
10-02-2006, 12:55 AM
Hi Everyone,

I've played around with my first and only forum for the past couple of weeks trying to figure out how to effectively increase the size for allowable attachments before submitting this post. I guess I'm getting mixed messages. On the welcome screen of the Vbul admin control panel, I notice...

PHP Max Post Size: 8.00 MB
PHP Max Upload Size: 5.00 MB

I've also gone into Attachment Manager and altered the maximum allowable sizes to...

Maximum Filesize: 2000000 (2MB) and
4000000 (4MB)

After having done so, I'm getting a vBulletin DB Error

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Date : Wednesday, September 27th 2006 @ 01:42:29 AM
Classname : vb_database

My users will routinely post large size pdfs so it is requirement I'm trying to fulfill. Is this a...

MySQL limitation;
PHP limitation;
vbulletin limitation;
knowledge limitation? ;)

Any help is greatly appreciated.

Best, Dave

Paul M
10-02-2006, 02:42 AM
That's a mysql error, not php, not any of the settings you have mentioned. The MySQL Packet Size is listed in the ACP under the two php values you have posted (after the mysql version).

dseften
10-02-2006, 11:15 AM
I see the MySQL Packet Size listed as you describe...

MySQL Packet Size: 1,023.0 KB

Do you know how to go about increasing the packet size?

Paul M
10-02-2006, 01:25 PM
It's set in the mysql config file - unless you are on a dedicated server and control that yourself, you would need to speak to your host.