Error
  • The RokSprocket Module needs the RokSprocket Component enabled.
  • Got error 28 from storage engine SQL=SELECT Event.*,'com_jcalpro' AS context,IF(Event.`created_by`=0,'Guest',IF(Event.`created_by`=-1,'System',Author.name)) AS author_name,IF(Event.`created_by`=0,'guest',IF(Event.`created_by`=-1,'system',Author.username)) AS author_username FROM ibi4f_jcalpro_events AS Event LEFT JOIN ibi4f_users AS Author ON Author.id = Event.`created_by` LEFT JOIN ibi4f_jcalpro_event_categories AS CatFilter ON CatFilter.event_id = Event.id WHERE Event.language IN ('en-GB','*') AND Event.approved = 1 AND Event.private = 0 AND Event.published = 1 AND Event.approved = 1 AND ((( Event.start_date <= '2019-05-01 00:00:00' AND Event.end_date >= '2019-06-01 23:59:59' AND Event.end_date != '2038-01-18 00:00:00' AND Event.end_date != '0000-00-00 00:00:01' AND Event.end_date != '9999-12-01 00:00:00') OR ((Event.start_date >= '2019-05-01 00:00:00' AND Event.start_date < '2019-06-01 23:59:59') AND (Event.end_date = '2038-01-18 00:00:00' OR Event.end_date = '0000-00-00 00:00:01' OR Event.end_date = '9999-12-01 00:00:00')) OR ( Event.start_date > '2019-05-01 00:00:00' AND Event.start_date <= '2019-06-01 23:59:59') OR ( Event.end_date > '2019-05-01 00:00:00' AND Event.end_date <= '2019-06-01 23:59:59' ) )) GROUP BY Event.id HAVING ((CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',43,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,43,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,43,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',43,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',46,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,46,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,46,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',46,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',49,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,49,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,49,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',49,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',50,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,50,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,50,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',50,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',51,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,51,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,51,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',51,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',52,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,52,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,52,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',52,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',53,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,53,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,53,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',53,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',54,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,54,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,54,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',54,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',55,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,55,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,55,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',55,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',70,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,70,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,70,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',70,')) ORDER BY Event.start_date ASC Got error 28 from storage engine SQL=SELECT Event.*,'com_jcalpro' AS context,IF(Event.`created_by`=0,'Guest',IF(Event.`created_by`=-1,'System',Author.name)) AS author_name,IF(Event.`created_by`=0,'guest',IF(Event.`created_by`=-1,'system',Author.username)) AS author_username FROM ibi4f_jcalpro_events AS Event LEFT JOIN ibi4f_users AS Author ON Author.id = Event.`created_by` LEFT JOIN ibi4f_jcalpro_event_categories AS CatFilter ON CatFilter.event_id = Event.id WHERE Event.language IN ('en-GB','*') AND Event.approved = 1 AND Event.private = 0 AND Event.published = 1 AND Event.approved = 1 AND ((( Event.start_date <= '2019-05-01 00:00:00' AND Event.end_date >= '2019-06-01 23:59:59' AND Event.end_date != '2038-01-18 00:00:00' AND Event.end_date != '0000-00-00 00:00:01' AND Event.end_date != '9999-12-01 00:00:00') OR ((Event.start_date >= '2019-05-01 00:00:00' AND Event.start_date < '2019-06-01 23:59:59') AND (Event.end_date = '2038-01-18 00:00:00' OR Event.end_date = '0000-00-00 00:00:01' OR Event.end_date = '9999-12-01 00:00:00')) OR ( Event.start_date > '2019-05-01 00:00:00' AND Event.start_date <= '2019-06-01 23:59:59') OR ( Event.end_date > '2019-05-01 00:00:00' AND Event.end_date <= '2019-06-01 23:59:59' ) )) GROUP BY Event.id HAVING ((CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',43,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,43,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,43,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',43,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',46,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,46,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,46,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',46,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',49,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,49,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,49,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',49,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',50,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,50,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,50,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',50,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',51,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,51,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,51,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',51,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',52,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,52,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,52,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',52,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',53,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,53,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,53,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',53,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',54,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,54,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,54,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',54,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',55,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,55,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,55,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',55,') OR (CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',70,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,70,' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE '%,70,%' OR CONCAT(',', GROUP_CONCAT(CatFilter.category_id), ',') LIKE ',70,')) ORDER BY Event.start_date ASC

Upcoming Events