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.
User avatar
lcdweb
Joomla! Intern
Joomla! Intern
Posts: 87
Joined: Thu Jul 19, 2007 3:32 am
Location: Albany, NY
Contact:

jtablesession::Store Failed, DB function failed error 1062

Post by lcdweb » Wed Apr 16, 2008 4:08 pm

Our 1.5 site went down this morning with the following error:

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session (
`session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES (
'a095cf5b6baa793e26769c528f03d8ea','1208358762','','0','1','0' )
Clearing out the session table resolved the issue, but I'm concerned why it happened, where it came from, and how I prevent it from recurring. Anyone else experience this issue?

-Brian

 
User avatar
KDawg
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Apr 27, 2008 7:21 am
Location: Southwest France
Contact:

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

Post by KDawg » Sun Apr 27, 2008 8:06 am

Has anyone found more current reasons why this error would occur? I am running 1.5.2 and discovered this error as well. The error cleared and can't be reproduced, but it is a major concern because if you Google this error you will find that Google has indexed a very large number of Joomla sites where the GoogleBot found this same error and thinks it's a valid page for the site, therefore cataloging it in the search results!

I'd be surprised if many others have not seen this error (as evidenced by Google). If a site can be taken down by this bug until one happens to notice it, and only then brought back online by a PHPMyAdmin->Repair of the jos_session table, then that is a serious reliability issue for Joomla.

Anyone have any updates?

Merci bien.

User avatar
seola
Joomla! Explorer
Joomla! Explorer
Posts: 294
Joined: Tue Feb 06, 2007 12:18 pm
Contact:

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

Post by seola » Tue Apr 29, 2008 5:42 pm

For god sake this just happened with me also. Just 5 minutes ago.

I installed 1.53 version Jooomla few days ago, today I added Mootools from Yootheme, I have yoocarousel and yoogmaps

Can this cause problem?
http://www.seoandwebdesign.com Joomla SEO MARKETING WEB DESIGN Los Angeles

User avatar
seola
Joomla! Explorer
Joomla! Explorer
Posts: 294
Joined: Tue Feb 06, 2007 12:18 pm
Contact:

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

Post by seola » Tue Apr 29, 2008 5:49 pm

I repaired the table and my site is a mess.

OMG !!!

Warning: array_slice() [function.array-slice]: The first argument should be an array in /home/bb/public_html/seo/modules/mod_yoo_carousel/helper.php on line 104

Warning: Invalid argument supplied for foreach() in /home/bb/public_html/seo/components/com_content/models/section.php on line 352

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bb/public_html/seo/libraries/joomla/database/database/mysql.php on line 338

I mean why is this happening at all!!!

OK I resolved the situation

2 tables crashes, sessions and content so I had to repair them, But I really need some answers why is this happening???
http://www.seoandwebdesign.com Joomla SEO MARKETING WEB DESIGN Los Angeles

Metal Wing
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Tue Feb 06, 2007 9:02 pm
Contact:

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

Post by Metal Wing » Sun May 04, 2008 4:24 am

I've been having troubles like that for 2 days now.

Here is my research findings:

Code: Select all

jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session (
`session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES (
'a095cf5b6baa793e26769c528f03d8ea','1208358762','','0','1','0' )
The error above, means that something is wrong with the jos_sessions table. Repairing it might work. Dropping and recreating might or might make it worse.

In my case I had to disable SEFurls and my ARTIO JoomSEF in order to get all errors out of the way.
http://animewave.net ~ The Sound of The Future - Your #1 Japanese web Radio station! Live DJ shows every week!

mckael
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Jan 23, 2008 7:06 pm
Location: Madagascar
Contact:

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

Post by mckael » Wed Jul 02, 2008 8:10 pm

hello everybody,

i encountered the same problem. i tried to truncate the table jos_session but it didn't be successful. So after deleting it, i tried recreating it and when i display my site in the root folder http://x.x.x.x/ i came to an Error 404.
How to solve it please, anyone have any ideas ?

Many thanks,

User avatar
seola
Joomla! Explorer
Joomla! Explorer
Posts: 294
Joined: Tue Feb 06, 2007 12:18 pm
Contact:

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

Post by seola » Wed Jul 02, 2008 8:55 pm

session table is just for logged in data, so it is not important, what you should do is try to repair it, if that does not work than you should empty it, that did the trick with my site

But dont delete it, probably you should import just that table in your database from another backup
http://www.seoandwebdesign.com Joomla SEO MARKETING WEB DESIGN Los Angeles

abdi123
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Aug 14, 2008 8:00 am

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

Post by abdi123 » Thu Aug 14, 2008 8:17 am

hi guys,

i have this same problem too (error 1062) and subsequent error 1016,
running joomla 1.0.13, mysql 4.1 on yahoo hosting.
already tried to repair the jos_sessions table - it did fix the issue temporarily - but still did not fix the issue.

i'm curious whether this is a security hole or not - but from the website log - it doesnt record any suspicious activities.

could we fix this issue once and for all? any help would be appreciated.

thank you.

TrvlFox
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sat Jan 05, 2008 5:20 pm

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

Post by TrvlFox » Sat Aug 23, 2008 12:51 am

I just had this very same error. My site is down. I'm on Joomla 1.3

Could this be a bug? It just happened automatically. I could use some help on the steps to take.

:eek:

Exact error message
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a2c6abda82d49c50355c38b253ef1d6c','1219451441','','0','1','0' )

TrvlFox
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sat Jan 05, 2008 5:20 pm

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

Post by TrvlFox » Sat Aug 23, 2008 12:59 am

I ran a DB repair and that worked. My site is up, but I think we need to find out the answer to this problem.

User avatar
ichimonban
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed Mar 22, 2006 4:04 am
Location: Boise ID
Contact:

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

Post by ichimonban » Wed Oct 29, 2008 6:59 am

Getting same Error.

The site is J1.5.6, Site 5 Linux,

jtablesession::store failed
DB function failed with error number 1062
Duplicate entry 'ef429f4004a58e83b8cf1929c7bb1d86' for key 1 SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ef429f4004a58e83b8cf1929c7bb1d86','1225261992','','0','1','1' )

It seems to have cleared up with repairing the session table.

Ichimonban

http://www.urbandezign.com
Boise's Finest Web Design

brsacjab
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Dec 10, 2007 5:34 pm

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

Post by brsacjab » Mon Nov 10, 2008 6:50 pm

Just had the same error :(

J1.5.7, Site 5 Linux :-\

Did a repair on the session table, started working again...

Noticed the server was restarted ~ 3hrs ago...maybe abrupt shutdown left table broken or bad data?

nana111
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Nov 21, 2008 5:08 am

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

Post by nana111 » Fri Nov 21, 2008 5:11 am

i got the same error
jtablesession::Store Failed
DB function failed with error number 1016
Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '45ba19d7d475bc9d9c46c79971fca7c9','1227243742','','0','1','0' )

is it true that to repair the session table through phpmyadmin then it will work??

brsacjab
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Dec 10, 2007 5:34 pm

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

Post by brsacjab » Fri Nov 21, 2008 3:05 pm

That worked for me. Seems the error is related to the session table being truncated.

Metal Wing
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Tue Feb 06, 2007 9:02 pm
Contact:

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

Post by Metal Wing » Fri Nov 21, 2008 4:03 pm

nana111 wrote:i got the same error
jtablesession::Store Failed
DB function failed with error number 1016
Can't open file: 'jos_session.MYI' (errno: 145) SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '45ba19d7d475bc9d9c46c79971fca7c9','1227243742','','0','1','0' )

is it true that to repair the session table through phpmyadmin then it will work??
Yes it works (Unless you have a component that keeps screwing it up all the time). Repairing it is also much safer than 'backup - delete - re-add' method.
http://animewave.net ~ The Sound of The Future - Your #1 Japanese web Radio station! Live DJ shows every week!

User avatar
jboulton
Joomla! Intern
Joomla! Intern
Posts: 57
Joined: Fri Aug 24, 2007 8:53 pm
Location: Moose Jaw, Saskatchewan Canada

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

Post by jboulton » Wed Dec 03, 2008 10:26 pm

Code: Select all

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

I repaired the table and here were my results:

chamber_iT90.jos_session repair info Found block that points outside data file at 90524
chamber_iT90.jos_session repair info Found block that points outside data file at 91068
chamber_iT90.jos_session repair info Found block that points outside data file at 97816
chamber_iT90.jos_session repair info Found block that points outside data file at 98440
chamber_iT90.jos_session repair info Found block that points outside data file at 99528
chamber_iT90.jos_session repair warning Number of rows changed from 20 to 8

I don't know what the problem is;however I'm not impressed with this issue. :-\

Database Version: 5.0.67-community
Database Collation: utf8_general_ci
PHP Version: 5.2.6
Web Server: Apache/2
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.7 Production/Stable [ Wovusani ] 9-September-2008 23:00 GMT

rpackett
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Dec 21, 2008 4:41 pm

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

Post by rpackett » Sun Dec 21, 2008 4:47 pm

My site has gone down with the same error:
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '571ddeb9ed6b510fcb97746200dde527','1229877492','','0','1','0' )

