Error on updating to 2024042200 version on database Postgresql

[mciotti]

I got this error on updating into new version:

ERROR: column "sst.course" must appear in the GROUP BY clause or be used in an aggregate function
LINE 2: SELECT userid, scormid, attempt, course FROM mdl_loc...
^
INSERT INTO mdl_local_recompletion_sa (userid, scormid, attempt, courseid)
SELECT userid, scormid, attempt, course FROM mdl_local_recompletion_sst sst GROUP BY userid,scormid,attempt
[array (
)]
Error code: dmlwriteexception

I think it's enough to modify the select like this: SELECT userid, scormid, attempt, course FROM mdl_local_recompletion_sst sst GROUP BY userid, scormid, attempt, course

[danmarsden]

this is a duplicate of #169