Σφάλματα #298
Group by mysql: group creation
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
Updated by