« MODx Parse Error » MODx encountered the following error while attempting to parse the requested resource: « Execution of a query to the database failed - 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 '[*ID_collections*] AND sc.published=1 AND sc.deleted=0 AND (sc. » 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 `db180087243`.modx_site_content sc LEFT JOIN `db180087243`.modx_document_groups dg on dg.document = sc.id WHERE sc.parent = [*ID_collections*] AND sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu = 0 GROUP BY sc.id ORDER BY sc.pagetitle ASC;
This discussion is closed to further replies. Keep calm and carry on.