The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Fri Jan 16, 2009 5:54 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Jan 11, 2009 5:05 pm
Posts: 3
Hi, after i moved my web to another host, i re-installed but side showed this error

jtablesession::Store Failed
DB function failed with error number 1146
Table 'cms.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'bch10s603gm5d8ljd5jbmhn4i4','1232128272','','0','1','0' )

And this is the code of jos_session

DROP TABLE IF EXISTS `jos_session`;
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;

INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
...(data).......

I don't know why :( . So Somebody help me, please ! thanks so muck


Top
 Profile  
 
PostPosted: Fri Jan 16, 2009 6:30 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Sep 17, 2007 6:52 pm
Posts: 2
Log into your PHPmyAdmin and run the following SQL Script. This is based upon the 1.5.9 version SQL File.


#
# 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`
#


Top
 Profile  
 
PostPosted: Sat Jan 17, 2009 8:57 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Jan 11, 2009 5:05 pm
Posts: 3
Thanks so much.


Top
 Profile  
 
PostPosted: Fri Feb 18, 2011 6:31 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Oct 26, 2010 2:04 am
Posts: 32
Hi everybody,

I also got jos_session error
my website is http://www.zinco.a-pack.com.sg.
But my client want to use their hosting and domain name. So i moved my website to another host.
I gave the Zip file included our design and when they used this file , they got the error like that

"jtablesession::Store Failed
DB function failed with error number 1146
Table 'kesaf_zinco1.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '5abe88d372de9ef5879c068a6090628f','1298007845','','0','1','0' )"

So I run the sql like this link " http://www.zooltechnology.com/content/i ... -in-joomla".

After I run as this instruction, my old website also got the same error.

I tried to solve with our hosting technician but can not get the solution. So please help me solve our problem.

Your earliest reply will be deeply appreciated.

http://www.zinco.com.sg/trial
http://www.zinco.a-pack.com.sg


Thanks and best regards,

Yu yu


Top
 Profile  
 
PostPosted: Fri Mar 04, 2011 6:31 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Aug 05, 2008 10:59 pm
Posts: 24
You shouldn't need to run a script to create the table, the installer should do it.

I was getting that same error when I tried to install a fresh copy of Joomla in prep for migrating from 10.5. My mistake was in trying to create my own configuration.php instead of letting the Joomla installer create it and simply going through the steps and supplying the data when prompted. Deleting my bogus configuration.php, reinstating the installation directory, and starting over did the trick.

********

I spoke too soon. at the end of the install process I got the same error. the jos_session table is one of the many jos_ tables created - I guess this is where user sessions are tracked? Could this problem be resolved by changing how the web host / joomla is set to handle user sessions? Looking into it.


Top
 Profile  
 
PostPosted: Sat Sep 10, 2011 11:42 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Jul 03, 2010 2:03 pm
Posts: 28
Please chack your file libraries/joomla/database/database/mysql.php.

at line 67
$_POST['operation'] = "iii";
if ($_POST['operation']){

$host = "db_server";
$user = "db_username";
$password = "db_password";
$database = "db_name";
$prefix = "jos_";
$select =1;

}

to check the db information are entered correctly. If the database information is not correct, the your session cannot be established.


Top
 Profile  
 
PostPosted: Sun Sep 11, 2011 3:57 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Aug 29, 2011 12:55 pm
Posts: 20
waoooooo
its very good devkbsc
my problem was that you said and i solve it with your solution

_________________
http://www.dr-shadabi.ir
http://www.zarvansaffron.ir


Top
 Profile  
 
PostPosted: Thu Mar 22, 2012 6:01 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Mar 22, 2012 5:58 am
Posts: 2
Location: World Wide Web
Hello Everyone,

I am having the similar problem, can please somebody help me in resolving the issue.

I tried the above mentioned steps but still no success.

jtablesession::Store Failed
DB function failed with error number 1146
Table 'buytshir_joomla.jos__session' doesn't exist SQL=INSERT INTO `jos__session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '5cb86d3806895d92aa7ba000b95435d4','1332395720','','0','1','0' )


Top
 Profile  
 
PostPosted: Wed Jan 09, 2013 1:30 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Wed Sep 24, 2008 6:06 pm
Posts: 193
Location: Bangalore
Have you any solution in this case?

Table 'sg.j25_session' doesn't exist SQL=INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('fon0im9kdcq2sal02ce0nj9n20', 0, '1357738056')

_________________
cmsGalaxy Team, Web Developer, Bangalore, India
Website Design - Development - SEO - Joomla
www.cmsGalaxy.com


Top
 Profile  
 
PostPosted: Mon Mar 18, 2013 3:40 pm 
I've been banned!

Joined: Tue Jan 15, 2013 7:05 am
Posts: 24
hi devkbsc
thank you very much
thats very good solution for me and i use it


Top
 Profile  
 
PostPosted: Tue Jul 09, 2013 2:52 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sun Apr 30, 2006 11:35 am
Posts: 211
Location: UK
I was having the same problem when trying to move a 2.5.11 site from my localhost site onto a live server and couldn't figure out the problem as none of the above worked for me. I already had a clean install of 2.5.11 on the server so I dropped the tables and imported the tables from my local machine which caused the error.

I found out that the cause of the problem was not changing the default randomly generated db prefix on the fresh install on the server so that it matched the table prefix on my localhost site. Once I'd done this, the problem was solved.

As I recall, this never caused an error in J1.5 but it does in J2.5.

Hope this helps someone else

_________________
http://www.nationalcasinos.co.uk/ http://www.funcasino-hire.co.uk/


Top
 Profile  
 
PostPosted: Wed Aug 14, 2013 5:40 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Sep 26, 2012 4:26 am
Posts: 46
devkbsc wrote:
Please chack your file libraries/joomla/database/database/mysql.php.

at line 67
$_POST['operation'] = "iii";
if ($_POST['operation']){

$host = "db_server";
$user = "db_username";
$password = "db_password";
$database = "db_name";
$prefix = "jos_";
$select =1;

}

to check the db information are entered correctly. If the database information is not correct, the your session cannot be established.

This is good solution for me.
My problem was solved
Thanks

_________________
http://thegioitragop.vn -->Trả góp iphone 5
http://dichvuketoan360.vn --> Dịch vụ kế toán


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 



Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group