Database error on Joomla.org Topic is solved

If you have any 'mechanical' forum or Joomla! sites related issues/suggestions, please contact the Sites & Infrastructure Workgroup here.

Moderators: brad, Tonie

Forum rules
Forum Rules
READ ME <-- please read before posting, this means YOU.
Post Reply
SeanK

Database error on Joomla.org

Post by SeanK » Fri Feb 03, 2006 6:07 am

Getting this error when i access the bug report for docs and when i visit this link http://help.joomla.org/content/view/33/60/

NOt sure where to report this, so i figured this was the best place!

mossession::store failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '931d21c8e72fc3918f4887547c62a049','1138946741','','0','1' )

sashi1977
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Jan 11, 2006 7:19 am

Re: Database error on Joomla.org

Post by sashi1977 » Fri Feb 03, 2006 6:34 am

I'm getting the same error message:

mossession::store failed
DB function failed with error number 1062
Duplicate entry '1-' for key 2 SQL=INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '8d2d55c844fd0352a62625b40fec5410','1138948088','','0','1' )

It appears on all help.joomla.org requests.

User avatar
brad
Joomla! Hero
Joomla! Hero
Posts: 2212
Joined: Fri Aug 12, 2005 12:38 am
Skype: tested
Location: Sydney - Australia
Contact:

Re: Database error on Joomla.org

Post by brad » Fri Feb 03, 2006 8:55 am

I can't seem to replicate this... Is it still happening for you?
Brad Baker - Joomla! Core Team, Sites & Infrastructure.
http://www.rochen.com - Managed Dedicated, Reseller & Multiple Domain Hosting.
http://www.joomlatutorials.com <-- Joomla! 1.5 & 1.0.x
^New Joomla 1.5 Tutorials are out!

User avatar
Vimes
Joomla! Engineer
Joomla! Engineer
Posts: 356
Joined: Fri Aug 19, 2005 12:14 am
Location: United Kingdom
Contact:

Re: Database error on Joomla.org

Post by Vimes » Fri Feb 03, 2006 8:08 pm

It happened to me a couple of times yesterday, appx 16:30 GMT.
http://www.jomres.net A bookings comp for hotels
http://jcd-a.org J'nt Com' Dev's As'n
Life is not a journey to the grave with the intention of arriving safely in one pretty and well preserved piece, but to skid across the line broadside, thoroughly used up, worn out, leaking oil, yellng GERONIMO

User avatar
miki89
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Wed Jan 04, 2006 3:28 pm
Location: Milan, Italy

Re: Database error on Joomla.org

Post by miki89 » Sat Feb 04, 2006 2:04 pm

now I can see that page, but I saw the same problem yesterday...
Imagination is more important than knowledge... (Albert Einstein)

User avatar
TomT
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: Database error on Joomla.org

Post by TomT » Sat Feb 04, 2006 2:59 pm

I stiil get the  message when I click on the help tab on joomla.org
I can however reach the page when I enter the adres in Firefox.

User avatar
brad
Joomla! Hero
Joomla! Hero
Posts: 2212
Joined: Fri Aug 12, 2005 12:38 am
Skype: tested
Location: Sydney - Australia
Contact:

Re: Database error on Joomla.org

Post by brad » Sat Feb 04, 2006 8:26 pm

Please can you try clearing your browser cache to see if that makes any difference.

Thanks.
Brad Baker - Joomla! Core Team, Sites & Infrastructure.
http://www.rochen.com - Managed Dedicated, Reseller & Multiple Domain Hosting.
http://www.joomlatutorials.com <-- Joomla! 1.5 & 1.0.x
^New Joomla 1.5 Tutorials are out!

User avatar
TomT
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: Database error on Joomla.org

Post by TomT » Sat Feb 04, 2006 9:40 pm

It works fine now.

User avatar
eddyyanto
Joomla! Apprentice
Joomla! Apprentice
Posts: 44
Joined: Tue Jan 17, 2006 7:42 am
Contact:

Re: Database error on Joomla.org

Post by eddyyanto » Sun Feb 05, 2006 2:30 am

so what was the problem actually ?
will it come back again ?  :(
+ what's great about open-source? kindness of sharing
+ http://www.eddyyanto.com

User avatar
Rochen
Joomla! Intern
Joomla! Intern
Posts: 79
Joined: Wed Aug 17, 2005 3:19 pm
Location: United Kingdom
Contact:

Re: Database error on Joomla.org

Post by Rochen » Tue Feb 07, 2006 7:21 pm

I talked to Andy about this issue the other day and I believe it was due to the session table within the database not being cleared or something along those lines. There wasn't actually any issue with the MySQL server itself. I am not sure whether this issue will re-occur, I guess that would be better addressed by a member of the Joomla team who knows the code etc. We just make sure the servers keep humming along and leave the code to them :D
Chris Adams - CEO - Rochen Ltd. - 5 Years Industry Experience!
- Reseller Hosting & Multiple Domain Hosting
- www.rochen.com [b]| forums.rochen.com[/b]

twerp

Re: Database error on Joomla.org

Post by twerp » Sat Jul 08, 2006 2:41 am

Haven't read all this though BIG TIME it's happening to me with 1.1.10.
Tried a LOT of stuff to fix... for me anyways as I'm sorta novice/intermediate...
So... still searching around....


best wishes to all


Post Reply