MyBB Community Forums
[Error Message] SQL Error 145 [SOLVED] - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Error Message] SQL Error 145 [SOLVED] (/thread-92229.html)



SQL Error 145 [SOLVED] - Mikhos - 2011-04-14

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?


RE: SQL Error 145 - faviouz - 2011-04-14

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

And click the little clock.


RE: SQL Error 145 - Disturbed - 2011-04-14

(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..


RE: SQL Error 145 - faviouz - 2011-04-14

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


RE: SQL Error 145 - Mikhos - 2011-04-14

(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.


RE: SQL Error 145 [SOLVED] - HvK - 2014-06-17

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.


RE: SQL Error 145 [SOLVED] - VoIP - 2014-06-17

(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`



RE: SQL Error 145 [SOLVED] - HvK - 2014-06-17

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!