« 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 'FROM `kbhkis_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.con' at line 1 »
SQL: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR "," ) AS tv_value, ntv1.value AS FROM `kbhkis_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `kbhkis_site_tmplvar_contentvalues` tv ) AS ntv ON sc.id = ntv.contentid LEFT JOIN( SELECT DISTINCT tv1.contentid , tv1.value FROM `kbhkis_site_tmplvar_contentvalues` tv1 WHERE tv1.tmplvarid = '' ) AS ntv1 ON sc.id = ntv1.contentid WHERE ((sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%succes%') OR (sc.longtitle LIKE '%succes%') OR (sc.description LIKE '%succes%') OR (sc.alias LIKE '%succes%') OR (sc.introtext LIKE '%succes%') OR (sc.menutitle LIKE '%succes%') OR (sc.content LIKE '%succes%') OR (tv_value LIKE '%succes%') OR ( LIKE '%succes%'))) ORDER BY sc.publishedon,sc.pagetitle [!AjaxSearch? &ajaxSearch=`0` &showInputForm=`1` &grabMax=`10` &extract=`0` &withTvs=`-:leftbtm,rightbtm`!]
SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR "," ) AS tv_value, ntv1.value AS FROM `kbhkis_site_content` sc .....
