Current time: 04-18-2014, 08:02 AM Hello There, Guest! (LoginRegister)


Sessions crash / no phpmyadmin
04-02-2011, 10:16 PM
Post: #1
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago Sessions crash / no phpmyadmin
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.
Find all posts by this user
04-02-2011, 10:23 PM
Post: #2
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago RE: Sessions crash / no phpmyadmin
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.

CodeWeavers - CrossOver: Windows Compatibility on Macintosh and Linux
[Image: Advocate_125.png]
Doesn't like unsolicited PMs
Find all posts by this user
04-02-2011, 10:31 PM
Post: #3
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago RE: Sessions crash / no phpmyadmin
Run This query in phpmyadmin;

PHP Code:
REPAIR TABLE `mybb_sessions`; 

[Image: 16mJ9bI]
MyBBsmsAPP | MyStatus | ProProfile
Visit this user's website Find all posts by this user
04-02-2011, 10:36 PM
Post: #4
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago RE: Sessions crash / no phpmyadmin
I have direct access to mysql on the host, but I need to know the proper command sequences. Thanks.
Find all posts by this user
04-02-2011, 11:22 PM
Post: #5
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago RE: Sessions crash / no phpmyadmin
log into it, and run the SQL Yaldarrm posted above on that table. Thats it.

CodeWeavers - CrossOver: Windows Compatibility on Macintosh and Linux
[Image: Advocate_125.png]
Doesn't like unsolicited PMs
Find all posts by this user
04-02-2011, 11:50 PM
Post: #6
Solved: 3 Years, 2 Weeks, 2 Days, 7 Hours, 50 Minutes, 5 Seconds ago RE: Sessions crash / no phpmyadmin
Thanks. I also did manage to get phpmyadmin up, so everything should be easier in the future.
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