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
Jazzi
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Nov 19, 2006 12:56 am
Location: UK
Contact:

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

Post by Jazzi » Sun Jul 12, 2009 4:31 pm

I've just had exactly the same problem. Joomla 1.5.12 on a dedicated CentOS server.

Somebody before me mentioned that their server had been rebooted a few hours before the problem. Well, mine was the same - 2 hours and 17 minutes after a reboot the error showed up. I fixed it by repairing the jos_session table in phpMyAdmin, but I'm astounded that nobody has worked out what's causing it yet! Come on JoomGods - shine down on us all and fix this! :)
Paul E. Web Designer & Developer / Joomla Guy
http://joomlaguy.co.uk

emomoney
Joomla! Apprentice
Joomla! Apprentice
Posts: 39
Joined: Wed Dec 20, 2006 12:12 am

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

Post by emomoney » Mon Jul 13, 2009 2:08 am

pardocorp wrote:Graphical solution onhttp://www.youtukan.com/joomla/jtablese ... -1062.html
Unfortunately that fix doesn't work for everybody. The DB failed to repair from my Cpanel and PHPMyadmin. My webhosthad to perform the repair.
Jazzi wrote:I've just had exactly the same problem. Joomla 1.5.12 on a dedicated CentOS server.

Somebody before me mentioned that their server had been rebooted a few hours before the problem. Well, mine was the same - 2 hours and 17 minutes after a reboot the error showed up. I fixed it by repairing the jos_session table in phpMyAdmin, but I'm astounded that nobody has worked out what's causing it yet! Come on JoomGods - shine down on us all and fix this! :)
There was no MySQL upgrade performed? That's the only time I have seen this message is after a MySQL upgrade.

User avatar
Jazzi
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Nov 19, 2006 12:56 am
Location: UK
Contact:

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

Post by Jazzi » Mon Jul 13, 2009 11:17 am

emomoney wrote:There was no MySQL upgrade performed? That's the only time I have seen this message is after a MySQL upgrade.
Nope... Definitely no MySQL upgrade.
Paul E. Web Designer & Developer / Joomla Guy
http://joomlaguy.co.uk

User avatar
Jazzi
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Nov 19, 2006 12:56 am
Location: UK
Contact:

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

Post by Jazzi » Sat Jul 18, 2009 7:43 pm

Just got this again - shortly after another reboot. I believe it has to do with certain parts of the drive being mounted as read-only by the OS after a reboot (as was mentioned by somebody else in this thread).

Somebody needs to write a PHP script that can be run as a cron job: IF the jos_session table is marked as crashed THEN repair it. Unfortunately it's above my coding abilities... :(

The other option is to switch the session handler off in the Joomla config - but I'm not sure what the repercussions of doing this might be?!
Paul E. Web Designer & Developer / Joomla Guy
http://joomlaguy.co.uk

User avatar
Jazzi
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Nov 19, 2006 12:56 am
Location: UK
Contact:

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

Post by Jazzi » Sat Jul 18, 2009 8:04 pm

OK... It appears that it's not above my coding ability! :p

This is the new cron job I'm running:

Code: Select all

*/2 * * * * mysqlcheck -uDBUSER -pDBPASSWORD DBNAME jos_session --auto-repair
That runs a check on just the jos_session table (taking a matter of a couple of seconds) every minute 24/7/365 - automatically repairing the table if it's marked as crashed.

Note: I will not be held responsible for anybody running this cron job or messing up their site/server. You use this at your own risk - if you have no idea what a cron job is then this isn't for you! ;)
Paul E. Web Designer & Developer / Joomla Guy
http://joomlaguy.co.uk

deleted user

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

Post by deleted user » Mon Aug 10, 2009 5:06 pm

I had the session table crash immediately after Media Temple moved me from MySQL 4 to 5. Now I just got it again, but only on one Joomla site on the same grid (gs) account. Currently running Joomla 1.5.14, and I have set the session handler to none now.

itaym
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Thu Nov 20, 2008 4:10 pm

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

Post by itaym » Sun Aug 16, 2009 9:58 pm

I just went to "Clean Cache Admin" under "Tools" and clean it.
I hope this is good solution and not temporary healing :)

ddmobley
Joomla! Intern
Joomla! Intern
Posts: 90
Joined: Thu Jun 15, 2006 2:18 am

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

Post by ddmobley » Tue Aug 25, 2009 5:36 pm

Check your databases. You may have outstanding tasks to perform. Upgrades to MySQL5 from MySQL4 may produce tables that need updating:

error : Table upgrade required. Please do "REPAIR TABLE `jos_session`" to fix it!

You will find all tables need repairing. Run this if you have root access:

/usr/bin/mysqlcheck --repair --all-databases

This is on RH/CentOS Linux, your command path may differ.

User avatar
Lara_Shadow
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 228
Joined: Thu Jul 30, 2009 12:39 pm
Location: INDIA

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

Post by Lara_Shadow » Thu Sep 03, 2009 1:30 pm

I have the same problem.
I also empty the jos_session table, but it does't work for me.

I found that my mysql account has permission for "Write" and "Admin" but I don't ckeck box for "Read only" permission. I think that if I were "Admin" than I will have all privileges but the select query is for the "read only account".
So when I check the check box for "Read only", then every thing goes fine.

Tompalaz
Joomla! Apprentice
Joomla! Apprentice
Posts: 37
Joined: Tue May 27, 2008 9:13 am

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

Post by Tompalaz » Sun Sep 06, 2009 4:03 pm

I can't repair my jos_session
It seems that the total mysql have crashed. I can't access phpmyadmin.
"Can't start session without fault. Control errors in your PHP and/or webserver logfile and configure your PHP-install correct."

mysql> REPAIR TABLE 'jos_session';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"REPAIR TABLE 'jos_session'"' at line 1

User avatar
pxforti
Joomla! Hero
Joomla! Hero
Posts: 2755
Joined: Wed Apr 04, 2007 8:54 pm
Location: Driggs, Idaho

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

Post by pxforti » Tue Sep 15, 2009 4:56 pm

I had same problem. Was able to fix it by using phpmyadmin to repair the jos_session table. I have no idea why this happened.
Joomla Website Design / CS-Cart Website Design
http://writenowdesign.com

Tompalaz
Joomla! Apprentice
Joomla! Apprentice
Posts: 37
Joined: Tue May 27, 2008 9:13 am

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

Post by Tompalaz » Wed Sep 16, 2009 7:44 am

fsck did the trick!

spacehero
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Oct 12, 2009 7:35 am

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

Post by spacehero » Mon Oct 12, 2009 7:38 am

I met the same problem with 1.5.12 twice.
Repair or empty the table can fix the problem temporarily, which comes out again serveral weeks later.

I just turned the session management option from db to none, but it still writes the jos_session table when any page is visited.

bmose14
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri Jul 11, 2008 3:34 pm

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

Post by bmose14 » Mon Oct 19, 2009 5:05 pm

I contacted my hosting provider, they repaired the database and it is fixed now, thanks guys!

julian_e
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Fri Feb 06, 2009 3:33 pm

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

Post by julian_e » Fri Oct 23, 2009 5:13 pm

I was on 1.5.10 and gave me this error, then repair the database and upgrade to 1.5.14, but this morning I got the same error again, Does anybody knows that causes this error in Joomla? and how definitely correct?

julian_e
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Fri Feb 06, 2009 3:33 pm

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

Post by julian_e » Wed Oct 28, 2009 4:50 am

Reviewing the jos_session table data shows that all types are invited records, which makes me suppose that could be the search engine robots and one of them is trying to obtain unauthorized access? What think? Hacker Problem ??

pksdvas
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Nov 02, 2009 2:53 am

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

Post by pksdvas » Mon Nov 02, 2009 2:58 am

cespinoza wrote: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.
yeah this guidance work for me too..awesome..thanx a bunch..!! ;D

julian_e
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Fri Feb 06, 2009 3:33 pm

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

Post by julian_e » Tue Nov 03, 2009 10:55 pm

pksdvas wrote:
cespinoza wrote: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.
yeah this guidance work for me too..awesome..thanx a bunch..!! ;D
This solution is NOT GOOD ENOUGH it is only temporary, The problem persist and surges again, I'm not sure what is causing this problem, but Joomla designers, should enable an option allowing us just to stop writing on this Jos_session table or something like that. This is a really disgusting problem.

southmost
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Thu Jan 24, 2008 2:09 pm

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

Post by southmost » Wed Nov 04, 2009 4:31 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:
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.

THIS WORKED FOR ME AS WELL. I WONDER WHAT CAUSED IT IN THE FIRST PLACE.

bigshot728
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Nov 10, 2009 9:54 pm

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

Post by bigshot728 » Tue Nov 10, 2009 10:06 pm

Same problem here.. :( it happened all ready several times. I keep repairing the jos_session but I cannot keep doing this. I am running joomla 1.5.14

How can this problem be solved.

Thanks

asemax
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jul 07, 2009 6:09 am

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

Post by asemax » Thu Jan 28, 2010 6:28 pm

hi guys,

anyone wanna share a reason why this error happens? am thinking it`s a server /host problem.

aaronp
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Tue Jan 29, 2008 4:35 am

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

Post by aaronp » Wed Feb 24, 2010 4:58 am

I had this problem today and used the following procedure to fix it.
cespinoza wrote: 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
Fingers crossed that it doesnt happen again? I havent seen any recomendations on how to avoid receiving the error, just how to repair the table once it does happen.

Running v1.5.15

julian_e
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Fri Feb 06, 2009 3:33 pm

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

Post by julian_e » Mon Mar 01, 2010 4:10 pm

Hi, any progress on this issue? This situation is really worrying as it causes very poor image with customers. Additionally, it has begun appearing again this another error:

Database Error: Unable to connect to the database:Could not connect to MySQL

I know how to solve it temporarily but definitively establishing any idea to fix it?

PalaDolphin
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Thu Dec 03, 2009 4:41 pm

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

Post by PalaDolphin » Fri Mar 12, 2010 11:28 pm

I received this exact same error when I ask screwing around with running Joomla on a Windows Apache/MySQL server simultaneously with Joomla on Ubuntu Linux Apache/MySQL on the same file system, which btw is on another a Linux partition I dual-boot from. I tried loading the home page with no login on both environments at the same time. Linux loaded successfully, where Windows got the error.

I was trying to find out what would happen if you had two MySQL servers trying to access the same data files at the same time...chaos. It's okay; it's just my development server.

In PhpMyAdmin, the jos_session table is corrupt. The record count is ~02 (the 2 is superscript, meaning it's exponentially screwed). I get the following error when I view the table:

#145 - Table '.\joomla15\jos_session' is marked as crashed and should be repaired

I performed the following command and it seemed to fix the jos_session table (it left 4 records):

myisamchk -r jos_session.MYI

Now everything's running fine. :)

-- PalaDolphin

aaronp
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Tue Jan 29, 2008 4:35 am

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

Post by aaronp » Sat Mar 13, 2010 4:19 pm

I contacted my host about this problem and they responded

"Your database crashing issue is related with your /tmp partition low space:

When you mysql do logging and creating temp files then its filled up. Please let us know if we can change mysql /tmp to /home/****/tmp so that you won't get this issue in future."

I had them make the change and have not had a problem since.

User avatar
deck2deck
Joomla! Explorer
Joomla! Explorer
Posts: 281
Joined: Fri Feb 03, 2006 3:23 pm
Location: Georgia, United States

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

Post by deck2deck » Mon May 10, 2010 1:34 pm

I also just got this message. It was because my site had filled up its available disk storage space.

Solution took about 10 minutes:

Upgraded host account to increase disk space.
Reinstalled database with same name as original database.
Using MyPHPAdmin, used the database repair command.
Ta-da! Site was back online and running smoothly.

Hope this helps someone! :)
Be part of the solution -- not part of the problem.

joshmedici
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Oct 08, 2008 7:03 pm

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

Post by joshmedici » Thu Sep 16, 2010 6:53 pm

I used jos_session and emptied the table and that did the work for me.

I don't know why it does happen but I solved my problem login into phpMyAdmin.

Empty the session and it works.

MCC
Joomla! Apprentice
Joomla! Apprentice
Posts: 32
Joined: Wed Oct 08, 2008 3:47 am

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

Post by MCC » Fri Sep 17, 2010 7:59 pm

I DID IT!!!!!!!!!!!!!!!!!!

Thank you...no more stomach cramps :)

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 Sep 21, 2010 1:36 pm

deck2deck wrote:I also just got this message. It was because my site had filled up its available disk storage space.

Solution took about 10 minutes:

Upgraded host account to increase disk space.
Reinstalled database with same name as original database.
Using MyPHPAdmin, used the database repair command.
Ta-da! Site was back online and running smoothly.

Hope this helps someone! :)
I had the same problem today. I had recently installed a new template on my site and then left it for a couple of days. When I went to check my google adsense I saw it had only earned 0.20c instead of the usual much higher amount. I navigated to the site to find this famous error message:
"jtablesession::Store Failed
DB function failed with error number 1062 yada yada yada
"
Anyway...i had no problem with disc space allocation or over use of anything. Before having a knee jerk reaction and destroying the site completely by undoing and uploading all sorts of junk, I checked the notices here and figured that if I went to cpanel, mysql, and did a repair it should work fine. It did. After a few minutes of research the process itself took less than a 1 minute. Auto too. Very nice indeed.

keef
:eek:
It's great to be here......in fact,.....it's great to be anywhere!

User avatar
72dpi
Joomla! Intern
Joomla! Intern
Posts: 55
Joined: Thu Mar 16, 2006 12:47 am

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

Post by 72dpi » Thu Sep 23, 2010 5:14 am

Just to add to this, I just had this same problem:

jtablesession::store failed DB function failed with error number 1036
Table 'jos_session' is read only

We are using WAMP on a VM for testing, for some reason the jos_Sessions.MYI file chanegd to read only, so, that was changed, then went into phpmyadmin, checked the jos_sessions table, then truncated the data (it's only session data after all).

Problem fixed, site restored, fix added the the Tech notes for future reference ;)


Locked

Return to “Administration 1.5”