Webmin: SQL show index from `jos_session` failed

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
Mimmi
Joomla! Intern
Joomla! Intern
Posts: 93
Joined: Sat Dec 13, 2008 10:41 pm

Webmin: SQL show index from `jos_session` failed

Postby Mimmi » Wed Oct 21, 2009 7:21 am

Our site is down:
http://liv-laga.no/

jtablesession::Store Failed
DB function failed with error number 145
Table './liv_laga_2/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '48f02e4220f324f5875886cd057e0d69','1256108992','','0','1','0' )


I looked at Site down:1.5.2. DB function failed with error number 145 but I don't use MyAdmin.

My host is my cousin I can't get hold of him because his phone is broken. :( I have very little server and database experience, work mainly with html, css etc. So I hope you guys might help.

When I click on MySQL Database Server I may edit other databases. But the one I need only says: SQL show index from `jos_session` failed : Table './liv_laga_2/jos_session' is marked as crashed and should be repaired

How may I access and repair this table?

Please take a look at the screenshot attached.
You do not have the required permissions to view the files attached to this post.
Last edited by Mimmi on Thu Oct 22, 2009 6:34 am, edited 1 time in total.

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3387
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Webmin: SQL show index from `jos_session` failed

Postby abernyte » Wed Oct 21, 2009 8:52 am

You will need to access your database via phpMyadmin.

Your database name should be shown in the left of the page. Click on it.

Scroll down the main page that opens until you find jos_sessions. Check the box on the left and at the foot of the page at the "with selected" drop down select Repair.

It will give you a "successful" message and your error should be cleared
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain

User avatar
Mimmi
Joomla! Intern
Joomla! Intern
Posts: 93
Joined: Sat Dec 13, 2008 10:41 pm

Re: Webmin: SQL show index from `jos_session` failed

Postby Mimmi » Wed Oct 21, 2009 8:59 am

Thank you! Where may I find phpMyadmin?

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3387
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Webmin: SQL show index from `jos_session` failed

Postby abernyte » Wed Oct 21, 2009 9:10 am

It is usually in the control panel provided by your host.
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain

User avatar
Mimmi
Joomla! Intern
Joomla! Intern
Posts: 93
Joined: Sat Dec 13, 2008 10:41 pm

Re: Webmin: SQL show index from `jos_session` failed

Postby Mimmi » Thu Oct 22, 2009 6:33 am

Problem solved! :-D

My cousin came online and gave me the right url to the MyAdmin. He fixed the problem. :-)

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3387
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Webmin: SQL show index from `jos_session` failed

Postby abernyte » Thu Oct 22, 2009 7:46 am

Glad to hear you are fixed
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain


Return to “Administration 1.5”

Who is online

Users browsing this forum: No registered users and 8 guests