Table mySQL crashed

Salut,
j'ai ce message sur un site joomla :

Citation:

---

Table './XXXXX/jos_content_frontpage' is marked as crashed and should be repaired SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid = cc.id AND cc.section = s.id AND s.scope = 'content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0, 30

---

Apparemment, il faut que je fasse :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

SELECT C.*, G.NAME AS GROUPNAME, CC.NAME, U.NAME AS EDITOR, F.CONTENT_ID AS FRONTPAGE, S.TITLE AS SECTION_NAME, V.NAME AS AUTHOR FROM JOS_CONTENT AS C LEFT JOIN JOS_CATEGORIES AS CC ON CC.ID = C.CATID LEFT JOIN JOS_SECTIONS AS S ON S.ID = C.SECTIONID LEFT JOIN JOS_GROUPS AS G ON G.ID = C.ACCESS LEFT JOIN JOS_USERS AS U ON U.ID = C.CHECKED_OUT LEFT JOIN JOS_USERS AS V ON V.ID = C.CREATED_BY LEFT JOIN JOS_CONTENT_FRONTPAGE AS F ON F.CONTENT_ID = C.ID WHERE C.STATE >= 0 AND C.CATID = CC.ID AND CC.SECTION = S.ID AND S.SCOPE = 'content' ORDER BY S.TITLE, C.CATID, CC.ORDERING, CC.TITLE, C.ORDERING LIMIT 0,30

---

pour réparer cette table, mais j'ai un le message d'erreur suivant :

Citation:

---

#1064 - 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 'SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS ' at line 1

---

Je ne connais rien au SQL, quelqu'un peut-il m'aider ?

Quelle est votre version de MySQL ?

IL est probable que MySQL n'accepte pas le C.*. VOus devez donc explicitement mentionner toutes les colonnes de cette table.

Au passage il est idiot de faire du LEFT OUTER JOIN en filtrant ensuite sur CC.SECTION et S.SCOPE. En efet le filtre portant sur les données cela contre carre la jointure externe.

A +

Citation:

---

Envoyé par aptaker

Apparemment, il faut que je fasse (...)
pour réparer cette table, mais j'ai un le message d'erreur suivant :

---

Pas du tout, ça c'est la requête à l'occasion de laquelle MySQL s'aperçoit que la table a un petit problème...

Pour réparer ta table il faut que tu fasses :

Code:

---

1 2	REPAIR TABLE jos_content_frontpage ;

---