Posts: 4,308
Threads: 223
Joined: Sep 2006
Reputation:
320
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.
Posts: 150
Threads: 58
Joined: Nov 2006
Reputation:
10
* FirefoxWiz bookmarks this valuable piece of information.
Thanks!
Posts: 267
Threads: 36
Joined: Mar 2008
Reputation:
1
Thank you.
But I am getting this error
#1114 - The table '#sql-2474_10f1' is full
using
ALTER TABLE `mybb_sessions` ENGINE = memory
Posts: 142
Threads: 15
Joined: Oct 2008
Reputation:
0
This info is very old... it might have changed in the meantime.
German Translator. Probleme mit MybbCentral Plugins? Kontaktiert mich.
Posts: 4,308
Threads: 223
Joined: Sep 2006
Reputation:
320
#1114 - The table '#sql-2474_10f1' is full
That's a different error. Does your host have a limit on your SQL usage?
Posts: 267
Threads: 36
Joined: Mar 2008
Reputation:
1
Nope. The size of the session table is 6 mb, do I need to empty it?
Posts: 257
Threads: 44
Joined: Oct 2009
Reputation:
9
When you mean alter do you mean rename? or what?
Posts: 4,308
Threads: 223
Joined: Sep 2006
Reputation:
320
ALTER is a mysql command.