Webhosting Blog

Mysql Error


Sometimes your site may start displaying error as follows.

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

If you receive any such error just try to repair the corresponding database related to the site.

You can follow following steps in order to repair the database.

  1. Login to  your cPanel >> Databases >> phpMyAdmin
  2. Choose the affected database from the available list.
  3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
  4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table

Also you can do a repairing through  cPanel if you are not phpmyadmin friendly.

1) Go to cPanel >> Databases >> Mysql Databases

2) In Modify Databases section you can find Repair DB drop down.  Select Appropriate DB and click repair.

The database is repaired and the site is back to normal!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s