CG Calendar search result MySQL error
Posted: Fri Sep 10, 2010 6:59 pm
CG Calendar search result has a MySQL error since I upgraded CGextensions and CGCalendar.
This is the error message:
DEBUG: SELECT DISTINCT ev.event_id,ev.event_parent_id,ev.event_title FROM cms_module_cgcalendar_events ev WHERE ((ev.event_date_start BETWEEN '2010-09-10 00:00:00' AND '2010-10-10 23:59:00') OR (ev.event_date_end BETWEEN '2010-09-10 00:00:00' and '2010-10-10 23:59:00')) AND ((MATCH (ev.event_title,ev.event_summary,ev.event_details) AGAINST ('weekend')) OR ()) GROUP BY ev.event_title ORDER BY ev.event_date_start ASC
I'm using CGExtensions 1.19.5 and CGCalendar 1.5.5
I'm running CMS Made Simple 1.8.2. I'm using PHP 5, and MySQL 5.0.75.
Does anyone know how to fix?
Thanks!
This is the error message:
DEBUG: SELECT DISTINCT ev.event_id,ev.event_parent_id,ev.event_title FROM cms_module_cgcalendar_events ev WHERE ((ev.event_date_start BETWEEN '2010-09-10 00:00:00' AND '2010-10-10 23:59:00') OR (ev.event_date_end BETWEEN '2010-09-10 00:00:00' and '2010-10-10 23:59:00')) AND ((MATCH (ev.event_title,ev.event_summary,ev.event_details) AGAINST ('weekend')) OR ()) GROUP BY ev.event_title ORDER BY ev.event_date_start ASC
I'm using CGExtensions 1.19.5 and CGCalendar 1.5.5
I'm running CMS Made Simple 1.8.2. I'm using PHP 5, and MySQL 5.0.75.
Does anyone know how to fix?
Thanks!