Salut,
j'ai ce message sur un site joomla :
Apparemment, il faut que je fasse :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
pour réparer cette table, mais j'ai un le message d'erreur suivant :
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
Je ne connais rien au SQL, quelqu'un peut-il m'aider ?#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
Partager