File: /home/c/cristo/meat.ntnn.ru/public_html/citrix/modules/search/classes/general/search.php
Line: 192
MySQL Query Error: SELECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.LID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.SEARCHABLE_CONTENT ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,L.DIR ,L.SERVER_NAME ,sc.URL as URL ,1 as RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE FROM b_search_content sc INNER JOIN b_search_content_group scg ON sc.ID=scg.SEARCH_CONTENT_ID AND scg.GROUP_ID IN (2) INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_lang L ON scsite.SITE_ID=L.LID INNER JOIN b_search_tags stags ON (sc.ID = stags.SEARCH_CONTENT_ID) WHERE (1=1) AND scsite.SITE_ID='s2' AND ((sc.DATE_FROM IS NULL OR sc.DATE_FROM <= now()) AND (sc.DATE_TO IS NULL OR sc.DATE_TO >= now())) GROUP BY sc.ID ,L.DIR ,L.SERVER_NAME ,scsite.URL ,scsite.SITE_ID HAVING (( (sum(stags.name like '%EA%E0%F0%E4%E0%EC%EE%ED %EC%EE%EB%EE%F2%FB%E9')>0) )) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[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 'RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,DATE_FORMAT(sc.DATE_CH' at line 18]
Line: 192
MySQL Query Error: SELECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.LID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.SEARCHABLE_CONTENT ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,sc.DATE_TO ,L.DIR ,L.SERVER_NAME ,sc.URL as URL ,1 as RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE FROM b_search_content sc INNER JOIN b_search_content_group scg ON sc.ID=scg.SEARCH_CONTENT_ID AND scg.GROUP_ID IN (2) INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN b_lang L ON scsite.SITE_ID=L.LID INNER JOIN b_search_tags stags ON (sc.ID = stags.SEARCH_CONTENT_ID) WHERE (1=1) AND scsite.SITE_ID='s2' AND ((sc.DATE_FROM IS NULL OR sc.DATE_FROM <= now()) AND (sc.DATE_TO IS NULL OR sc.DATE_TO >= now())) GROUP BY sc.ID ,L.DIR ,L.SERVER_NAME ,scsite.URL ,scsite.SITE_ID HAVING (( (sum(stags.name like '%EA%E0%F0%E4%E0%EC%EE%ED %EC%EE%EB%EE%F2%FB%E9')>0) )) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[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 'RANK ,scsite.URL as SITE_URL ,scsite.SITE_ID ,DATE_FORMAT(sc.DATE_CH' at line 18]
|