CMS MADE SIMPLE FORGE

CMS Made Simple Core

 
Back Back to List

[#12457] Event Manager empty list when mysql mode only_full_group_by

avatar
Created By: Ruud van der Velden (ruudvdvelden)
Date Submitted: Thu May 27 14:51:47 -0400 2021

Assigned To: Ruud van der Velden (ruudvdvelden)
Version: 2.2.15
CMSMS Version: 2.2.15
Severity: Major
Resolution: Fixed
State: Open
Summary:
Event Manager empty list when mysql mode only_full_group_by
Detailed Description:
Enable SQL mode ONLY_FULL_GROUP_BY and then open Extensions > Event Manager
The list will be empty.

Problem in lib\classes\class.Events.php line 210

$q = 'SELECT e.*, count(eh.event_id) as usage_count FROM '.CMS_DB_PREFIX.
			'events e left outer join '.CMS_DB_PREFIX.
'event_handlers eh on e.event_id=eh.event_id GROUP BY e.event_id ORDER BY
originator,event_name';

ERROR (hidden by CMSMS)
#1055 - 'cw.e.event_name' isn't in GROUP BY


History

Comments
avatar 
Date: 2021-06-12 12:03
Posted By: Ruud van der Velden (ruudvdvelden)

fixed in svn for 2.2.16
Updates

Updated: 2021-06-12 12:06
resolution_id: 5 => 7

Updated: 2021-06-12 12:03
resolution_id: => 5
assigned_to_id: 100 => 18365