No valid database connection 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 '('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a. SQL=SELECT a.*, cat.*, status.*, groups.GroupName as groupName, groups.GroupAbbr as groupAbbr, groups.contactName AS gContactName, groups.contactWebSite AS gContactWebSite, groups.contactEmail AS gContactEmail, groups.contactTelephone AS gContactTelephone, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.categoryID, cat.alias) ELSE cat.categoryID END AS catslug FROM jos_simplecal AS a INNER JOIN jos_simplecal_categories AS cat ON a.categoryID = cat.categoryID LEFT JOIN jos_simplecal_groups AS groups ON a.entryGroupID = groups.groupID LEFT JOIN jos_simplecal_statuses AS status ON a.statusID = status.statusID WHERE (CASE WHEN a.date2 > a.date1 THEN a.date2 ELSE a.date1 END) >= CONVERT ('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a.published = "1" ORDER BY a.date1 ASC, a.from_time, a.id
No valid database connection 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 '('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a. SQL=SELECT a.*, cat.*, status.*, groups.GroupName as groupName, groups.GroupAbbr as groupAbbr, groups.contactName AS gContactName, groups.contactWebSite AS gContactWebSite, groups.contactEmail AS gContactEmail, groups.contactTelephone AS gContactTelephone, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.categoryID, cat.alias) ELSE cat.categoryID END AS catslug FROM jos_simplecal AS a INNER JOIN jos_simplecal_categories AS cat ON a.categoryID = cat.categoryID LEFT JOIN jos_simplecal_groups AS groups ON a.entryGroupID = groups.groupID LEFT JOIN jos_simplecal_statuses AS status ON a.statusID = status.statusID WHERE (CASE WHEN a.date2 > a.date1 THEN a.date2 ELSE a.date1 END) >= CONVERT ('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a.published = "1" ORDER BY a.date1 ASC, a.from_time, a.id
No valid database connection 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 '('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a. SQL=SELECT a.*, cat.*, status.*, groups.GroupName as groupName, groups.GroupAbbr as groupAbbr, groups.contactName AS gContactName, groups.contactWebSite AS gContactWebSite, groups.contactEmail AS gContactEmail, groups.contactTelephone AS gContactTelephone, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.categoryID, cat.alias) ELSE cat.categoryID END AS catslug FROM jos_simplecal AS a INNER JOIN jos_simplecal_categories AS cat ON a.categoryID = cat.categoryID LEFT JOIN jos_simplecal_groups AS groups ON a.entryGroupID = groups.groupID LEFT JOIN jos_simplecal_statuses AS status ON a.statusID = status.statusID WHERE (CASE WHEN a.date2 > a.date1 THEN a.date2 ELSE a.date1 END) >= CONVERT ('2012-05-19 04:59:27', date) AND a.entryIsPrivate = "0" AND a.published = "1" ORDER BY a.date1 ASC, a.from_time, a.id LIMIT 0, 50