EduGeek Joomla 1.5 Package Thread, Rather an urgent problem in Projects:; This is what we see when trying to access the website today. Does anyone out there have any solutions?
8th December 2009, 08:56 AM #1
Rather an urgent problem
This is what we see when trying to access the website today. Does anyone out there have any solutions?
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`,`clie nt_id` ) VALUES ( '0b16b96d7612b11ad71c3c54f0bcac1c','1260258658','' ,'0','1','0' )
IDG Tech News
8th December 2009, 09:01 AM #2
Is it Joomla? Googling seems to indicate a problem resolved thus:
Using phpMyAdmin - 22.214.171.124 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.
8th December 2009, 09:15 AM #3
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.
8th December 2009, 09:58 AM #4
Good - hope the fix holds
8th December 2009, 09:59 AM #5
Also was going to suggest a repair. Also may be an idea to take a backup of the database once it has been repaired.
8th December 2009, 11:15 PM #6
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.
By TheFopp in forum Windows Server 2000/2003
Last Post: 30th September 2009, 05:04 PM
By button_ripple in forum Windows
Last Post: 6th June 2008, 02:49 PM
By gibboap in forum Hardware
Last Post: 7th December 2007, 12:27 AM
By russdev in forum General Chat
Last Post: 1st October 2006, 05:02 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)