Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
1.7.1
-
None
-
Windows 2003, Php 5.12, Sql 2005
-
Microsoft SQL
-
MOODLE_17_STABLE
-
MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
Description
line 1095 in lib.php in assignments is a good example:
$select = 'SELECT u.id, u.id, u.firstname, u.lastname, u.picture, s.id AS submissionid, s.grade, s.submissioncomment, s.timemodified, s.timemarked, ((s.timemarked > 0) AND (s.timemarked >= s.timemodified)) AS status ';
returns no records for sql 2005
if changed to the following it works:
$select = 'SELECT u.id, u.id, u.firstname, u.lastname, u.picture, s.id AS submissionid, s.grade, s.submissioncomment, s.timemodified, s.timemarked, ';
if ($CFG->dbtype == 'mssql' || $CFG->dbtype == 'odbc_mssql' || $CFG->dbtype == 'mssql_n')
else
{ $select .=' ((s.timemarked > 0) AND (s.timemarked >= s.timemodified)) AS status '; }Attachments
Issue Links
- will help resolve
-
MDL-10846 Sorting submitted assignments by status makes all assignments disappear
-
- Closed
-