but repairing the table did not work. I tried empyting the table, I'm still getting the same error.

Help anyone!

Nevermind!! I found the problem and fixed it.

brsacjab
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Dec 10, 2007 5:34 pm

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

Post by brsacjab » Sun Dec 21, 2008 8:47 pm

Worst case scenario I encountered recently. The database/table itself hath disappeared...

Host doesn't know why... So, remember to backup you files AND db regularly.

Fortunately, I was able to restore a previous db and make the changes to get it current.

OsNo
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Jan 05, 2009 4:24 pm

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

Post by OsNo » Mon Jan 05, 2009 4:36 pm

Had the same error 2 times.
before it got down the first time my server had an uptime of several weeks.
then i changed some settings in joomla
- put in legacy mode
- added template
- posted a new message

several days later the whole thing went down (with the same error message)
a couple of days later i went to the server... (cause it appeared to be a bigger problem, i couldn't login through ssh)... pulled the plug and rebooted it.... it restarted and all was fine again.

This afternoon it all happened again.
This time i already had some open SSH connections so i could test some stuff.

When i tried to restart apache it told me it couldn't access the logs.
Then i looked at my DCclient.... it was disconnected giving tons of errors saying my filesystem has gone ... read-only

so my /home/ and /tmp/ directories became read-only for some reason.
making the whole system malfunctioning.

I am running an Ubuntu Intrepid Ibex, MySQL, Apache2,....

So, i don't think Joomla could cause such a problem, unless there is a serious security leak.
So fellow server owners, help me find the server problem.

My hard drives are far from full btw.

hope we find a solution soon
Cheers


EDIT:

I seem to have found the problem,
Most linux servers remount there file systems on found errors, but they remount them read-only
So this screws up all logging including joomla's.

SOLUTION:
if you own the server, or have access to it: do an fsck and repair the harddrive. (needs to be done in a maintenance rootshell.), if errors keep coming back... consider buying a new harddrive.
if you don't: contact your hosting service and ask them to do this for you

NOTE:
you could just remove the on-error=remount-ro option from the fstab, but it's there for a reason, so i wouldn't recommend it. Could cause data loss.

KidA
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Thu Jun 07, 2007 12:33 pm

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

Post by KidA » Tue Jan 06, 2009 7:52 pm

Add my name to the list. Twice in the last week or so. Repairing the sessions table fixes it for me.

User avatar
KDawg
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Apr 27, 2008 7:21 am
Location: Southwest France
Contact:

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

Post by KDawg » Thu Jan 22, 2009 12:12 pm

rpackett wrote:My site has gone down with the same error:
jtablesession::Store Failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '571ddeb9ed6b510fcb97746200dde527','1229877492','','0','1','0' )

