The category filter seems to work OK on the full calendar display, but on the list displays I don't see anything at all.
With debug set on in my config.php I see the following message which seems to be the cause:
Code: Select all
(mysqli): SELECT DISTINCT E.event_id FROM tadcaste_module_cgcalendar_events E
INNER JOIN tadcaste_module_cgcalendar_events_to_categories EC ON E.event_id = EC.event_id
INNER JOIN tadcaste_module_cgcalendar_categories C ON EC.category_id = C.category_idWHERE (E.event_date_start >= '2016-04-26 00:00:01') OR (E.event_date_end > '2016-04-26 00:00:01') AND (C.category_name = 'Training') ORDER BY E.event_date_start ASC LIMIT 1000
Error (1305): FUNCTION C.category_idWHERE does not exist Cms Version: 2.1.3
Installed Modules:
AdminSearch: 1.0.1
CGCalendar: 2.1.1
CGExtensions: 1.53.2
CGSimpleSmarty: 2.1
CGSmartImage: 1.21.3
CMSContentManager: 1.1
CMSMailer: 6.2.14
Captcha: 0.5.2
DesignManager: 1.1.1
FileManager: 1.5.2
FormBuilder: 0.8.1.3
Gallery: 2.1.3
MicroTiny: 2.0.3
ModuleManager: 2.0.2
Navigator: 1.0.3
News: 2.50.5
Search: 1.50.2
TinyMCE: 3.1.2
Config Information:
php_memory_limit:
max_upload_size: 16000000
url_rewriting: mod_rewrite
page_extension: .html
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: Europe/London
permissive_smarty: false
