Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-20-2009, 10:02 PM
cooltechie cooltechie is offline
 
Join Date: Apr 2004
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default check max_allowed_packet

How can one check the max_allowed_packet size without shell? Is it listed in cpanel or whm? Is there a php script that can provide that information?

We have this error:
filesize = 1154220
WHERE attachmentid = 16
mysql error: Got a packet bigger than 'max_allowed_packet' bytes
Reply With Quote
  #2  
Old 01-20-2009, 10:28 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Right in your adminCP you should see server stats

MySQL Packet Size
Reply With Quote
  #3  
Old 01-20-2009, 10:58 PM
cooltechie cooltechie is offline
 
Join Date: Apr 2004
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wow, that was easy. It's set to 1MB so maybe that is why there is problem. Is there a minimum requirement for vbulletin? Thanks for your help!
Reply With Quote
  #4  
Old 01-20-2009, 11:05 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cooltechie View Post
Wow, that was easy. It's set to 1MB so maybe that is why there is problem. Is there a minimum requirement for vbulletin? Thanks for your help!
No, but 1MB is really low, depending on the server and some settings such as attachment file sizes you may want to set it to something like 15MB
Reply With Quote
  #5  
Old 01-21-2009, 04:13 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you store attachments in the filesystem, you should not have any issues with such a low maximum packet size.
Reply With Quote
  #6  
Old 08-09-2009, 01:48 AM
Medtech's Avatar
Medtech Medtech is offline
 
Join Date: Oct 2007
Posts: 310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i am uploading 100 meg attachments.

to do this, create a php.ini file in your forum root. c/p this into it....
Code:
upload_max_filesize = 110M
post_max_size = 110M 
max_execution_time = 9960 
memory_limit = 116M
then go to attachment manager and increase the values for the type of attachments you want to upload.
Reply With Quote
  #7  
Old 08-09-2009, 07:51 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Medtech View Post
i am uploading 100 meg attachments.

to do this, create a php.ini file in your forum root. c/p this into it....
Code:
upload_max_filesize = 110M
post_max_size = 110M 
max_execution_time = 9960 
memory_limit = 116M
then go to attachment manager and increase the values for the type of attachments you want to upload.
Not all hosts allow "LOCAL" override of php master settings.
Reply With Quote
  #8  
Old 09-08-2009, 07:54 AM
Brother Malachi Brother Malachi is offline
 
Join Date: Jun 2008
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Medtech View Post
i am uploading 100 meg attachments.

to do this, create a php.ini file in your forum root. c/p this into it....
Code:
upload_max_filesize = 110M
post_max_size = 110M 
max_execution_time = 9960 
memory_limit = 116M
then go to attachment manager and increase the values for the type of attachments you want to upload.
That won't work.
You have to use .htaccess to change php.ini configs.
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 01:52 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.04087 seconds
  • Memory Usage 2,227KB
  • 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
  • (3)bbcode_code
  • (3)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