but repairing the table did not work. I tried empyting the table, I'm still getting the same error.

Help anyone!

Nevermind!! I found the problem and fixed it.
Insanely curious why rpackett "found the problem and fixed it" and didn't bother telling us what s/he found???

cespinoza
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Sat May 17, 2008 6:52 pm
Location: Ecuador

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

Post by cespinoza » Thu Jan 29, 2009 7:35 pm

Hi, I got the same error,

jtablesession::Store Failed
DB function failed with error number 145
Table './jbgorg_sites/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'a0650b658ee06670453ee8d1c1d7318a','1233257241','','0','1','0' )

Could you tell me how to repair the jos_session table?

nikkie
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Jan 29, 2009 10:44 pm

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

Post by nikkie » Thu Jan 29, 2009 11:35 pm

I'm using 1.5.7 and had the same problem. myPhpAdmin reported that the jos_session table was marked as "crashed." It gave me only the option to flush it, which of course didn't work given that the table was marked crashed. I dumped the table structure of jos_session from another 1.5.6 installation, which produced the following:

Code: Select all

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;
I then dropped the bad table and executed the above SQL, which restored everything completely.

I don't know if what worked for me is suitable for anyone else. Proceed with caution.

cespinoza
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Sat May 17, 2008 6:52 pm
Location: Ecuador

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

