Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-30370 Meta: Oracle SQL issues
  3. MDL-30700

Error sorting assignment submissions by comment (in Oracle)

    XMLWordPrintable

Details

    • Oracle
    • MOODLE_21_STABLE, MOODLE_22_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • MDL-30700-master
    • Hide

      As far as clob datatype isn't allowed in an order by sentence, I suppose that those datatype columns should be casted in allowed datatypes somehow.

      Show
      As far as clob datatype isn't allowed in an order by sentence, I suppose that those datatype columns should be casted in allowed datatypes somehow.
    • Hide

      Test pre-requisites - Oracle on Moodle 2.2, Moodle 2.3 and Moodle 2.5-dev

      1. Create an advanced uploading of files (Assignment 2.2) in a course with some students
      2. Click the "No attempts have been made on this assignment" link
      3. Grade the first student and add a feedback comment
      4. Grade the second student and add a feedback comment
      5. Click on the column header "Comment" to sort by the feedback comments
      6. Verify the column is sorted correctly by the feedback comments
      7. Click on the "Update" link for one of the submissions to update the feedback/grades
      8. Verify you see the grading page for that submission and not an error.
      Show
      Test pre-requisites - Oracle on Moodle 2.2, Moodle 2.3 and Moodle 2.5-dev Create an advanced uploading of files (Assignment 2.2) in a course with some students Click the "No attempts have been made on this assignment" link Grade the first student and add a feedback comment Grade the second student and add a feedback comment Click on the column header "Comment" to sort by the feedback comments Verify the column is sorted correctly by the feedback comments Click on the "Update" link for one of the submissions to update the feedback/grades Verify you see the grading page for that submission and not an error.

    Description

      When sorting the assignment submissions by comment in Oracle it crashes with ORA-00932 inconsistent datatypes: expected - got clob

      * line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
      		 
      * line 268 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
      		 
      * line 1093 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      		 
      * line 1325 of \mod\assignment\lib.php: call to oci_native_moodle_database->get_records_sql()
      		 
      * line 649 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()

      This is because the comment column (mdl_assignment_submissions.submissioncomment) datatype is CLOB, and (at least in Oracle) that kind of columns aren't allowed in the order by sentence

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-32206 Trying to view submitted assignments.

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

          Activity

            People

              damyon Damyon Wiese
              izendegi Iñigo Zendegi
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              David Monllaó David Monllaó
              Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                14/Jan/13