HELP! Database ERROR

Has anyone seen this or can you direct me where to find and fis the problem. The client can’t navigate to any page other than the home page.

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table ’./synergys_modx/modx_site_content’ is marked as crashed and should be repaired »
SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type=’reference’,sc.content,’’) as content, sc.template, sc.link_attributes FROM `synergys_modx`.`modx_site_content` sc LEFT JOIN `synergys_modx`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (69,66,68,67,65,64,63,62) GROUP BY sc.id ORDER BY sc.menuindex ASC ;
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0034 s (0 Requests)
PHP: 0.1862 s
Total: 0.1896 s

If you have access to PHPmyadmin go to the database and select structure, then put a tick in modx_site_content and scroll to the bottom of the page and select "repair table" from the drop down.

Might work but make sure you backup the database first by exporting it.

Paul - you’re awesome. Worked like a charm.

No problem,

Glad it worked for you ;o)