Hi
Moodle 2.03+ SQL: 10 Windows 2008R2 IIS7.5
Started workshop for the first time with a class. Used grading by accumlative grades.
It kept on failing on grade calculations (logged in as admin) and it kept on stating Database error. (I can provide screenshots if necessary)
thanks
J.
PS Debug info below
Debug info: SQLState: 42000<br>Error Code: 169<br>Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.<br>
SELECT TOP 10 u.id AS userid,u.firstname,u.lastname,u.picture,u.imagealt,u.email,s.title AS submissiontitle, s.grade AS submissiongrade, ag.gradinggradeFROM mdl_user uLEFT JOIN mdl_workshop_submissions s ON (s.authorid = u.id AND s.workshopid = '1' AND s.example = 0)LEFT JOIN mdl_workshop_aggregations ag ON (ag.userid = u.id AND ag.workshopid = '1')WHERE u.id IN ('335','180','468','251','196','374','113','121','192','153','222','229','201','227','465','193','126','164','224','163','385','2')ORDER BY lastname ASC,u.lastname,u.firstname,u.id[array (0 => '1',1 => '1',2 => 335,3 => 180,4 => 468,5 => 251,6 => 196,7 => 374,8 => 113,9 => 121,10 => 192,11 => 153,12 => 222,13 => 229,14 => 201,15 => 227,16 => 465,17 => 193,18 => 126,19 => 164,20 => 224,21 => 163,22 => 385,23 => 2,)]Stack trace:line 391 of \lib\dml\moodle_database.php: dml_read_exception thrownline 252 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()line 368 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()line 773 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()line 807 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()line 1342 of \mod\workshop\locallib.php: call to sqlsrv_native_moodle_database->get_records_sql()line 355 of \mod\workshop\view.php: call to workshop->prepare_grading_report_data()
