How to fix jos_session error in Joomla PDF Print E-mail
User Rating: / 9
PoorBest 

If you Joomla root site show this error :

mossession::store failed
DB function failed with error number 1034
Incorrect key file for table 'jos_session'; try to repair it SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3fb0665c11671cb724b8fd4f37439d6f','1187102382','','0','1' )

The message show error in "jos_session" table and this table located at your joomla database at phpMyAdmin.

http://i270.photobucket.com/albums/jj97/zool_85/sql4.jpg

You can fix your "jos_session" table by running some Mysql code. Here is the step :

 

Open your Cpanel, at the databases sub menu, click on phpMyAdmin. On the phpMyAdmin interface, select the Joomla database that the problem occurs. Example, if the error of your main site comes from Joom1 database, select joom1.

http://i270.photobucket.com/albums/jj97/zool_85/sql5.jpg

On default display when you choose your database, it will display the "structure" tab content, then open the SQL tab like figure below:

http://i270.photobucket.com/albums/jj97/zool_85/sql1.jpg

On the Run SQL query/queries blank form, copy paste this code:

DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE IF NOT EXISTS `jos_session` (
  `username` varchar(50) default '',
  `time` varchar(14) default '',
  `session_id` varchar(200) NOT NULL default '0',
  `guest` tinyint(4) default '1',
  `userid` int(11) default '0',
  `usertype` varchar(50) default '',
  `gid` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

Then, click GO button to execute it

http://i270.photobucket.com/albums/jj97/zool_85/sql2.jpg

Click OK if you really want to execute this command.

If the code work successfully, this figure below will show the message "Your SQL query has been executed succesfully.

http://i270.photobucket.com/albums/jj97/zool_85/sql3.jpg


 

Comments  

 
0 #4 k-vd 2011-12-19 12:39
Or just run: "REPAIR TABLE jos_session;"
Quote
 
 
0 #3 Jap 2011-10-28 18:50
Thatnks with the comment of Santiago it really worked...
Quote
 
 
0 #2 Santiago 2011-08-25 20:25
this is not complete. after running the sql that you provided it´s necessary the following steps, at least whis solution works perfect with my site. Here is
Via phpmyadmin, look into the table jos_session a row with "client_id".
If it does not exist, create a new field with the following values:

* Field: client_id
* Type: tinyint
* Length; 3
* attributes: unsigned
* null: not null
* default: 0
* The remaining 2 fields must be empty
Quote
 
 
0 #1 Santiago 2011-08-25 20:24
this is not complete. after running the sql that you provided it´s necessary the following steps, at least whis solution works perfect with my site. Here is
Via phpmyadmin, look into the table jos_session a row with "client_id".
If it does not exist, create a new field with the following values:

* Field: client_id
* Type: tinyint
* Length; 3
* attributes: unsigned
* null: not null
* default: 0
* The remaining 2 fields must be empty
Quote
 

Add comment


Security code
Refresh

 

Custom Search

 

Main Menu

Donate To Us

Bookmark Us

Facebook MySpace Twitter Digg Delicious Stumbleupon Google Bookmarks RSS Feed 

Related Links

Song Download for Free at MP3 Downloads Website