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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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:

      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',
      )]

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              nebgor 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
              nebgor 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
              poltawski Dan Poltawski added a comment -

              Thanks Damyon, i've integrated that now.

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

              no error found...
              works as described
              Thanks

              Show
              ankit_frenz Ankit Agarwal added a comment - no error found... works as described Thanks
              Hide
              poltawski 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
              poltawski 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
              marycooch 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
              marycooch 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:
                    Fix Release Date:
                    3/Dec/12