Saturday, April 4, 2015

Joomla: Session is marked as crashed and should be repaired

"Error displaying the error page: Application Instantiation Error: Incorrect key file for table"
https://www.ostraining.com/blog/joomla/joomla-session-crashed/


The image below shows an error message that sometimes occurs on Joomla sites:
media_1392927442608.png
The message is actually fairly clear once you know what to look for.
The message says that one of your database tables has crashed. It says that the solution is repair that table.
Which table do we need to repair? The message above reads: Table './nass_j25testdb/usjbr_session
This contains two pieces of information:
  • Our database name is nass_j25testdb
  • Our database table is usjbr_session
That's the solution: we need to find the database called nass_j25testdb and repair the table called usjbr_session.

Repairing a database table

Login to your hosting account.
We need to find our "MySQL Databases". In this example, the link is marked below.
media_1392927526696.png
One very easy solution here is the "Modify Databases" option.
  • Look for the Repair DB option.
  • Choose the nass_j25testdb.
  • Click the Repair DB button.
media_1392927571735.png
You'll now see a series of messages. One of those will probably say that your _session had a problem that has now been fixed:
media_1392927655105.png
Your site should now be back online.

An alternative solution

Here's another way to solve this problem.
Many hosting companies will give you direct access to the database via phpMyAdmin. You can see a sample link below:
media_1392928320325.png
Find your database on the left of the page:
media_1392928412468.png
Check the box next to your _session table.
Choose the Repair table option at the bottom of the page.
media_1392927738255.png
You'll get a message saying that your SQL query has been executed successfully. Your site should now be back online.
media_1392927834607.png

0 comments:

Post a Comment