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

Trying to view submitted assignments.

    XMLWordPrintable

Details

    • 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

              andyjdavis Andrew Davis
              terragraves Terra Graves
              Jake Dallimore, Mathew May, Mihail Geshoski, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: