[Error Message] SQL Error 145 [SOLVED]

[Mikhos]

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
145 - Table './surviv78_Forums/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE uid='3'


This happened yesterday on my forums. I haven't made any changes to the board itself, so I was wondering if I could fix this?

[faviouz]

Admin CP > Tools & Maintenance > Task Manager > Tables Check.

And click the little clock.

[Disturbed]

Admin CP > Tools & Maintenance > Task Manager > Tables Check.

And click the little clock.

Does that actually repair the table?

I thought that always had to be done in phpmyadmin..

[faviouz]

It should repair it, yes. However if it doesn't then you'll have to do it in phpMyAdmin.

[Mikhos]

Admin CP > Tools & Maintenance > Task Manager > Tables Check.

And click the little clock.

Thank you very much. It worked like a charm.

[HvK]

Hello,

I'm experiencing the same problem, that is, SQL Error 145.

But the solution provided above is not available as I can't log in admin mode, I only get the SQL Error message without being able to do anything.

Thanks,
Hans.

[VoIP]

Hello,

I'm experiencing the same problem, that is, SQL Error 145.

But the solution provided above is not available as I can't log in admin mode, I only get the SQL Error message without being able to do anything.

Thanks,
Hans.

It's not a good idea to hijack someones thread, but you're new so I will help.

The solution is go into PHPmyadmin, and then execute the query:

REPAIR TABLE `mybb_tablename`

[HvK]

Thanks, sorry, wasn't aware, nor did I intent to hijack anything as it's exactly the same problem. Thanks for the solution, that worked!