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!
CG Calendar search result MySQL error
-
- New Member
- Posts: 9
- Joined: Tue Jul 14, 2009 4:03 pm
-
- New Member
- Posts: 9
- Joined: Tue Jul 14, 2009 4:03 pm
Re: CG Calendar search result MySQL error
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.
Here is the fresh install: http://gowright.org/beta with the search box that gives the mySQL error.
-
- New Member
- Posts: 9
- Joined: Tue Jul 14, 2009 4:03 pm
Re: CG Calendar search result MySQL error
Rolled back modules back to CGCalendar 1.5.1 and CGExtensions 1.19.2. It works with these versions.