Support

Dear friends:

Finally could restore the backup. But cant start the website getting the following database error:

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

Please help!

Thank you very much.

Jonathan

Jonathan,

It looks like an error in the creation of the session table. The good news is that I'm pretty sure we can drop that table and recreate it. It sticks in my mind that there was a Joomla! bug involving that table a while back. I need Nicholas to look at this to make sure I'm right.

Dael

Dear Dale!

Thank you very much. It must be an error in joomla due to the fact that all the other tables have been restored perfectly. I am pretty und pressure with this site and beleive me I am going cracy. I would highly appreciate if Nicolas could take a look on that. Go to www.uncli.org and you will see the error message. A donation will be guerranteed by my friends who run the web!

Thanks a lot.

Yours Jonathan

If you're in a jam, you can drop the table and recreate it, but I would really like to wait for Nicholas on this.

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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Dale

Dear Dale:

As this is very important I agree to wait for Nicolas. I am not experienced in SQL and so far your support is higly appreciatet. Anyhow I am very happy with JoomlaPack which means a milestone in Joomla for me.

Thank you so much.

Sincerely Yours
Jonathan

Dear Nicolas:

First of all thank you very much for your help. I am trying to do as you recommanded. I let you know about the results!

Thank you.

Jonathan

Hallo Dale and Nicolas:

I am back to the board. Had an accident and was hospitalized. Since today at home and back to my DB problem! So now I did what you recommended and IT WORKED! You are great people and I realy apreciate your support! Let me know where to send a donation!

Yours Jonathan!

Jonathan,

A hospital is a terrible place to spend time, especially when you're not feeling well. I was in for a week in December. They seemed to have a goal of waking me up every half hour between 2 am and 7 am. They very rarely missed. :x At least mine was by choice (transplant). Take care of yourself.

I'm glad you got the site working.

Dale

Hi champs,

I need a help here. I have searched and came across one of your forums that it may be similar to my issue about "unknown column" and "jos_session"

I have site on Joomla CMS for long while until I got email from hosting provider saying they have upgraded to PHP 5.3 and MySQL 5.1 on new Linux/cPanel servers and said that the older version of Joomla my be affected which need upgrade version. So I did tried to upgrade (after backups done on site and DB) via Softaculous but made a mistake as was using Joomla 1.7 instead of Joomla 1.5 which didn't work. So I got the back up done on site and database.

Before I could even upgrade to 1.5.23, I got this message on both site (index.php) and CMS (/administrator/index.php) as follows -

Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('fa0b834af10b6c9a8743e82e447e4f49', 0, 1317292656)

So havig searched the internet and came across to this forum page discussion and said to fix this is to drop the table and recreate it.

So I got the code from your page as follows:

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`) );

Are they right one for me to use? Not sure how to do this but to save lot of typing - please see the screen-shot image (see link) to see if I am placing in the right place on my "phpMyAdmin" site?

Screen shot image -
http://www.lyndonborrow.com/download/screen_shot_myphpadmin_01.PNG

Let me know if that is right before I can take the next step? Just in case if you need to know my server information etc - see on further below.


Many thanks.

Lyndon



=====================================================

MySQL
Server: Localhost via UNIX socket
Server version: 5.1.56
Protocol version: 10
User: dibf@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server
cpsrvd 11.30.4.6
MySQL client version: 5.1.56
PHP extension: mysql

phpMyAdmin
Version information: 3.4.5, latest stable version: 3.4.5

Hi Nicholas,

Thanks for your reply.

Yeah, apparently before I star trying to upgrade (to wrong one Joomla 1.7) I did backup of whole server and also back up the database.

When I realised I have used wrong Joomla (1.7 instead of 1.5), I removed all web files and replaced with from back-up files. I also removed the database to replace with the back-up ones. So then when I try to run a web page it has an error message as I have mentioned in my previous post.

So U take it that you saying it still wont work if I try to use 'create table' - codes from your earlier post -

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`) );

...right? Hmm?

Lyndon