I posted this yesterday. I really need some help with the search field. When I try to look for some word I got this message:
“SQL=SELECT COUNT(TM.ITEM_ID) AS NUM_ITEMS, CONCAT_WS(‘_’, `TYPE`, `ASSET_ID`, `OPTION_ID`, `LABELS`) AS TKEY FROM QX9JV_JAK2FILTER_TAXONOMY T INNER JOIN QX9JV_JAK2FILTER_TAXONOMY_MAP TM ON TM.NODE_ID = T.ID WHERE TM.ITEM_ID IN ( SELECT I.ID FROM QX9JV_K2_ITEMS AS I RIGHT JOIN QX9JV_K2_CATEGORIES AS C ON C.ID = I.CATID WHERE I.PUBLISHED = 1 AND I.ACCESS IN(1,1) AND I.TRASH = 0 AND C.PUBLISHED = 1 AND C.ACCESS IN(1,1) AND C.TRASH = 0 AND ( I.PUBLISH_UP = ‘0000-00-00 00:00:00’ OR I.PUBLISH_UP <= ‘2014-03-21 16:12:35’ ) AND ( I.PUBLISH_DOWN = ‘0000-00-00 00:00:00’ OR I.PUBLISH_DOWN >= ‘2014-03-21 16:12:35’ ) AND MATCH(I.TITLE, I.INTROTEXT, I.`FULLTEXT`, I.IMAGE_CAPTION, I.IMAGE_CREDITS, I.VIDEO_CAPTION, I.VIDEO_CREDITS, I.METADESC, I.METAKEY) AGAINST (‘””‘ IN BOOLEAN MODE) ) GROUP BY TKEY”
I dont know what to do
