|
Please help.
This seems to be an old problem but all the fixes I've found have failed to work for me.
I get the following error when I try to open my site.
jtablesession::store failed
DB function failed with error number 1146
Table 'deals1.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a7stip35jv86ihcvkeggr4vca1','1339754974','','0','1','1' )
Some of the fixes I've found in the forum required running the following script to restore jos_session;
#
# Table structure for table `jos_session`
#
DROP table IF EXISTS 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`;
#
# Dumping data for table `mos_session`
#
I have run this script and it came close as I can now open my administrator page but I still get the following error while I am unable to log on as an administrator:
Error loading Plugins: Table 'deals1.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
Error loading Plugins: Table 'deals1.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
Error Loading ModulesTable 'deals1.jos_modules' doesn't exist SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 1 ORDER BY position, ordering
Error loading Plugins: Table 'deals1.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
I am an apprentice joomla user and have spent the past 2 days going through forums and trying out fixes, I really will appreciate urgent expert help at this point as my site as been down for too long
|
