Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago Sessions crash / no phpmyadmin
#1
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
For the first time ever, a system here is throwing this error:

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

There is no phpmyadmin on the associated machine, and it cannot be installed at this time.

Can anyone specify the exact procedure to clear the session table without phpmyadmin? Also, how can maintenance mode be entered before this process, when all attempts to access the board result in the same error? Thanks.
#2
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
It wouldn't matter if you cleared it, you need mysql access of some kind to repair the table. You can do it with the mysql commad line interface of phpMyAdmin (which I saw you cannot install). If you cannot use either of these, then you need to contact your host.
#3
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
Run This query in phpmyadmin;

PHP Code:
REPAIR TABLE `mybb_sessions`; 
#4
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
I have direct access to mysql on the host, but I need to know the proper command sequences. Thanks.
#5
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
log into it, and run the SQL Yaldarrm posted above on that table. Thats it.
#6
Solved: 3 Years, 5 Months, 1 Week, 5 Days, 19 Hours, 15 Minutes, 55 Seconds ago
Thanks. I also did manage to get phpmyadmin up, so everything should be easier in the future.


Forum Jump:


Users browsing this thread: 1 Guest(s)