REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 7 Vote(s) - 4.43 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Get rid of your session table crashing
#1
ALTER TABLE `mybb_sessions` ENGINE = memory

or for older versions of mysql

ALTER TABLE `mybb_sessions` ENGINE = heap

Run that in your phpmyadmin and change your mybb_sessions table into a memory based storage. This will prevent the table from crashing.

Thank you.
Reply
#2
* FirefoxWiz bookmarks this valuable piece of information.

Thanks!
Reply
#3
Thank you.

But I am getting this error

#1114 - The table '#sql-2474_10f1' is full

using

ALTER TABLE `mybb_sessions` ENGINE = memory
Reply
#4
This info is very old... it might have changed in the meantime.
German Translator. Probleme mit MybbCentral Plugins? Kontaktiert mich.
[Image: mybbaddonssignatur.gif]
Reply
#5
#1114 - The table '#sql-2474_10f1' is full

That's a different error. Does your host have a limit on your SQL usage?
Reply
#6
Nope. The size of the session table is 6 mb, do I need to empty it?
Reply
#7
Contact your host.
Reply
#8
When you mean alter do you mean rename? or what?
[Image: userbar.png]
Reply
#9
ALTER is a mysql command.
Reply
#10
Well I am not really sure where to run it in the beginning where I just come in phpadmin or inside mybbsessions itself.
*Edit* Never mind I just figured it out lol thanks for this Big Grin
[Image: userbar.png]
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  How to get rid of the "Thank you, your search has been submitted" Message StaticXNation 1 1,019 Aug 05, 2016, 11:46 AM
Last Post: iRocker
Question Problem with ficons ( table spacing ) chris1 4 2,030 May 31, 2013, 02:57 PM
Last Post: Xronize
  How to get rid of "Messages in thread" Pie 2 1,437 Dec 03, 2012, 11:51 AM
Last Post: Pie
  How to get rid of the default forum icons? Fishy 2 1,444 Nov 08, 2012, 04:03 AM
Last Post: Sparxgrafix.com
  Session Tables Richard 0 896 May 23, 2011, 07:29 AM
Last Post: Richard

Forum Jump:


Users browsing this thread: 1 Guest(s)