Page 4 of 5

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Wed Oct 27, 2010 8:22 pm
by tarzadon
I got the error:

Code: Select all

DB function failed with error number 1016
Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO `jos_session` ...
I went into phpMyAdmin and saw that the table was empty.
I dropped the table and created it again by running:

Code: Select all

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',
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Wed Oct 27, 2010 9:26 pm
by keefrichards
It's all good.
Keep on rockin'
:eek:

DB function failed with error number 1054

Posted: Fri Oct 29, 2010 9:02 pm
by mhadipour
Hi,

I have the same proble i try to drop and recreate the tabel.
i also try to repair the table but i have the same problem yet.
i'll appreciate any help or suggestion.
i'am using latest version of joomla ithink 1.5.21

Code: Select all

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 ( 'd9c56433adb9c0da7e949c6fd47f8a7a','1288385588','','0','1','0' )
Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 35 bytes) in /home/webusers/sacookar/sacookar.com/www/libraries/joomla/error/exception.php on line 117

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 12 bytes) in /home/webusers/sacookar/sacookar.com/www/libraries/joomla/session/session.php on line 136

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Wed Nov 03, 2010 8:03 am
by jeorcal
same here


jtablesession::store failed
DB function failed with error number 1142
INSERT command denied to user xxxxx

the website is down

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Fri Nov 26, 2010 2:09 am
by dgaletar
Got this today:

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


I tried following several of the help solutions posted within this forum, but when I go into my "phpMyAdmin", I can't even find ANY Joomla databases listed!

Site is down, so ANY AND ALL HELP WOULD BE GREATLY APPRECIATED!!!

Thanks,

DG

PS - Happy Thanksgiving everyone!

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Feb 01, 2011 2:54 pm
by fonz_k
I had the exact same problem.

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO `jos_session`.......
My simple solution:

My sites are running on a Linux system with Directadmin control panel.

Simply selecting the appropriate database and clicking 'repair' did the trick.

Code: Select all

****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	info	Wrong bytesec: 98- 48- 99 at 374176; Skipped
****.jos_session	repair	warning	Number of rows changed from 345 to 337
And my site was up and running within 30 seconds. Don't know what caused the error though.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Wed Feb 02, 2011 4:53 pm
by gbcecil
Same problem here!!! Major website is DOWN!!!! Any ideas before I send about 10 people home for the day????

jtablesession::Store Failed
DB function failed with error number 1054
Unknown column 'gid' in 'field list' SQL=INSERT INTO `j16_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '6ftfl7makv2ngssgl8ff24gkr5','1296665542','','0','1','0' )
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 64 bytes) in...../libraries/joomla/error/exception.php on line 117

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Mar 01, 2011 2:16 am
by dialipso
I got some strange. The name of the table was changed, somebody renamed the name of table. I were rename again the table to the original name and it works. Somebody have idea in to know what is happened?

RENAME TABLE `hosting_jml2`.`jos_session` TO `hosting_jml2`.`jml_session

Recently, about one week ago, my account had been temporarily suspended for causing Performance Issues on the Server. My database and queries were taking down the SQL server. This database hosting_jml2 was causing the problems. I saw out the MySQL Slow Queries Logs inside my account here. The log are located inside /tmp/mysql_slow_queries/ I make a change to my joomla site to stop this from happening again. I repaired the table and fixes, but probably somebody hack me again or something like that.

Any idea in how to fix this?

Best Regards...

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Mar 07, 2011 12:22 pm
by Erasmus331
Awesome!! It’s just what I need!! Thanks!..............

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Fri Mar 25, 2011 1:04 am
by delsky
I have the same problem and I already tried the solutions mention above but still it did not solve the problem... I got this error

jtablesession::Store Failed
DB function failed with error number 1046
No database selected SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'f4dac309e90d5c8b882b64029680a4df','1301068429','','0','1','0' )

This happen when I try to access the database with
$db = & JFactory::getDBO();

can anyone help me please ? :'( I really need to get this running

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Aug 15, 2011 9:04 am
by dylanjh
Restoruig the table from backup seems to work fine. Im a little concerned however that so much detail is given in the error message. (e.g. the table name, table prefix etc) Is this not something that Joomla can catch and present a more generic message to the user, but notifying admin of the actuall problem?

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Thu Aug 25, 2011 6:23 pm
by iTD
Has anyone found a permanent solution/fix for this issue? This thread is over 3 years old and the problem still exists. While it does appear to be something in the MySQL configs on the server side, no solid information points in any direction thus far. I would love to be able to report to my hosting provide exactly what needs to be corrected.

Anyone?

Anyone?

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Sep 13, 2011 9:16 am
by stavroch
I had the same problem and I fix it from this post.

Do you know the reason of this? Why the jos_session is crashing?

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Sep 13, 2011 4:31 pm
by iTD
In my case this problem resulted from faulty hardware in the server. The backup drive's controller was bad and it caused this problem to occur to several sites. Once we replaced that part, the problem went away. Hopefully this info helps someone down the road.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Sep 13, 2011 6:49 pm
by stavroch
What hardware you have?
My problem is coming from many users at the same time I think.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Sep 19, 2011 10:24 am
by 1Yuri
Hello.

I upgraded website from joomla 1.0 to 1.5 then to 1.6 and 1.7. Everything was on my local server and everything was very good. Just worked. I got this error "jtablesession::Store Failed" with code 1054 (now it's 1146 for some reason) after I transfered website to another server. For me "table repair" and "recreating the table" doesn't work. PHP, MySQL versions are ok. If anybody got some idea about this, please.

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1146
Table 'imasiaco_jmlnew.j16_session' doesn't exist SQL=INSERT INTO `j16_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '04f6cf91befb18fee2aff43addc028d5','1316427917','','0','1','0' )
Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 68 bytes) in /home/imasiaco/public_html/im3asia/libraries/joomla/error/exception.php on line 117

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Nov 29, 2011 1:44 pm
by alecomp
hello! had the same problem today-
jtablesession::Store Failed
DB function failed with error number 1114
The table 'jos_session' is full SQL=INSERT INTO `jos_session` (
`session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES (
'f6a97c908293a2907e38862093eeecb0','1322570430','','0','1','0' )
on my site www.alecomp.ru
the problem was in firefox and ie, in chrome there was no problem.
the recent update i've made before the problem appeared first time- i switched crawl-delay from 4.5 to 1.5 sec in robots.txt
now i returned it back, will see if it happens again.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Fri Feb 24, 2012 10:43 am
by danss2
SOmeone mentioned that FSCK did the trick..... For me - it did the trick of messing things up... LOL Particularly this jos_session table issue(of this thread) happenned AFTER this FSCK ran... Hope my hosting guys can fix it for me, coz none of other solutions presented here helped....

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Thu May 31, 2012 8:28 am
by Nick Savov
What mySQL version is everyone using? In Joomla 1.5, you can go to admin >> help >> system info >> database version to check which version you're using. Your server might simply need an update to the latest version of mySQL 5.1.63 from 5.0.x

Kind regards,
Nick

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Oct 08, 2012 2:17 pm
by canito14
Hi,
I have suffered jos_session table truncated but i´m sure this problem is connected with another i´m suffering. My Joomla site does too much queries to DB and reach the number of queries alloweb by hour crashing database and getting error 500 or "cannot connect to database"

Any sugestion?

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Jun 11, 2013 4:28 pm
by mavaughan
This is till going on? I am on 2.5.11 and woke up today to this message.

Duplicate entry '1-' for key 'whosonline' SQL=INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('9f00308e96bbedc4eff2165f0a37dc67', 0, '1370966209')

Could not log in to the admin, so logged into phpadmin and restored the j25_sessions table and all was good. Able to log in on front and back ends.

Is this a failed attempt at a hack?

The results from the admin were:

Number of rows changed from 3 to 2

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Sat Jun 29, 2013 10:26 am
by sunshine1688
This error seem like only occurred on Joomla 1.5 sites, also related with server environment more..
Except repair the jos session database table in PhpMyadmin or change ur sever, there is no permanent solution yet.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Nov 18, 2013 8:46 am
by Theocephale
Hello,
Sorry to contradict you but I have a problem on a site in joomla 2.5.
This is a big problem, apparently still not resolved.
If you have information.
Thank you in advance
Theo

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Jan 14, 2014 6:37 pm
by freshlookweb
Hi I have the same problem:

jtablesession::store failed
DB function failed with error number 1062
etc etc jos_session etc etc

Is there really no known fix for this issue? 5 of my websites have been going down with this error every weekend for over a month now.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Sat Jun 28, 2014 1:30 am
by miloskorac
I have removed the frontpage session handling for guests, and the guest session flooding stopped.

When the guest session handling is enabled, each bot that visit the page will create the entry in the table jos_session.

There should be session handling enabled only for logged in users, or admins.

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Mon Jul 21, 2014 4:54 pm
by 452
In index.php replace:

$mainframe =& JFactory::getApplication('site');

With:

$mainframe =& JFactory::getApplication('site',array('session'=>false));

This should prevent Joomla from recording guest sessions and bloating up the database table that for me was creating the crash. In addition, I've also disabled the session handler under:

Site -> Global Configuration -> System

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Jul 29, 2014 1:33 am
by keefrichards
452 wrote:In index.php replace:

$mainframe =& JFactory::getApplication('site');

With:

$mainframe =& JFactory::getApplication('site',array('session'=>false));

This should prevent Joomla from recording guest sessions and bloating up the database table that for me was creating the crash. In addition, I've also disabled the session handler under:

Site -> Global Configuration -> System

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Tue Jul 29, 2014 2:01 am
by 452
My suggestion above should be done after you repair or truncate the jos_session table. I cleared mine out since my website doesn't make use of that table or have any sessions related functionality other than admins logging into the backend.

What I don't get is why this feature is turned on by default. I notice that after I wiped out my database, every unique user who visits my site gets a session recorded. Just merely coming to the homepage gets a session recorded. Just image how fast that can add up if you get lots of unique visitors. There is no nightly routine that clears out this table either. So it builds up overtime. By setting the above parameter in the index configuration you're basically telling Joomla to not record sessions for random people visiting the site.

However, site administrators logging into the backend will have their session information still stored in the table, but that's very acceptable. It would have to take A LOT of administrators to log in and out and from multiple machine to bloat the session table and bring down the site.

I say case closed! :)

Re: jtablesession::Store Failed, DB function failed error 10

Posted: Wed Apr 15, 2015 5:35 am
by Carolek
Hy

This happened to us about 3 or 4 times and I don't know what to do. I'm not really understand about SQL and database. From the support they told me that they made restart to mysql and it's ok, but only for a while. Is there a way to know what is the cause for this error?

Unknown storage engine 'InnoDB' SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES...


Thanks

Re: jtablesession::Store Failed, DB function failed error 1062

Posted: Wed May 18, 2016 2:48 am
by mcofield_08
Hi,

I've inherited an old Joomla site that decided a couple of days ago to through the below error:

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 'whosonline' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '23a6a205e28904e0c0dc8062172b06f6','1463539410','','0','1','0' )

Looks like I need to repair the table... but I have no idea at all on how to access and repair the table..

Can anyone give me some directions as I'm completely new to this?

Thanks,
Mark