When Your Joomla jtablesession Crashed

If you are a Joomla user, I think you have experienced Joomla Database Error like shown below:

jtablesession::Store Failed
DB function failed with error number 145
Table ‘./joomla_database/jos_session’ is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`,`time`,`username`,`gid`,`guest`,`client_id`) VALUES (’1ecb458814b53d190db10cafee822dc0′,’1237429551′,”’0′,’1′,’0′);

No need to worry. Just relax and calm down. It’s easy to fix this problem.

All you need to do are:

1) Log in to your PHPMyAdmin.
2) Check jos_session (your table name might be different, depends on your table prefix, in this case I use jos) from your Joomla Database.
3) Select “Repair Table” from combo box below.
4) PHPMyAdmin will respond with a message that looked pretty happy.
5) Try to access your Joomla website.

Besides the way above, you can try another way, especially if you don’t have PHPMyAdmin. I assume you access MySQL from command line.

1) Log in to your MySQL.
2) Select your database (hint: use command use db_name)
3) Empty your jos_session table using: truncate jos_session.
4) Try to access your Joomla website.

Tags: database, joomla, mysql