Error
  • 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 vnqe6_jcalpro_events AS Event LEFT JOIN vnqe6_users AS Author ON Author.id = Event.`created_by` LEFT JOIN vnqe6_jcalpro_event_categories AS Cat510 ON Cat510.event_id = Event.id AND Cat510.category_id = 510 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat516 ON Cat516.event_id = Event.id AND Cat516.category_id = 516 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat517 ON Cat517.event_id = Event.id AND Cat517.category_id = 517 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat518 ON Cat518.event_id = Event.id AND Cat518.category_id = 518 WHERE Event.language IN ('en-GB','*') AND (Cat510.category_id = 510 OR Cat516.category_id = 516 OR Cat517.category_id = 517 OR Cat518.category_id = 518) AND Event.approved = 1 AND Event.private = 0 AND Event.published = 1 AND Event.approved = 1 AND ((( Event.start_date <= '2013-12-31 16:00:00' AND Event.end_date >= '2014-02-01 15: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 >= '2013-12-31 16:00:00' AND Event.start_date < '2014-02-01 15: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 > '2013-12-31 16:00:00' AND Event.start_date <= '2014-02-01 15:59:59') OR ( Event.end_date > '2013-12-31 16:00:00' AND Event.end_date <= '2014-02-01 15:59:59' ) )) GROUP BY Event.id 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 vnqe6_jcalpro_events AS Event LEFT JOIN vnqe6_users AS Author ON Author.id = Event.`created_by` LEFT JOIN vnqe6_jcalpro_event_categories AS Cat510 ON Cat510.event_id = Event.id AND Cat510.category_id = 510 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat516 ON Cat516.event_id = Event.id AND Cat516.category_id = 516 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat517 ON Cat517.event_id = Event.id AND Cat517.category_id = 517 LEFT JOIN vnqe6_jcalpro_event_categories AS Cat518 ON Cat518.event_id = Event.id AND Cat518.category_id = 518 WHERE Event.language IN ('en-GB','*') AND (Cat510.category_id = 510 OR Cat516.category_id = 516 OR Cat517.category_id = 517 OR Cat518.category_id = 518) AND Event.approved = 1 AND Event.private = 0 AND Event.published = 1 AND Event.approved = 1 AND ((( Event.start_date <= '2013-12-31 16:00:00' AND Event.end_date >= '2014-02-01 15: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 >= '2013-12-31 16:00:00' AND Event.start_date < '2014-02-01 15: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 > '2013-12-31 16:00:00' AND Event.start_date <= '2014-02-01 15:59:59') OR ( Event.end_date > '2013-12-31 16:00:00' AND Event.end_date <= '2014-02-01 15:59:59' ) )) GROUP BY Event.id ORDER BY Event.start_date ASC
  • Error loading module You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND falang_content.published=1 AND falang_content.reference_id IN(362,331,335' at line 4 SQL=SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM vnqe6_falang_content AS falang_content WHERE falang_content.language_id= AND falang_content.published=1 AND falang_content.reference_id IN(362,331,335,396,437,300,183,423,327,385,429,425,383,380,382,297,218,221,334,220,233,316,408,134,397,348,379,374,400,401,358,359,360,361,346,314,195,275,339) AND falang_content.reference_table='modules'