Database error in vBulletin 4.2.3

[TheLastSuperman]

Originally Posted by elsa23

I don't know how to do it

in phpmyadmin run the query:

PHP Code:

TRUNCATE TABLE elo4_session; 


That will clear your session table, please note those logged-in at said time will be automatically logged out when you truncate the table.

What you need to find out is WHY the session table is full, it should not be if cron (scheduled tasks) jobs are running properly.

*If you've set your "Session Timeout" too high it will cause this to happen and it can hinder proper use of your site - you can check via:
AdminCP > Settings > Options > Cookies and HTTP Header Options
Check the very first setting:

Session Timeout
This is the time in seconds that a user must remain inactive before their login session expires. This setting also controls how long a user will remain on Who's Online after their last activity.

^ Is it set to 900 or have you changed it from the default? You cannot set this very high without a custom plugin in place to sort the issue. For example if you wanted your users to stay logged in for 7 days, that is tooooo high it will cause issues. I'd say keep them logged in no more than 1hr tops and so you know the default 900 setting = 15mins so 1800 = 30mins and so on.