No valid database connection Got error 28 from storage engine SQL=SELECT cc.title AS category, a.*,UNIX_TIMESTAMP(a.created) as crd,f.fr_introduction,fr_illustration as image, CASE WHEN CHAR_LENGTH(f.fr_title) THEN f.fr_title ELSE a.title END as title, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups FROM jos_mediacentre AS a LEFT JOIN jos_content_frontpage as f ON a.id=f.content_id AND f.type=2 LEFT JOIN jos_mediacentre_categories AS cc ON a.catid = cc.id LEFT JOIN jos_mediacentre_sections AS s ON a.sectionid = s.id LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 02:53:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 02:53:49' ) AND (s.id=1) AND a.type =2 AND s.published = 1 AND fr_illustration!="" AND cc.published = 1 AND a.frontpage= 1 GROUP BY a.id ORDER BY a.created DESC LIMIT 0, 5
No valid database connection Got error 28 from storage engine SQL=SELECT cc.title AS category, a.*,UNIX_TIMESTAMP(a.created) as crd,f.fr_introduction,fr_illustration, CASE WHEN CHAR_LENGTH(f.fr_title) THEN f.fr_title ELSE a.title END as title, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups FROM jos_mediacentre AS a LEFT JOIN jos_content_frontpage as f ON a.id=f.content_id AND f.type=2 LEFT JOIN jos_mediacentre_categories AS cc ON a.catid = cc.id LEFT JOIN jos_mediacentre_sections AS s ON a.sectionid = s.id LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 02:53:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 02:53:49' ) AND (s.id=1) AND a.type =1 AND s.published = 1 AND cc.published = 1 AND a.frontpage= 1 ORDER BY a.created DESC LIMIT 0, 10

Highlights

No valid database connection Got error 28 from storage engine SQL=SELECT a.*,f.ordering as fpordering,f.type as ftype, u.name AS author, u.usertype, cc.title AS category, s.title AS section,f.fr_introduction,fr_illustration, CASE WHEN CHAR_LENGTH(f.fr_title) THEN f.fr_title ELSE a.title END as title, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFT JOIN jos_content_frontpage as f ON a.id=f.content_id AND f.type=0 LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.id IN(92,91,90,89,88,87,86,85,84,83,82,81,79,78,77,69,68,67,66,65,63,62,60,59,58,57,56,54,53,41) AND cc.published=1 AND s.published=1 AND ( ( a.created_by = 0 ) OR ( a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 02:53:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 02:53:49' ) ) ) ORDER BY f.ordering