Vsmart Extensions
Fehler
  • Got error 28 from storage engine SQL=SELECT a.*,c.published as cat_published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM `jos_contact_details` AS a INNER JOIN jos_categories AS c ON c.id = a.catid LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_contact' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND a.featured=1 AND c.access IN (1,1) AND a.published = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 11:04:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 11:04:17') AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 ORDER BY ordering ASC Got error 28 from storage engine SQL=SELECT a.*,c.published as cat_published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM `jos_contact_details` AS a INNER JOIN jos_categories AS c ON c.id = a.catid LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_contact' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND a.featured=1 AND c.access IN (1,1) AND a.published = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 11:04:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 11:04:17') AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 ORDER BY ordering ASC LIMIT 0, 20 Got error 28 from storage engine SQL=SELECT a.*,c.published as cat_published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM `jos_contact_details` AS a INNER JOIN jos_categories AS c ON c.id = a.catid LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_contact' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND a.featured=1 AND c.access IN (1,1) AND a.published = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 11:04:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 11:04:17') AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 ORDER BY ordering ASC