MySQL ERROR:
Error Number: 1194
Description: Table ‘exp_sessions’ is marked as crashed and should be repaired
Query: DELETE FROM exp_sessions WHERE last_activity < 1247737093
What to do?
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
July 16, 2009 10:53am
Subscribe [3]#1 / Jul 16, 2009 10:53am
MySQL ERROR:
Error Number: 1194
Description: Table ‘exp_sessions’ is marked as crashed and should be repaired
Query: DELETE FROM exp_sessions WHERE last_activity < 1247737093
What to do?
#2 / Jul 16, 2009 10:56am
Do you have something like PHPMyAdmin where you can repair a table?
#3 / Jul 16, 2009 11:04am
Yes.
#4 / Jul 16, 2009 11:05am
Have you tried doing a repair of the table?
#5 / Jul 16, 2009 11:07am
Is there a specific “thing” to do related to EE functionality. Or it is standard procedure.
#6 / Jul 16, 2009 11:14am
Thanks i worked it out. CP panel helps a lot:)))
#7 / Jul 16, 2009 11:15am
This is a general database issue and only related to EE insofar as EE uses the database. So there is noting to do on the EE side of things.
#8 / Jul 16, 2009 11:17am
When you get an error that tells you that a table needs to be repaired, you just do it. Occasionally is just happens.
However, I should have pointed out that you can repair inside of EE too.
Admin › Utilities › SQL Manager › Manage Database Tables
Check the table to be repaired, and look at the bottom right hand corner for a drop down list to repair.
#9 / Jul 16, 2009 11:48am
Yes, thats why i pay:))
Thanks a lot for support.
You are the best.
#10 / Jul 16, 2009 11:55am
Thanks for the complements. 😊 Don’t hesitate to post again as needed.