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

          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