jos_session::Store Failed

If you encounter error below due to upgrade

jtablesession::Store Failed
DB function failed with error number 1054
Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '70d78888785b2ec2840ba64eef9e2bf8','1233700284','','0','1','0' )

 

 

Remedy

Using phpmyadmin empty jos_session row.

Execute this statement in SQL area in phpmyadmin (inside joomla database)


CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

This will create the missing userid column (not exist in previous joomla version)

  • 28 Users Found This Useful
Was this answer helpful?

Related Articles

Joomla 1.0 & Php 5.3

Here is the story: if you happen to run Joomla! 1.0, which you should not. You will encounter...