How to Solve a Problem with jos_session

. Posted in Joomla tips - Joomla beginners tips

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!

Want more information like this?

Subscribe to my weekly Joomla newsletter.

When you sign up, you'll get a FREE 52-page ebook: The best of Joomlablogger.net

Kristoffer Sandven, JoomlaBlogger Written on Friday, 10 July 2009 15:33
by

Viewed 11510 times so far.

Comment Rules: Critical is fine, but if you're rude, I'll delete your stuff. Please do not put your URL in the comment text unless it's relevant to the post and please use your PERSONAL name, blogger name or initials and not your business name, as the latter comes off like spam. Have fun and thanks for adding to the conversation!

blog comments powered by Disqus

Powered by Joomla

Joomlablogger.net is hosted by Rochen:

Rochen logo

Download Joomla for free