Some time we face the jos_session session corrupt error message at that time, we can recreate the “jos_session” table by running the following query from the phpmyadmin.
DROP table if exist `jos_session`
CREATE TABLE `jos_session` (
`username` varchar(150) 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′,
`client_id` tinyint(3) unsigned NOT NULL default ’0′,
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) TYPE=MyISAM CHARACTER SET `utf8`;
But make sure that you have taken the backup for the existing database.
NOTE : If you have any issue to copy the above query, please refer to the following URL to copy the jos_session table query.
http://www.theperfectarts.com/jos_session.txt
