Recreate the jos_session for Joomla script

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.

Be Sociable, Share!