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

ERROR: Colum "attemptstepid" does not exits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1.4, 2.2.1, 2.3
    • Fix Version/s: 2.1.5, 2.2.2
    • Component/s: Quiz
    • Labels:
    • Testing Instructions:
      Hide

      It is quite tricky to reproduce this bug, so you will need to follow these instructions closely.

      1. Create a quiz set to use interactive behaviour with one short-answer question as follows:
      Question name: Regrade test.
      Question text: What is the best amphibian?
      Answer 1 -> Answer: Toad
      Answer 1 -> Grade: 100%
      Hint 1 -> Hint text: Hint 1

      2. Attempt the quiz as a student.

      3. First, give the response 'Frog' and click Check.

      4. Click Try again.

      5. Give the response 'Toad' and click Check.

      6. Click Next

      7. Click Submit all and finish.

      8. Now, as teacher, edit the question and change
      Answer 1 -> Answer: Frog

      9. Go to Results -> Grades, and click the regrade all button.

      10. Verify that the student's grade changes from 66.67% (or whatever it was) to 100%, and more importantly that there are no fatal errors.

      Having tested this specific case, you are encouraged to test some other regrades, to help verify that there are no other regressions I have not thought of.

      Show
      It is quite tricky to reproduce this bug, so you will need to follow these instructions closely. 1. Create a quiz set to use interactive behaviour with one short-answer question as follows: Question name: Regrade test. Question text: What is the best amphibian? Answer 1 -> Answer: Toad Answer 1 -> Grade: 100% Hint 1 -> Hint text: Hint 1 2. Attempt the quiz as a student. 3. First, give the response 'Frog' and click Check. 4. Click Try again. 5. Give the response 'Toad' and click Check. 6. Click Next 7. Click Submit all and finish. 8. Now, as teacher, edit the question and change Answer 1 -> Answer: Frog 9. Go to Results -> Grades, and click the regrade all button. 10. Verify that the student's grade changes from 66.67% (or whatever it was) to 100%, and more importantly that there are no fatal errors. Having tested this specific case, you are encouraged to test some other regrades, to help verify that there are no other regressions I have not thought of.
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE
    • Pull from Repository:
    • Pull Master Branch:
    • Pull Master Diff URL:

      Description

      Bjorn Hilmarsson mentioned in the moodle.org forum a problem with regrading quizzes. Tim Hunt noted the bug, and suggested to Bjorn to post it in tracker. I am doing this on behalf of both Bjorn and Tim. Tim said he would fix this bug quickly.

      Forum = http://moodle.org/mod/forum/discuss.php?d=197277#p859974

      Error =

      "We have a large moodle website for the university of iceland and we are not able to do regrade all we get this error message:

      Debug: ERROR: column "attemptstepid" does not exist\nLINE 1: DELETE FROM mdl_question_attempt_steps WHERE attemptstepid =...\n ^\nDELETE FROM "

        Attachments

          Issue Links

          is a regression caused by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-30484 Regrading quiz causes essay attachments to disappear

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

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              rjerz Rick Jerz
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              Sam Hemelryk
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/Mar/12