MyBB Central
Get rid of your session table crashing - Printable Version

+- MyBB Central (http://www.mybbcentral.com)
+-- Forum: Mybb Central General Discussions (http://www.mybbcentral.com/forum-1.html)
+--- Forum: Mybb General Support Help (http://www.mybbcentral.com/forum-6.html)
+--- Thread: Get rid of your session table crashing (/thread-790.html)

Pages: 1 2


Get rid of your session table crashing - labrocca - Dec 29, 2007

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.


RE: Get rid of your session table crashing - FirefoxWiz - Dec 30, 2007

* FirefoxWiz bookmarks this valuable piece of information.

Thanks!


RE: Get rid of your session table crashing - sadiqsaad - Jul 14, 2009

Thank you.

But I am getting this error

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

using

ALTER TABLE `mybb_sessions` ENGINE = memory


RE: Get rid of your session table crashing - LS 134 - Jul 14, 2009

This info is very old... it might have changed in the meantime.


RE: Get rid of your session table crashing - labrocca - Jul 14, 2009

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

That's a different error. Does your host have a limit on your SQL usage?


RE: Get rid of your session table crashing - sadiqsaad - Jul 18, 2009

Nope. The size of the session table is 6 mb, do I need to empty it?


RE: Get rid of your session table crashing - labrocca - Jul 18, 2009

Contact your host.


RE: Get rid of your session table crashing - Eugene - Mar 31, 2010

When you mean alter do you mean rename? or what?


RE: Get rid of your session table crashing - labrocca - Mar 31, 2010

ALTER is a mysql command.


RE: Get rid of your session table crashing - Eugene - Mar 31, 2010

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