Page 1 of 1

CG Calendar search result MySQL error

Posted: Fri Sep 10, 2010 6:59 pm
by spacetacular
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!

Re: CG Calendar search result MySQL error

Posted: Tue Sep 14, 2010 2:53 pm
by spacetacular
I just did a fresh install of CMS Made Simple version 1.8.2, CGExtensions 1.19.5 and CGCalendar 1.5.5 and I still am getting the MySQL error. Running PHP Version 5.2.9

Here is the fresh install: http://gowright.org/beta with the search box that gives the mySQL error.

Re: CG Calendar search result MySQL error

Posted: Wed Sep 15, 2010 6:27 pm
by spacetacular
Rolled back modules back to CGCalendar 1.5.1 and CGExtensions 1.19.2. It works with these versions.