Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 Sep 2017, 18:44
elsa23's Avatar
elsa23 elsa23 is offline
 
Join Date: Dec 2014
Database error in vBulletin 4.2.3

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
sorry for my bad english
Reply With Quote
  #2  
Old 27 Sep 2017, 19:58
Stingray27 Stingray27 is offline
 
Join Date: Jan 2006
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.
Reply With Quote
  #3  
Old 27 Sep 2017, 20:48
elsa23's Avatar
elsa23 elsa23 is offline
 
Join Date: Dec 2014
I don't know how to do it
__________________
sorry for my bad english
Reply With Quote
  #4  
Old 27 Sep 2017, 21:13
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Cool

Originally Posted by elsa23 View Post
I don't know how to do it
in phpmyadmin run the query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
__________________
Daddy Does Dios and Figs!

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!

Last edited by TheLastSuperman; 27 Sep 2017 at 21:16. Reason: if --> is / correction
Reply With Quote
  #5  
Old 27 Sep 2017, 21:40
elsa23's Avatar
elsa23 elsa23 is offline
 
Join Date: Dec 2014
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
__________________
sorry for my bad english
Reply With Quote
  #6  
Old 27 Sep 2017, 21:47
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Originally Posted by elsa23 View Post
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/...-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!
__________________
Daddy Does Dios and Figs!

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
  #7  
Old 01 Oct 2017, 16:08
rekha rekha is offline
 
Join Date: Jan 2012
after upgrade to 4.2.5 spam o matic not supported

is any one knows the solution pls let me know.
Reply With Quote
  #8  
Old 04 Oct 2017, 10:56
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Originally Posted by rekha View Post
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
__________________

Love and support one another #vote2020
I offer Managed IT Services in Kansas
Reply With Quote
  #9  
Old 04 Oct 2017, 13:26
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #10  
Old 19 Oct 2017, 14:56
webmastersun's Avatar
webmastersun webmastersun is offline
 
Join Date: Oct 2013
Originally Posted by elsa23 View Post
Hi, I can't load my board, I have this error
Please help me, thanks


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
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.
__________________
The best webmaster forum & internet marketing forum for webmasters and internet marketers.
Reply With Quote
  #11  
Old 19 Oct 2017, 20:06
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.


Last edited by RichieBoy67; 17 Feb 2020 at 12:11.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 01:07.

Layout Options | Width: Wide Color: