vb.org Archive - MySQL Packet Size 1.00 MB How do I change this???

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

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

- - MySQL Packet Size 1.00 MB How do I change this??? (https://vborg.vbsupport.ru/showthread.php?t=204856)

kellyandmark04

02-10-2009 06:28 AM

MySQL Packet Size 1.00 MB How do I change this???

MySQL Packet Size 1.00 MB vBulletin 3.8 How do I change this???

Please help step by step instructions please as I'm not familiar with this???

Marco van Herwaarden

02-10-2009 07:08 AM

You will need to ask your host to raise the limit in the MySQL configuration.

kellyandmark04

02-10-2009 07:28 AM

I have they said it is in the vbulletin files???

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

Even have it posted here and another member says the same

https://vborg.vbsupport.ru/showthread.php?t=203892

Voltar

02-10-2009 08:03 AM

If you have root access to the server, you need to change a value in /etc/my.cnf. That is the way to change the packet size. Either you or your host will have to do this.

Look for a directive called "max_allowed_packet" and set it to whatever you desire. It'll be under the [mysqld] configuration.

For example, this is taken from one of my servers

Code:

[mysqld]

<snip>

max_allowed_packet=24M

<snip>

http://img21.imageshack.us/img21/696/asdfev1.png

kellyandmark04

02-10-2009 08:38 AM

Thank you for the help.

Where do i find

/etc/my.cnf

Dismounted

02-10-2009 08:38 AM

Quote:

Originally Posted by kellyandmark04 (Post 1739513)

I have they said it is in the vbulletin files???

The Packet Size is a MySQL Server Setting. It cannot be changed from inside vBulletin.

Marco van Herwaarden

02-10-2009 09:05 AM

Please don't start a new thread for the same issue. Your question have been answered a few times now, always with the same answer, but you keep repeating your question without listenening to the answers already given.

Your problem is caused by a low limit in the MySQL configuration. This can not be changed from vBulletin, but your host must change the MySQL configuration.

If your host claims something else, they obviously don't know what they are doing and you should consider a different host.

Voltar

02-10-2009 09:36 AM

Quote:

Originally Posted by kellyandmark04 (Post 1739539)

Thank you for the help.

Where do i find

/etc/my.cnf

If you don't know by looking at that, then point your host to this thread. You need root level access to the server operating system to modify that file and restart the MySQL daemon.

All times are GMT. The time now is 03:14 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01975 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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: