Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-32206

Trying to view submitted assignments.

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_22_STABLE

      Description

      When I click on View 44 submitted assignments. I get this error:

      Error reading from database

      More information about this error

      Debug info: SQLState: 42000<br>
      Error Code: 306<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.<br>
       
      SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
      s.id AS submissionid, s.grade, s.submissioncomment,
      s.timemodified, s.timemarked,
      CASE WHEN s.timemarked > 0 AND s.timemarked >= s.timemodified THEN 1
      ELSE 0 END AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
      AND s.assignment = 34 WHERE u.id IN (3,12,25,55,85,101,105,180,199,200,201,204,205,221,223,224,226,227,228,231,240,241,242,243,244,245,247,249,250,252,253,254,256,258,259,261,262,263,265,266,267,268,269,330,429,432) ORDER BY submissioncomment ASC, grade ASC
      [array (
      )]
      Stack trace:
      line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 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 1403 of \mod\assignment\lib.php: call to sqlsrv_native_moodle_database->get_records_sql()
      line 662 of \mod\assignment\lib.php: call to assignment_base->display_submissions()
      line 369 of \mod\assignment\type\upload\assignment.class.php: call to assignment_base->submissions()
      line 57 of \mod\assignment\submissions.php: call to assignment_upload->submissions()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              andyjdavis Andrew Davis
              Reporter:
              terragraves Terra Graves
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: