Database error in vBulletin 4.2.3

[elsa23]

Hi, I can't load my board, I have this error :(
Please help me, thanks

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT IGNORE INTO elo4_session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('ef93ee3af8eaead6af57275082d78c20', 1500, '197.2.177.14', '3a2fbe7f957531d6f71e0e0238ce4f4c', 1506537570, '/login.php?do=login', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 0, 0, 0, '');

MySQL Error : The table 'elo4_session' is full
Error Number : 1114

MySQL Version : 5.5.57-0+deb7u1

[Stingray27]

You need to empty your sessions table.

How you do that is dependant on of you run your own server, or how you connect to your mysql server to make edits.

[elsa23]

I don't know how to do it :(

[TheLastSuperman]

I don't know how to do it :(

in phpmyadmin run the query:

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.

[elsa23]

Thank you very much, that solve it

Session Timeout is set to 3600
but i have a "AhrefsBot" that is always connected with a multitude of activities, i don't know how to remove it
After i have resolved my session issue with your query, i have already 10 AhrefsBot in who is online and will increases every minute

[TheLastSuperman]

Thank you very much, that solve it

Session Timeout is set to 3600
but i have a "AhrefsBot" that is always connected with a multitude of activities, i don't know how to remove it
After i have resolved my session issue with your query, i have already 10 AhrefsBot in who is online and will increases every minute

That bot is said to follow the "rules" when it comes to being block-able via robots.txt:
http://help.ahrefs.com/about-ahrefs/what-is-the-name-of-ahrefs-crawler-and-how-to-block-it-via-robotstxt

So block it in that file, give it a little time then check. Malicious/Spambots typically do not follow the rules set forth in robots.txt / Only legitimate bots of constructive use follow the rules of robots.txt per say. If the bot is crawling your site though for some form of online search (such as Googlebots) then you should leave it active and allow it to crawl your site, crawlers are usually fine and do not cause harm and if you fixed the session timeout then the session table should not be filling up again anytime soon! :D

[rekha]

after upgrade to 4.2.5 spam o matic not supported

is any one knows the solution pls let me know.

[Brandon Sheley]

after upgrade to 4.2.5 spam o matic not supported

is any one knows the solution pls let me know.

off topic for the thread but...

question and answer is very good is done well :up:

[RichieBoy67]

You can also change your max_heap_table_size. I wouldn't increase it much but it will help. This would be done in my.cnf.

[webmastersun]

Hi, I can't load my board, I have this error :(
Please help me, thanks

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT IGNORE INTO elo4_session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('ef93ee3af8eaead6af57275082d78c20', 1500, '197.2.177.14', '3a2fbe7f957531d6f71e0e0238ce4f4c', 1506537570, '/login.php?do=login', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 0, 0, 0, '');

MySQL Error : The table 'elo4_session' is full
Error Number : 1114

MySQL Version : 5.5.57-0+deb7u1

Faced this problem with my forum in the past because sometimes our forum has been overload with high traffic and sesstion table is full and mysql could not handle them.

The solution is you can enable Memcached on your server and use it for your vbulletin by enabling it in config.php from vbulletin.

In the other hands, you can use session memcached to manage session with memcached, that will not make your db overload sometimes which can cause that problem above.

Hope that helped.

[RichieBoy67]

A very simple way to empty the session table is go into the admincp and lower your session time under the cookies and http headers option or go into phpadmin and truncate the session table.