Salut,
j'ai ce message sur un site joomla :
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 : Sélectionner tout - Visualiser dans une fenêtre à part
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 :
#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 ?