what does this mean. database problem - Joomla! Forum - community, help and support


db function failed error number 1146
table 'dog.jos_session' doesn't exist sql=select session_id jos_session session_id = '7c55310ee80f62574796f64b9c17efbb'
sql =
select session_id
jos_session
session_id = '7c55310ee80f62574796f64b9c17efbb'


i needed install joomla on account client.  made database named "dog"  , ftp'd  joomla files (like had done many times before)

i had joomla on server.  , opened config file , made sure had right names in there did.

its on apache server.

thanks

lisa

it looks missing jos_sessions table in database....

backup databse first safe, run following phpmyadmin re-create tables...

create table `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`)
) type=myisam;





Comments