Error with uploading vBulletin 3.8 avatars & pdf's???

[kellyandmark04]

I keep gettin an error tryin to upload a .gif

It says

database error 3.8.0

Invalis sql:
Update 413b2tcustomavatart SET

userid = 1
dateline = 1233555731
filename = filename.gif
width = 113
height = 104
filesize = 1401166

It says got a packet bigger than max allowed but I have it set to like 4 gigs for admins???


why can't I use it and keep gettin errors all the others work??? please help thanks

--------------- Added [DATE]1233556359[/DATE] at [TIME]1233556359[/TIME] ---------------

I'm checkin a few things to see if it works!!!

--------------- Added [DATE]1233557795[/DATE] at [TIME]1233557795[/TIME] ---------------

It says my sql error bigger than max allowed which is not true i have them set to 4gigs for admins.

I would paste the entire error, but it freezes my pc and I can't. Any help???

--------------- Added [DATE]1233559303[/DATE] at [TIME]1233559303[/TIME] ---------------

I just tried even externally hosting the images thru imageshack and photobucket neither work any ideas???

--------------- Added [DATE]1233559338[/DATE] at [TIME]1233559338[/TIME] ---------------

Can someone help???

[Marco van Herwaarden]

MySQL needs more memory, this is controlled from the MySQL configuration file, not the vB AdminCP.

Contact your host if you need assistence with this.

[kellyandmark04]

I contacted them this is the error

MySQL Error: Got a packet bigger than max allowed
Error Number:1153

Here was there response

I have addressed this to the server administrators and since the software for the forum is not ours and is vbulletin. As for the avatars, you may need to check their support forums and documentations as it could be a php_ini file that needs to be configured.

This error happens with any avatar over a couple megs and also .pdf files over a couple megs

Any suggestions???

[snakes1100]

This is not a memory issue with mysql, but a packet size error.

/etc/my.cnf
max_allowed_packet =

If you do not have root access to the server, the host would need to change that setting and allow a large packet.

You could cheat i guess and store your avatars & attachments in the file system, change the storage type for avatars & attachments in the admincp.

[kellyandmark04]

How do you allow a larger size packet???

I want everyone to be able to upload larger pdf's and files. Thanks for your help.

--------------- Added [DATE]1234252110[/DATE] at [TIME]1234252110[/TIME] ---------------

and I do have access to my forum root.

--------------- Added [DATE]1234254351[/DATE] at [TIME]1234254351[/TIME] ---------------

I see on my admin cp mysql is set to 1.0mb how do I change this???

[Voltar]

Originally Posted by kellyandmark04

How do you allow a larger size packet???

I want everyone to be able to upload larger pdf's and files. Thanks for your help.

--------------- Added Monday, 09 February, 2009 at 23:48:30 CST ---------------

and I do have access to my forum root.

--------------- Added Tuesday, 10 February, 2009 at 00:25:51 CST ---------------

I see on my admin cp mysql is set to 1.0mb how do I change this???

See my post here.