We have a client with a site based on MODx content manager. The site is not visible - instead there is an error code that reads (in part):
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT DISTINCT sc.* FROM `dmozley_main`.modx_site_content sc LEFT JOIN `dmozley_main`.modx_document_groups dg ON [login to view URL] = [login to view URL] LEFT JOIN `dmozley_main`.modx_documentgroup_names dgn ON [login to view URL] = dg.document_group WHERE [login to view URL] = '1' AND (1='' OR NOT(dgn.private_webgroup1));
I need someone to hack into this (I can't access the content manager via the passwords but I can get into the hosting account)and repair the database error, reset the passcodes and get the site back online.
The URL is [login to view URL]
Thanks!