vb.org Archive - Error with uploading vBulletin 3.8 avatars & pdf's???

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Error with uploading vBulletin 3.8 avatars & pdf's??? (https://vborg.vbsupport.ru/showthread.php?t=203892)

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

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???

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.

I contacted them this is the error

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

Here was there response

Quote:

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???

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.

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???

Quote:

Originally Posted by kellyandmark04 (Post 1739431)

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01802 seconds Memory Usage 1,724KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: