jtablesession::Store Failed, DB function failed error 1062

Need help with the Administration of your Joomla! 1.5 site? This is the spot for you.

Moderator: General Support Moderators

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.
tarzadon
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Wed Sep 13, 2006 6:27 am

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

Post by tarzadon » Wed Oct 27, 2010 8:22 pm

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;

User avatar
keefrichards
Joomla! Explorer
Joomla! Explorer
Posts: 366
Joined: Tue Aug 12, 2008 9:04 am
Location: Sydney, Australia

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

Post by keefrichards » Wed Oct 27, 2010 9:26 pm

It's all good.
Keep on rockin'
:eek:
It's great to be here......in fact,.....it's great to be anywhere!

mhadipour
Joomla! Intern
Joomla! Intern
Posts: 70
Joined: Thu Jan 08, 2009 11:22 am

DB function failed with error number 1054

Post by mhadipour » Fri Oct 29, 2010 9:02 pm

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

jeorcal
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Tue Jul 06, 2010 3:06 pm

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

Post by jeorcal » Wed Nov 03, 2010 8:03 am

same here


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

the website is down

dgaletar
Joomla! Apprentice
Joomla! Apprentice
Posts: 35
Joined: Thu Apr 02, 2009 3:27 am
Location: Abingdon, MD
Contact:

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

Post by dgaletar » Fri Nov 26, 2010 2:09 am

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!

fonz_k
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Mon Jan 19, 2009 6:48 pm

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

Post by fonz_k » Tue Feb 01, 2011 2:54 pm

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.

gbcecil
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri Oct 15, 2010 8:18 am

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

Post by gbcecil » Wed Feb 02, 2011 4:53 pm

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

dialipso
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Mar 01, 2011 1:46 am

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

Post by dialipso » Tue Mar 01, 2011 2:16 am

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...

Erasmus331
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Mar 07, 2011 12:08 pm

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

Post by Erasmus331 » Mon Mar 07, 2011 12:22 pm

Awesome!! It’s just what I need!! Thanks!..............

delsky
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Mar 25, 2011 12:59 am

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

Post by delsky » Fri Mar 25, 2011 1:04 am

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

User avatar
dylanjh
Joomla! Ace
Joomla! Ace
Posts: 1823
Joined: Fri Sep 22, 2006 6:22 pm
Location: UK
Contact:

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

Post by dylanjh » Mon Aug 15, 2011 9:04 am

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?
EmailAsUsername - Remove Usernames Joomla! Virtuemart And JomSocial registration http://www.lunarhotel.co.uk Many other extensions supported.

User avatar
iTD
Joomla! Intern
Joomla! Intern
Posts: 73
Joined: Mon Aug 24, 2009 10:11 pm

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

Post by iTD » Thu Aug 25, 2011 6:23 pm

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?

stavroch
Joomla! Intern
Joomla! Intern
Posts: 97
Joined: Wed Feb 15, 2006 10:23 pm

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

Post by stavroch » Tue Sep 13, 2011 9:16 am

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?

User avatar
iTD
Joomla! Intern
Joomla! Intern
Posts: 73
Joined: Mon Aug 24, 2009 10:11 pm

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

Post by iTD » Tue Sep 13, 2011 4:31 pm

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.

stavroch
Joomla! Intern
Joomla! Intern
Posts: 97
Joined: Wed Feb 15, 2006 10:23 pm

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

Post by stavroch » Tue Sep 13, 2011 6:49 pm

What hardware you have?
My problem is coming from many users at the same time I think.

1Yuri
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Oct 09, 2008 3:00 pm

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

Post by 1Yuri » Mon Sep 19, 2011 10:24 am

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

alecomp
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Nov 29, 2011 1:37 pm

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

Post by alecomp » Tue Nov 29, 2011 1:44 pm

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.

danss2
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Sun Feb 21, 2010 10:03 pm

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

Post by danss2 » Fri Feb 24, 2012 10:43 am

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....

User avatar
Nick Savov
Joomla! Ace
Joomla! Ace
Posts: 1076
Joined: Tue Apr 13, 2010 7:40 pm

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

Post by Nick Savov » Thu May 31, 2012 8:28 am

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
Joomla Templates created by the Wright Framework.

"God is most glorified in us, when we are most satisfied in Him" - http://www.desiringgod.org/

canito14
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Oct 08, 2012 2:05 pm

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

Post by canito14 » Mon Oct 08, 2012 2:17 pm

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?

mavaughan
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Thu Aug 23, 2012 6:01 pm

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

Post by mavaughan » Tue Jun 11, 2013 4:28 pm

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

User avatar
sunshine1688
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Mon Jun 27, 2011 1:59 pm
Location: Thailand
Contact:

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

Post by sunshine1688 » Sat Jun 29, 2013 10:26 am

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.

Theocephale
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Sep 14, 2013 3:21 pm

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

Post by Theocephale » Mon Nov 18, 2013 8:46 am

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

freshlookweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Oct 17, 2013 6:38 pm

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

Post by freshlookweb » Tue Jan 14, 2014 6:37 pm

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.

User avatar
miloskorac
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Sun Sep 23, 2007 9:34 pm
Location: Punta Cana, Dominican Republic
Contact:

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

Post by miloskorac » Sat Jun 28, 2014 1:30 am

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.

452
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Jul 21, 2014 4:50 pm

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

Post by 452 » Mon Jul 21, 2014 4:54 pm

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

User avatar
keefrichards
Joomla! Explorer
Joomla! Explorer
Posts: 366
Joined: Tue Aug 12, 2008 9:04 am
Location: Sydney, Australia

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

Post by keefrichards » Tue Jul 29, 2014 1:33 am

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
It's great to be here......in fact,.....it's great to be anywhere!

452
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Jul 21, 2014 4:50 pm

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

Post by 452 » Tue Jul 29, 2014 2:01 am

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! :)

Carolek
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Wed Jul 18, 2012 2:15 pm

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

Post by Carolek » Wed Apr 15, 2015 5:35 am

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

mcofield_08
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed May 18, 2016 2:40 am

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

Post by mcofield_08 » Wed May 18, 2016 2:48 am

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


Locked

Return to “Administration 1.5”