jtablesession store failed DB function failed with error number 1062

Has your Joomla site suddenly stoped working and is now returning the error:

"jtablesession::store failed

DB function failed with error number 1062"

The bad news is I've seen it a lot Joomla sites and I've yet to find out why it happens. The good news is fixing a Joomla site after a jtablesession error is easy.

I recommend you backup your Joomla site before you make any alterations to the database settings.

Repairing the jos_session database table will fix this error. Easy if you know Joomla databases. If not, here's how to repair the jos_session database table for Joomla:

The best way is through a browser based application called phpMyAdmin. Find phpMyAdmin by logging on to your account with your webhost provider and look amongst the database tools.

Once you open phpMyAdmin you will see all your Joomla databases listed on the left. FYI In this example the Joomla databases I have install with Simplescripts are seen as _jml(xx) and the Joomla sites I installed using Fantastico are those with _joom(x).

Click on the database which corresponds with your Joomla site. Your only one step away from fixing the DB function failed error.

Find the "jos_session" entry and put a tick in it as shown here (it won't be highlighted until you tick it). You may need to scroll down through the Joomla Database entries to find it.

Click the arrow on the drop-down box which says "With selected:" and then click on "repair table". This will repair the jos_session table and more importantly repair your Joomla site. You will no longer see: "jtablesession::store failed DB function failed with error number 1062"

TrackBack URI for this entry

Comments (36)

Subscribe to this comment's feed

many many thanks
written by sasnel, November 22, 2009

thank you so much, many many thanks

• 
• +3
• 
• 

very thanx
written by rip, December 07, 2009

very thanx.

• 
• +0
• 
• 

hi! its NOT works
written by Neo, December 24, 2009

hi your advice isnt works!!((((( what can I do??

REPLY: Make sure you follow the instructions exactly if you don't have cpanel find a way (with whatever you have) to repair the jos_session table.

• 
• +1
• 
• 

it works!!
written by Gerardo, January 15, 2010

I fixed my table but not with this steps!!!.. I fixed with the options... in the footer..

I SELECTED jos_sessions in the left panel... just click...
then click OPERATIONS...
AND I HAVE A OPTION... REPAIR TABLE.. BUT DIFFERENT!! I HAVE A PANEL OF NAME: Table Maintenance

• 
• +0
• 
• 

other way to repair the table
written by Youtukan, January 15, 2010

Thanks Gerado, yes there are surely other ways to repair the jos_session table.

The important thing is to know repairing this table is how you fix the 'jtablesession::store failed DB function failed with error number 1062' error.After that, how you repair the jos_session table is up to you.

• 
• +0
• 
• 

Great thanks
written by Reerr, January 18, 2010

It really works, when followed your steps.
Great work !

• 
• +0
• 
• 

Thank You
written by Christopher Prins, January 28, 2010

Can you hear that? That's my heart starting to pump again!

Thankyou very much for the easy step-by-step.

Kind Regards,
Christopher Prins

• 
• +0
• 
• 

THANK YOU
written by Nico, March 05, 2010

Thanks you this is really really great - I was almost s***ing bricks but now all fixed and working - THANKS

• 
• +0
• 
• 

That is nice
written by emi, March 17, 2010

It works, and is nice to have a relief for a moment.Is there any way that ensures the removal of this error persistently?

• 
• +0
• 
• 

Thanks
written by Zaheer Ahmad Khan, March 30, 2010

Thanks a lot, it works, thanks.

• 
• +0
• 
• 

Thanks
written by vasek, April 12, 2010

Thanks you this is really really great

• 
• +1
• 
• 

Thanks
written by Ken Rainsforth, May 18, 2010

Thanks for this.
It just works like it says on the box.
Got the site back in minutes. Phew!!
Ken

• 
• +0
• 
• 

It's Works Fine
written by Ewandoo, July 15, 2010

Thank You Very Much

• 
• +0
• 
• 

opinion
written by pdFOK, July 30, 2010

Hi. I can see a good blogger in your article. And you presentation is also good. Keep on posting the good articles.I hope to find more helpful news and info here for the next time.

• 
• +0
• 
• 

Thanks a lot
written by Sean, August 02, 2010

The most clear and precise instructions on this problem. Thanks mate . . .

• 
• -1
• 
• 

Resolution
written by sernan, August 18, 2010

Repairing the table did not work for me, i need to drop the table and recreate again..

• 
• +1
• 
• 

...
written by alain, September 02, 2010

thank you (grazie) very very very much indeed!!!
i was about to panic ...

• 
• -1
• 
• 

thank u
written by اغاني شعبي, October 12, 2010

thank u that's great

• 
• +0
• 
• 

thanks
written by BGY, October 12, 2010

Great thank u

• 
• +0
• 
• 

THANK YOU!
written by Chris, December 01, 2010

THANK YOU VERY MUCH!

My church had a volunteer set up a website for them a year ago and he went with Joomla. After a few months he decided he was too busy to keep it up any more. Today it threw this error and my church asked if anyone thought they could fix it. This worked perfectly! Many, many thanks!

• 
• +0
• 
• 

...
written by Heather, December 09, 2010

The problem I'm having is that it says I don't have any databases. What happened? Where did they go?

• 
• +0
• 
• 

...
written by haroon, December 12, 2010

thanks alottttttttttttttttt

• 
• +0
• 
• 

...
written by jumper, February 02, 2011

Thanks very much !!! You saved my life

• 
• +0
• 
• 

muchas gracias!
written by Patricio, February 21, 2011

Muchas gracias >> thanks alot

• 
• +0
• 
• 

...
written by Andy, February 23, 2011

Life saver! thanks so much!

• 
• +0
• 
• 

Why it happens...?
written by Ellen, March 06, 2011

Thank you for helping me and everybody else out! Probably the reason why this problem occurs is due to the provider, because I had the same problem with two joomla websites at the same time....

• 
• +0
• 
• 

Thanks from South Africa
written by Alistair, April 01, 2011

Thanks for this quick and easy fix, saved my morning.

• 
• +0
• 
• 

And a Thanks from Texas!
written by Robert W, May 12, 2011

Thanks for the tip! Saved me hours of hunting time!

• 
• +0
• 
• 

Issue
written by Ravinder, May 26, 2011

Hello sir, Thanks alot. i have same with with my site and repair the session table and it work .. And tell me now my site is protected and how to repair my site.. please

• 
• +0
• 
• 

jos_sesssion
written by Per, July 25, 2011

if the fix not working, you can also try this:
http://blogomunity.com/joomla-blog/59-speed-up-joomla-store-sessions-in-memory.html

• 
• +0
• 
• 

Working!
written by Music2Play.org, July 28, 2011

Thank you very much !!!!

• 
• +0
• 
• 

Fixed
written by Arran, August 27, 2011

Phew, thanks. Wife talking to me now it's fixed.

• 
• +0
• 
• 

jos_sesssion
written by Henric Jr, September 02, 2011

I followed the same procedure but it did not work,
it showed me that the table was corrupt, i then droped the table and recreated it but now it shows me an error "404 component not found". Can someone help me please.

• 
• +0
• 
• 

dzięki
written by grzesiek, November 10, 2011

Dzięki za pomoc, u mnie działa!

• 
• +0
• 
• 

Not working
written by Mak, January 06, 2012

I have tried this fix but it not working. How else can I fix it? or rather, what causes this problems?
I will appreciate any help from you guys.
Regards

• 
• +0
• 
• 

Thanks
written by ahmed mahadi, January 18, 2012

you are the best!!
thanks you alot ..
I saved a lot of time I appreciate it

• 
• +0
• 
• 

Name

Email

Website

Title

Comment

smaller | bigger

Subscribe via email (registered users only)

I have read and agree to the Terms of Usage.

Write the displayed characters

Add Comment