DB function failed with error number 145

Filed in Joomla, Linux

If you ever faced the below error

 

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′);

Error message above usually happens to CMS Joomla. One of Joomla tables jos_session (the table name depends on prefix) is crash. It’s `very easy to overcome this problem. Just truncate the table jos_session. SQL command:

mysql> truncate jos_session;

Or

mysql> repair table jos_session;

You can always check the table ‘health’ by running the command:
check table jos_session

Done !!

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *