vb.org Archive - Table VB Session full?

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

- Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)

- - Table VB Session full? (https://vborg.vbsupport.ru/showthread.php?t=147661)

Amenadiel

05-20-2007 12:37 AM

Table VB Session full?

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?

Dark Zero

05-22-2007 10:23 AM

Hi hi :D
in the footer template you deleted this line?

Code:

 $cronimage 

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.

360themes

06-28-2007 04:20 PM

Quote:

Originally Posted by Dark Zero (Post 1252619)

[b]Hi hi :D
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!

All times are GMT. The time now is 09:12 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00912 seconds Memory Usage 1,714KB 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_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: