Moodle
  1. Moodle
  2. MDL-36064

Assignment : Revert to draft for Team Assignments gives database error.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4
    • Component/s: Assignment
    • Labels:
    • Testing Instructions:
      Hide

      Create an assignment and set:

      • Require students click submit button to "Yes"
      • Students submit in teams to "Yes"
      • Online text to "Yes"

      Login as a student and make a submission to the assignment
      Submit the assignment for marking
      Login as a grader and choose "Revert to draft" from the drop down menu on the submission row in the assignment grading table.

      Verify you do not see the error listed in the description of this bug.

      Show
      Create an assignment and set: Require students click submit button to "Yes" Students submit in teams to "Yes" Online text to "Yes" Login as a student and make a submission to the assignment Submit the assignment for marking Login as a grader and choose "Revert to draft" from the drop down menu on the submission row in the assignment grading table. Verify you do not see the error listed in the description of this bug.
    • Affected Branches:
      MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE
    • Pull Master Branch:
    • Rank:
      44826

      Description

      Using the revert to draft feature for a team assignment generates a database error.

      ERROR : null value in column "grader" violates not-null constraint
      UPDATE mdl_assign_grades SET assignment = $1,userid = $2,timecreated = $3,timemodified = $4,grader = $5,grade = $6,locked = $7,mailed = $8,extensionduedate = $9 WHERE id=$10
      [array (
      'assignment' => '2',
      'userid' => '2',
      'timecreated' => '1348817880',
      'timemodified' => 1350348633,
      'grader' => NULL,
      'grade' => '66.00000',
      'locked' => '0',
      'mailed' => '1',
      'extensionduedate' => '0',
      0 => '7',
      )]

        Issue Links

          Activity

          Hide
          Aparup Banerjee added a comment -

          The main moodle.git repository has just been updated with latest weekly modifications. You may wish to rebase your PULL branches to simplify history and avoid any possible merge conflicts. This would also make integrator's life easier next week.

          TIA and ciao

          Show
          Aparup Banerjee added a comment - The main moodle.git repository has just been updated with latest weekly modifications. You may wish to rebase your PULL branches to simplify history and avoid any possible merge conflicts. This would also make integrator's life easier next week. TIA and ciao
          Hide
          Dan Poltawski added a comment -

          Thanks Damyon, i've integrated that now.

          Show
          Dan Poltawski added a comment - Thanks Damyon, i've integrated that now.
          Hide
          Ankit Agarwal added a comment -

          no error found...
          works as described
          Thanks

          Show
          Ankit Agarwal added a comment - no error found... works as described Thanks
          Hide
          Dan Poltawski added a comment -

          Hurray!

          You did it, congratulations! You have on Mojito credit to redeem after the release of Moodle 2.4

          Show
          Dan Poltawski added a comment - Hurray! You did it, congratulations! You have on Mojito credit to redeem after the release of Moodle 2.4
          Hide
          Mary Cooch added a comment -

          Hi there. I am unable to "revert to draft" not only with group assignments but also individual assignments both on QA Moodle and my localhost Moodle 2.4dev (Build: 20121101) Whenever I try, the "submitted for grading" statement doesn't change.

          Show
          Mary Cooch added a comment - Hi there. I am unable to "revert to draft" not only with group assignments but also individual assignments both on QA Moodle and my localhost Moodle 2.4dev (Build: 20121101) Whenever I try, the "submitted for grading" statement doesn't change.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: