Rather an urgent problem

[beeswax]

This is what we see when trying to access the website today. Does anyone out there have any solutions?

 

jtablesession::Store Failed

DB function failed with error number 145

Table '.\fphsweb\jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '0b16b96d7612b11ad71c3c54f0bcac1c','1260258658','','0','1','0' )

[witch]

Is it Joomla? Googling seems to indicate a problem resolved thus:

Using phpMyAdmin - 2.10.0.1 in my host's Control Panel, I found no 'table repair' option so I simply clicked on jos_session in the table list on the left and then clicked on the 'Empty' tab at the top above the table's list of fields.

 

I then tried the website again and voila!, problem resolved.

[beeswax]

Thanks for that Witch. don't go through CP as we host the website ourselves, but it did give me a clue to the answer.

In the MySql Admin panel (we use IIS7) I opened the Catalogs and then the schema for the website. Highlighting the faulty table I clicked the Maintenance button and selected the Repair option. There were some options which I wasn't sure of, Local, Quick Fix, Extended, Use FRM. I chose the first two, Local and Quick Fix. They worked (so far).

I'm going home to change my underwear. I don't know, have a day off to do some study and come back to a mess.

[witch]

Good - hope the fix holds

[AIT]

Also was going to suggest a repair. Also may be an idea to take a backup of the database once it has been repaired.

[mossj]

Best take a backup of your website using Joomlapack (linked in a thread further down, but a google should bring it up.

 

Will take a backup of your database, and files, then zip it all up for you and put it where you want it. Best of all you can automate the process.