Sometimes, you might experience your Joomla session tables 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.

That's it ;)

 

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

Viewed 3639 times so far.
Like this? Tweet it to your followers!

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