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  [ 110 posts ]  Go to page 1, 2, 3, 4  Next
Author Message
PostPosted: Wed Apr 16, 2008 4:08 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Jul 19, 2007 3:32 am
Posts: 84
Location: Albany, NY
Our 1.5 site went down this morning with the following error:

Code:
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


Top
 Profile  
 
PostPosted: Sun Apr 27, 2008 8:06 am 
User avatar
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Apr 27, 2008 7:21 am
Posts: 3
Location: Southwest France
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.


Top
 Profile  
 
PostPosted: Tue Apr 29, 2008 5:42 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Feb 06, 2007 12:18 pm
Posts: 294
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


Top
 Profile  
 
PostPosted: Tue Apr 29, 2008 5:49 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Feb 06, 2007 12:18 pm
Posts: 294
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


Top
 Profile  
 
PostPosted: Sun May 04, 2008 4:24 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Feb 06, 2007 9:02 pm
Posts: 21
I've been having troubles like that for 2 days now.

Here is my research findings:

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


Top
 Profile  
 
PostPosted: Wed Jul 02, 2008 8:10 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 23, 2008 7:06 pm
Posts: 5
Location: Madagascar
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,


Top
 Profile  
 
PostPosted: Wed Jul 02, 2008 8:55 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Feb 06, 2007 12:18 pm
Posts: 294
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


Top
 Profile  
 
PostPosted: Thu Aug 14, 2008 8:17 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Aug 14, 2008 8:00 am
Posts: 1
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.


Top
 Profile  
 
PostPosted: Sat Aug 23, 2008 12:51 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Jan 05, 2008 5:20 pm
Posts: 22
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' )


Top
 Profile  
 
PostPosted: Sat Aug 23, 2008 12:59 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Jan 05, 2008 5:20 pm
Posts: 22
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.


Top
 Profile  
 
PostPosted: Wed Oct 29, 2008 6:59 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Mar 22, 2006 4:04 am
Posts: 9
Location: Boise ID
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


Top
 Profile  
 
PostPosted: Mon Nov 10, 2008 6:50 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Dec 10, 2007 5:34 pm
Posts: 9
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?


Top
 Profile  
 
PostPosted: Fri Nov 21, 2008 5:11 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Nov 21, 2008 5:08 am
Posts: 1
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??


Top
 Profile  
 
PostPosted: Fri Nov 21, 2008 3:05 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Dec 10, 2007 5:34 pm
Posts: 9
That worked for me. Seems the error is related to the session table being truncated.


Top
 Profile  
 
PostPosted: Fri Nov 21, 2008 4:03 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Feb 06, 2007 9:02 pm
Posts: 21
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!


Top
 Profile  
 
PostPosted: Wed Dec 03, 2008 10:26 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Fri Aug 24, 2007 8:53 pm
Posts: 53
Location: Moose Jaw, Saskatchewan Canada
Code:
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


Top
 Profile  
 
PostPosted: Sun Dec 21, 2008 4:47 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Dec 21, 2008 4:41 pm
Posts: 1
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.


Top
 Profile  
 
PostPosted: Sun Dec 21, 2008 8:47 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Dec 10, 2007 5:34 pm
Posts: 9
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.


Top
 Profile  
 
PostPosted: Mon Jan 05, 2009 4:36 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jan 05, 2009 4:24 pm
Posts: 1
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.


Top
 Profile  
 
PostPosted: Tue Jan 06, 2009 7:52 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jun 07, 2007 12:33 pm
Posts: 32
Add my name to the list. Twice in the last week or so. Repairing the sessions table fixes it for me.


Top
 Profile  
 
PostPosted: Thu Jan 22, 2009 12:12 pm 
User avatar
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Apr 27, 2008 7:21 am
Posts: 3
Location: Southwest France
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???


Top
 Profile  
 
PostPosted: Thu Jan 29, 2009 7:35 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat May 17, 2008 6:52 pm
Posts: 31
Location: Ecuador
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?


Top
 Profile  
 
PostPosted: Thu Jan 29, 2009 11:35 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Jan 29, 2009 10:44 pm
Posts: 3
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:
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.


Top
 Profile  
 
PostPosted: Fri Jan 30, 2009 1:54 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat May 17, 2008 6:52 pm
Posts: 31
Location: Ecuador
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.


Top
 Profile  
 
PostPosted: Tue Feb 03, 2009 10:32 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Feb 03, 2009 9:17 pm
Posts: 5
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 :(


Top
 Profile  
 
PostPosted: Tue Feb 03, 2009 10:38 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Fri Aug 12, 2005 12:38 am
Posts: 13379
Location: Sydney - Australia
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 - Follow me on Google+
http://www.rochen.com - Joomla! Hosting, the correct way.
http://www.joomlatutorials.com <-- Joomla Help & Tutorials
^Now with Joomla 2.5 and Joomla 3.0 Tutorials


Top
 Profile  
 
PostPosted: Wed Feb 04, 2009 4:02 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Feb 03, 2009 9:17 pm
Posts: 5
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


Top
 Profile  
 
PostPosted: Wed Feb 04, 2009 8:14 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat May 17, 2008 6:52 pm
Posts: 31
Location: Ecuador
Please, review this documentation:

http://docs.joomla.org/Do_you_have_to_u ... la!_1.5%3F
http://docs.joomla.org/How_do_you_upgra ... la!_1.5%3F
http://docs.joomla.org/Upgrade_Instructions


Top
 Profile  
 
PostPosted: Mon Feb 09, 2009 2:46 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Feb 04, 2009 3:06 pm
Posts: 1
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


Top
 Profile  
 
PostPosted: Mon Feb 09, 2009 6:20 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat May 17, 2008 6:52 pm
Posts: 31
Location: Ecuador
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.

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 110 posts ]  Go to page 1, 2, 3, 4  Next



Who is online

Users browsing this forum: No registered users and 12 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