PDA

View Full Version : Table VB Session full?


Amenadiel
05-20-2007, 12:37 AM
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?

<!-- 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.

360themes
06-28-2007, 04:20 PM
[b]Hi hi :D
in the footer template you deleted this line?

<!-- 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!