Current time: 04-16-2014, 04:12 AM Hello There, Guest! (LoginRegister)


Session table is marked as crashed and should be repaired
06-04-2008, 12:16 PM
Post: #1
Session table is marked as crashed and should be repaired
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.
Find all posts by this user
06-04-2008, 12:22 PM
Post: #2
RE: Session table is marked as crashed and should be repaired
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]

Chris W. B.
Former MyBB Support & Software Quality Assurance Team
Twitter: @chriswb
Find all posts by this user
06-04-2008, 12:36 PM
Post: #3
RE: Session table is marked as crashed and should be repaired
Yeah I just managed to repair it using the repair feature on cPanel (got to love that software)
Find all posts by this user
06-05-2008, 03:02 AM
Post: #4
RE: Session table is marked as crashed and should be repaired
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
Visit this user's website Find all posts by this user
06-11-2008, 07:47 AM
Post: #5
RE: Session table is marked as crashed and should be repaired
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
Find all posts by this user
06-11-2008, 09:45 AM
Post: #6
RE: Session table is marked as crashed and should be repaired
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.
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication