Project

General

Profile

Σφάλματα #298

Group by mysql: group creation

Added by George Miliotis over 4 years ago. Updated over 4 years ago.

Status:
Νέα
Priority:
Κανονική
Target version:
-
Start date:
26/05/2020
Due date:
% Done:

0%

Estimated time:

Description

In file modules\group\group_creation.php on line 177 : Unable to execute statement:"'eclass-hg.u.surname' isn't in GROUP BY", sqlstate:"1055", errornum:"42000", statement:"SELECT u.id, u.surname, u.givenname, u.am FROM (user u, course_user cu) WHERE cu.course_id = 1 AND cu.user_id = u.id AND cu.status = 5 AND u.id NOT IN (SELECT user_id FROM group_members, `group` WHERE `group`.id = group_members.group_id AND `group`.course_id = ?) GROUP BY u.id ORDER BY u.surname, u.givenname", elapsed:1590490405

Warning: Invalid argument supplied for foreach() in D:\www\openeclass-hg\modules\group\group_creation.php on line 189

History

#1

Updated by George Miliotis over 4 years ago

Rev 23811

Also available in: Atom PDF