Session table is marked as crashed and should be repaired
#1
I am getting this error over and over again my forum is totally down atm:

Quote:MySQL error: 145
Table './rootforu_forum/mybb_sessions' is marked as crashed and should be repaired
Query: SELECT * FROM mybb_sessions WHERE sid='73bc9dbecbab357dc2ca7a54fb410f09' AND ip='XX.XX.X.XXX' LIMIT 1

(I censored my IP adress)

I tried the repair.php provided here:
http://community.mybboard.net/showthread.php?tid=22002

But it gives the same error:
http://www.rootforum1.com/repair.php

Please tell me what to do I got 1000 people waiting to get back on my board.
#2
Hi,

Please try the following:

Open phpMyAdmin (the software that you use to mange your database) > Select your database (e.g.: "mybb") > Scroll to the bottom of the page on the right, click "Check all" and then from the pull down box (should be to the right) that says "with selected" select "repair table".

It should then run and correct your problem.

[Image: attachment.php?aid=8488]

#3
Yeah I just managed to repair it using the repair feature on cPanel (got to love that software)
#4
If this occurs again, phpMyAdmin would be a safer alternative. If you have SSH access, using it to repair the database would be just as effective and probably much quicker since it's not a web interface.
- Jon T. & Kim B.
- AirborneFive Co-Owner's
- Optimized Web Hosting Solutions | Starting @ Only $2/mo
- First Month of Service Free! | Coupon: FIRSTMONTHFREE
#5
I've also had this problem several times in the past few days. The tables marked as crashed are sessions and threadsread. I repair them each time via phpMyAdmin and then all's ok for a while but the problem eventually recurs. Any ideas?

MyBB version: 1.2.13
PHP version: 5.2.6
DB version: MySQLi 5.1.24
#6
You should contact your host with these issues as it is a problem with their servers (and we can't do anything about it).

Changing the table type to HEAP tables may help.


Forum Jump:


Users browsing this thread: 1 Guest(s)