Появился AjaxSearch 1.8

$database_connection_charset = '';

$database_connection_charset = 'utf8';

[!AjaxSearch? &ajaxSearch=`1` &extract=`1` &language=`russian-uft8` &ajaxSearchType=`1` &ajaxMax=`10` &showMoreResults=`1` &addJscript=`1`!]

« 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 'SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.al » SQL: SELECT cnt.id, cnt.publishedon, cnt.pagetitle, cnt.longtitle, cnt.description, cnt.alias, cnt.introtext, cnt.menutitle, cnt.content, cnt.tv_content, cnt.tv_id FROM (SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT tv.value ORDER BY tv.value SEPARATOR ", " ) AS tv_content, GROUP_CONCAT( DISTINCT CAST(tv.id AS CHAR) SEPARATOR "," ) AS tv_id FROM `sariaby`.`test_site_content` sc LEFT JOIN `sariaby`.`test_site_tmplvar_contentvalues` tv ON sc.id = tv.contentid WHERE ((sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id) AS cnt WHERE (cnt.pagetitle LIKE '%Запрос%' OR cnt.longtitle LIKE '%Запрос%' OR cnt.description LIKE '%Запрос%' OR cnt.alias LIKE '%Запрос%' OR cnt.introtext LIKE '%Запрос%' OR cnt.menutitle LIKE '%Запрос%' OR cnt.content LIKE '%Запрос%' OR cnt.tv_content LIKE '%Запрос%') OR (cnt.pagetitle LIKE '%для%' OR cnt.longtitle LIKE '%для%' OR cnt.description LIKE '%для%' OR cnt.alias LIKE '%для%' OR cnt.introtext LIKE '%для%' OR cnt.menutitle LIKE '%для%' OR cnt.content LIKE '%для%' OR cnt.tv_content LIKE '%для%') OR (cnt.pagetitle LIKE '%РїРѕРёСЃРєР°...%' OR cnt.longtitle LIKE '%РїРѕРёСЃРєР°...%' OR cnt.description LIKE '%РїРѕРёСЃРєР°...%' OR cnt.alias LIKE '%РїРѕРёСЃРєР°...%' OR cnt.introtext LIKE '%РїРѕРёСЃРєР°...%' OR cnt.menutitle LIKE '%РїРѕРёСЃРєР°...%' OR cnt.content LIKE '%РїРѕРёСЃРєР°...%' OR cnt.tv_content LIKE '%РїРѕРёСЃРєР°...%') ORDER BY publishedon, pagetitle
[Copy SQL to ClipBoard] Parser timing MySQL: 0.0062 s(13 Requests) PHP: 0.0692 s Total: 0.0753 s