Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-10-2009, 06:28 AM
kellyandmark04 kellyandmark04 is offline
 
Join Date: Jun 2007
Posts: 176
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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???
Reply With Quote
  #2  
Old 02-10-2009, 07:08 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You will need to ask your host to raise the limit in the MySQL configuration.
Reply With Quote
  #3  
Old 02-10-2009, 07:28 AM
kellyandmark04 kellyandmark04 is offline
 
Join Date: Jun 2007
Posts: 176
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 02-10-2009, 08:03 AM
Voltar Voltar is offline
 
Join Date: Mar 2006
Location: Bakersfield, California
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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>
Reply With Quote
  #5  
Old 02-10-2009, 08:38 AM
kellyandmark04 kellyandmark04 is offline
 
Join Date: Jun 2007
Posts: 176
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you for the help.

Where do i find

/etc/my.cnf
Reply With Quote
  #6  
Old 02-10-2009, 08:38 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kellyandmark04 View Post
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.
Reply With Quote
  #7  
Old 02-10-2009, 09:05 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 02-10-2009, 09:36 AM
Voltar Voltar is offline
 
Join Date: Mar 2006
Location: Bakersfield, California
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kellyandmark04 View Post
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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:54 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07100 seconds
  • Memory Usage 2,222KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete