Code:
1054 - Unknown column 'i.sectionid' in 'field list' SQL=SELECT i.id, i.title AS title, i.sectionid, i.created, i.id AS fc_item_id, 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( " / ", 'Content', c.title, i.title ) AS section, c.access as category_access, ty.access as type_access, 1 AS has_access FROM a9p6d_content AS i JOIN a9p6d_categories AS c ON c.id = i.catid JOIN a9p6d_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN a9p6d_flexicontent_types AS ty ON ie.type_id = ty.id WHERE 1 AND i.state IN (1,-5) 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,5) AND c.access IN (0,1,1,5) AND i.access IN (0,1,1,5) AND i.id IN ( SELECT item_id FROM a9p6d_flexicontent_items_ext WHERE MATCH (search_index) AGAINST ('+orig' IN BOOLEAN MODE) ) GROUP BY i.id ORDER BY i.title ASC LIMIT 0, 50
The search index is fresh. No other components are installed.
