[SOLVED] CGCalendar: error after upgrade to 1.11.4

[staartmees]

This error only occurs if I specify the category

DEBUG: query failed: SELECT COUNT(*) FROM (SELECT event_id FROM cms_module_cgcalendar_events E INNER JOIN cms_module_cgcalendar_events_to_categories EC ON E.event_id = EC.event_id INNER JOIN cms_module_cgcalendar_categories C ON EC.category_id = C.category_id WHERE (E.event_date_start >= '2013-11-04 14:32:53') OR (E.event_date_end >= '2013-11-04 14:32:53' AND COALESCE(E.event_date_end,'****') != '****') AND ((C.category_name LIKE 'publiek'))) AS sub LIMIT 1

Column 'event_id' in field list is ambiguous



----------------------------------------------

Cms Version: 1.11.9

Installed Modules:

CMSMailer: 5.2.2
FileManager: 1.4.3
MenuManager: 1.8.6
ModuleManager: 1.5.5
News: 2.13
nuSOAP: 1.0.2
Search: 1.7.11
ThemeManager: 1.1.8
TinyMCE: 2.9.12
CustomContent: 1.9
Play: 0.5.2
FormBuilder: 0.7.4
LinkMgr: 1.5.1
FrontEndUsers: 1.22
CGExtensions: 1.37.3
Gallery: 1.6.1
CGCalendar: 1.11.4
CGSimpleSmarty: 1.7
CMSPrinting: 1.0.5
CMSSimplepie: 1.0
Captcha: 0.4.6
Showtime: 3.3
CGFeedMaker: 1.0.17


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 96000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.3.27
md5_function: Aan (Waar)
gd_version: 2
tempnam_function: Aan (Waar)
magic_quotes_runtime: Uit (Onwaar)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 50
output_buffering: Aan
safe_mode: Uit (Onwaar)
file_uploads: Aan (Waar)
post_max_size: 96M
upload_max_filesize: 96M
session_save_path: Geen controle omdat 'open_basedir' actief is
session_use_cookies: Aan (Waar)
xml_function: Aan (Waar)
xmlreader_class: Aan (Waar)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysql)
Server Db Version: 5.1.66
Server Db Grants: Er is een "GRAND ALL" permissie gevonden, alles lijkt in orde.
Server Time Diff: Geen tijdverschil aangetroffen


----------------------------------------------

[calguy1000]

Thanks. Issue fixed in svn. I'll release a new version shortly.