Solved

MySQL crash :Table './Mydb/jos_session' is marked as crashed and should be repaired

Posted on 2013-02-03
2
1,053 Views
Last Modified: 2013-02-03
Hi,
one of my Joomla sites has crashed with the following error message:


Table './Mydb/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('m8evkv79sb7uq2hefjn1l8ent1', 0, '1359911452')

ANy ideas (without losign data :-)
0
Comment
Question by:chilternPC
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38848950
Please run this statement
REPAIR TABLE jos_session;

Against your database
0
 
LVL 28

Author Closing Comment

by:chilternPC
ID: 38849003
thank you - it fixed it.
any idea how it got broke?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using in clause in query with many values 7 54
SQL inner join confusion 15 55
Help needed with Powershell  XML to MySQL 5 59
two ways encryption with php 3 37
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question