Code:
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 ') AND i.id IN ( SELECT item_id FROM j25_flexicontent_items_ext AS ts WHERE MA' at line 1 SQL=SELECT i.id, i.title AS title, i.created, i.id AS fc_item_id, i.access, ie.type_id, i.language, ie.search_index AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, CONCAT_WS( " / ", 'Item', c.title, i.title ) AS section, c.access as category_access, ty.access as type_access, 1 AS has_access FROM j25_content AS i JOIN j25_categories AS c ON c.id = i.catid JOIN j25_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN j25_flexicontent_types AS ty ON ie.type_id = ty.id WHERE 1 AND i.state IN (1,-5,2) AND c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) AND ty.access IN (0,1,1) AND c.access IN (0,1,1) AND i.access IN (0,1,1) AND ie.type_id IN () AND i.id IN ( SELECT item_id FROM j25_flexicontent_items_ext AS ts WHERE MATCH (ts.search_index) AGAINST ('+rapport* +gilles*' IN BOOLEAN MODE) ) GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50
