Thread Rating:
  • 7 Vote(s) - 4.43 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Get rid of your session table crashing
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.
* FirefoxWiz bookmarks this valuable piece of information.

Thank you.

But I am getting this error

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


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

That's a different error. Does your host have a limit on your SQL usage?
Nope. The size of the session table is 6 mb, do I need to empty it?
Contact your host.
When you mean alter do you mean rename? or what?
[Image: userbar.png]
ALTER is a mysql command.
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]

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 2,575 Aug 05, 2016, 11:46 AM
Last Post: iRocker
Question Problem with ficons ( table spacing ) chris1 4 4,561 May 31, 2013, 02:57 PM
Last Post: Xronize
  How to get rid of "Messages in thread" Pie 2 3,272 Dec 03, 2012, 11:51 AM
Last Post: Pie
  How to get rid of the default forum icons? Fishy 2 3,328 Nov 08, 2012, 04:03 AM
Last Post:
  Session Tables Richard 0 2,005 May 23, 2011, 07:29 AM
Last Post: Richard

Forum Jump:

Users browsing this thread: 1 Guest(s)