Menu
     

How to Solve a Problem with jos_session

How to Solve a Problem with jos_session

Sometimes, you might experience your Joomla jos_session table going out of wack. This may result in your website displaying nothing but an error message.

Relax, I'll show you how to fix it!

I found a message saying something like this at the Joomla! forums:

My site is hosted through Yahoo! I use Joomla 1.5 and now my site is down and I get this error message:

jtablesession::Store Failed
DB function failed with error number 1016 Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '4bc998b10d92bf4107976d0edacdbb26','1246725653','','0','1','0' )

My answer was:

If you have access to phpmyadmin, go to the Joomla database, select the table jos_session (tick the checkbox) and choose "Repair table" from the drop-down you find at the bottom of the list of tables. This has worked for me.

Step-by-step instructions

1. Log in to phpmyadmin on your database server

2. Go to the Joomla tables list for the database of your web site (select the database name in the left column drop-down menu)

3. Click the checkbox next to the jos_session table name (fig. 1)

jos-session-repair-1
Fig. 1: Select the jos_session table

4. At the bottom of the table, click 'Repair table' in the drop-down 'With selected' (fig. 2).

jos-session-repair-2
Fig. 2: Click 'Repair table' in the drop-down

5. Your table is repaired (fig. 3)

jos-session-repair-3
Fig. 3: Your table is repaired

This should solve the problem. However, sometimes this problem is caused by an extension or something else in your Joomla installation or on your server. Thus, the problem can reappear if you don't find the source of the problem. Sometimes I've had this happen because of spikes in traffic, though. In that case, you should monitor your site and perhaps invest in a service like Pingdom to keep track of uptime.

Good luck!

Read 48516 times Originally published on Friday, 10 July 2009 16:33
Last modified on Wednesday, 13 May 2015 23:14
 
© 2008 - 2025 Joomlablogger.net / iSee Communications as, Oslo, Norway.

Joomlablogger.net is not affiliated with or endorsed by The Joomla! Project™. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.

Free Joomla SEO Course

Get a Free 10 week SEO course by email. Useful, hands-on tips you can use now. The course starts today and you'll receive one email every week.
Powered by Kit