CG Calendar search result MySQL error

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
spacetacular
New Member
New Member
Posts: 9
Joined: Tue Jul 14, 2009 4:03 pm

CG Calendar search result MySQL error

Post 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!
spacetacular
New Member
New Member
Posts: 9
Joined: Tue Jul 14, 2009 4:03 pm

Re: CG Calendar search result MySQL error

Post 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.
spacetacular
New Member
New Member
Posts: 9
Joined: Tue Jul 14, 2009 4:03 pm

Re: CG Calendar search result MySQL error

Post by spacetacular »

Rolled back modules back to CGCalendar 1.5.1 and CGExtensions 1.19.2. It works with these versions.
Post Reply

Return to “Modules/Add-Ons”