MyBB Community Forums

Full Version: Sessions table always crash
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
[Image: s3hldx.jpg]
every single day this error appears and i have to repair from phpmyadmin.
is there any solution ? or should i make a little php script with cronjob
http://www.mybbcentral.com/thread-790.html

However you should really ask your host why this is happening so often as it shouldn't be.
sorry but mybbcentral has banned my country ips so no external links please Smile
Edit:
Checked mybbcentral with proxy
labrocca says use this sql query but
ALTER TABLE mybb_sessions ENGINE = memory
gives this error
#1114 - The table '#sql-348a_222d6' is full
Run this in phpMyAdmin:

ALTER TABLE `mybb_sessions` ENGINE = memory;
#1114 - The table '#sql-348a_222d6' is full
and host is mine.im running on dedicated server
If it's crashing so often and you manage the server it's something you'll need to sort out... if it's full you'd have to truncate it and log everybody out. How many records are in there exactly??
there is 29,891 records and 9.01 Mb size
sorry for this but "bump" this thread