Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 11 Years, 7 Months, 1 Week ago [Error Message] SQL Error 145 [SOLVED]
#1
Solved: 11 Years, 7 Months, 1 Week ago
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?
#2
Solved: 11 Years, 7 Months, 1 Week ago
Admin CP > Tools & Maintenance > Task Manager > Tables Check.

And click the little clock.
#3
Solved: 11 Years, 7 Months, 1 Week ago
(2011-04-14, 06:59 PM)faviouz Wrote: 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..
#4
Solved: 11 Years, 7 Months, 1 Week ago
It should repair it, yes. However if it doesn't then you'll have to do it in phpMyAdmin.
#5
Solved: 11 Years, 7 Months, 1 Week ago
(2011-04-14, 06:59 PM)faviouz Wrote: Admin CP > Tools & Maintenance > Task Manager > Tables Check.

And click the little clock.


Thank you very much. It worked like a charm.
#6
Solved: 11 Years, 7 Months, 1 Week ago
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.
#7
Solved: 11 Years, 7 Months, 1 Week ago
(2014-06-17, 02:09 PM)HvK Wrote: 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`
Hey Everyone I am back! I will slowly be in progression of helping you all with your questions!


#8
Solved: 11 Years, 7 Months, 1 Week ago
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!


Forum Jump:


Users browsing this thread: 1 Guest(s)