Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Table VB Session full? Details »»
Table VB Session full?
Version: , by Amenadiel Amenadiel is offline
Developer Last Online: Apr 2015 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 05-20-2007 Last Update: Never Installs: 0
 
No support by the author.

I am happy that my forum has grown so much (currently 1 million posts, 20k users, and 1000 people online most of the time except for the weekends).

The problem is, I'm starting to have a recurrent problem, VB displays a database error which mess my template layout, and informs that table vb_session is full.

Currently I can solve it by manually (via phpmyadmin) emptying that table, but I'm sure that error shouldn't happen or does it?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 05-22-2007, 10:23 AM
Dark Zero's Avatar
Dark Zero Dark Zero is offline
 
Join Date: May 2002
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi hi
in the footer template you deleted this line?
Code:
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
    $cronimage
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
without that code the cron is uncapable of operate.
?what session timeout you use?

also check in the control panel->scheduled tasks for the hourly cleanups and view if are checked and operative (for more check about this also make a view in the task logs for that two)
in a normal operation the cron, exec the hourly cleanup, this delete the sessions with overtime and the active rows are limited to the concurrent users (or bots)
if this fails probably the sessions with overtime are not deleted and the heap table grow up to the memory limit assigned in mysql config.
Reply With Quote
  #3  
Old 06-28-2007, 04:20 PM
360themes 360themes is offline
 
Join Date: Feb 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dark Zero View Post
[b]Hi hi
in the footer template you deleted this line?
Code:
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
    $cronimage
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
Hey, I have the same problem too. So the solution is add your code into the footer templat, isn't it?

tks so much. it works!
Reply With Quote
Reply


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 10:13 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08623 seconds
  • Memory Usage 2,208KB
  • Queries Executed 16 (?)
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
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)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_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