Error
  • SQL QUERY ERROR:
    SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, 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 FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = i.catid LEFT JOIN #__users AS u ON u.id = i.created_by WHERE 1=1 AND rel.catid IN ('163') AND ( i.state IN (1, -5) OR i.created_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND i.access IN (1,1) ORDER BY rel.ordering ASC, c.title
    Got error 28 from storage engine SQL=SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, 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 FROM to9dy_content AS i LEFT JOIN to9dy_flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN to9dy_flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN to9dy_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN to9dy_categories AS c ON c.id = i.catid LEFT JOIN to9dy_users AS u ON u.id = i.created_by WHERE 1=1 AND rel.catid IN ('163') AND ( i.state IN (1, -5) OR i.created_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND i.access IN (1,1) ORDER BY rel.ordering ASC, c.title
  • SQL QUERY ERROR:
    SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, 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 FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = i.catid LEFT JOIN #__users AS u ON u.id = i.created_by WHERE 1=1 AND rel.catid IN ('163') AND ( i.state IN (1, -5) OR i.created_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND i.access IN (1,1) ORDER BY rel.ordering ASC, c.title
    Got error 28 from storage engine SQL=SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, 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 FROM to9dy_content AS i LEFT JOIN to9dy_flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN to9dy_flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN to9dy_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN to9dy_categories AS c ON c.id = i.catid LEFT JOIN to9dy_users AS u ON u.id = i.created_by WHERE 1=1 AND rel.catid IN ('163') AND ( i.state IN (1, -5) OR i.created_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-12-05 14:24:55' ) OR i.created_by = 0 ) AND i.access IN (1,1) ORDER BY rel.ordering ASC, c.title LIMIT 0, 10