Post by cespinoza » Fri Jan 30, 2009 1:54 pm

When I had this problem, I reported it to my hosting provider and they told me that it was an error in their global mysql service and they had to fix it. Else I had to repair the jos_session table from MyPhPAdmin:

1) Enter your Hosting Cpanel
2) Select PhpMyAdmin
3) Select your data base
4) Check the table jos_session
5) At the bottom search for a drop list and select the option: repair the table

That worked for me.

arenita
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Feb 03, 2009 9:17 pm

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

Post by arenita » Tue Feb 03, 2009 10:32 pm

Ive already tried reparing the table but doesnt work.
Still appearin same error msg:

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 ( '70d78888785b2ec2840ba64eef9e2bf8','1233700284','','0','1','0' )

Also, If I try to log into administrator page... same error coming :(

User avatar
brad
Joomla! Master
Joomla! Master
Posts: 13419
Joined: Fri Aug 12, 2005 12:38 am
Location: Sydney - Australia
Contact:

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

Post by brad » Tue Feb 03, 2009 10:38 pm

Try to do a restore of your database from a backup.

Oh, and people.. please.. keep your Joomla installs up to date.. I can't believe some of you are not yet running 1.5.9, do you want to be hacked?
Brad Baker
https://xyzulu.hosting
https://www.joomlatutorials.com <-- Joomla Help & Tutorials

arenita
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Feb 03, 2009 9:17 pm

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

Post by arenita » Wed Feb 04, 2009 4:02 pm

Ive installed Joomla 1.5.9... but the version that was in the other server is older... Do you recomend me to install the older version with this DB backup and then update?
I dont know if its working installing the newest from the beggining


tompen
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Feb 04, 2009 3:06 pm

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

Post by tompen » Mon Feb 09, 2009 2:46 pm

I'm becoming more and more convinced that Joomla is not the source of the problem even though it might be the cause. But right now it would be more than interesting to know what versions of mysql, apache and php you are all running. Because I really need a new host for my client, but it would be nice to know that I'm not walking into the same trap again.

My own server, joomla running without a glitch (though installing modules is a bitch for one reason or another, but that's not a problem suited for this topic):

Ubuntu 5.4
Mysql: 5.0.51a
PHP: 5.2.4-2
Apache: 2.2.8

The error-server (talkactive.net):

FreeBSD 6.2
Mysql: 5.0.45
PHP: 5.2.3
Apache: 2.0.59

cespinoza
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Sat May 17, 2008 6:52 pm
Location: Ecuador

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

Post by cespinoza » Mon Feb 09, 2009 6:20 pm

These are mine: Joomla 1.5.9

ProgramVersion
Apache:2.2.11
CentOS:5.2
cPanel:11.24.4-RELEASE
Curl:7.12.1
MySQL5.1.30
phpMyAdmin2.11.9.4
Python:2.4.3ProgramVersion
Perl:5.8.8
PHP:5.2.4
ionCube Loader:3.1.32
Zend Optimizer:3.2.2
Ruby:1.8.5
Rails:2.2.2
OpenSSL:0.9.8b

But this error has nothing to do with the software version, as I have told you before this is an error in the mysql service of the hosting provider.
Last edited by cespinoza on Tue Feb 10, 2009 1:47 pm, edited 1 time in total.

 

Locked

Return to “Administration 1.5”