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

ERROR: Colum "attemptstepid" does not exits

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.1.5, 2.2.2
    • 2.1.4, 2.2.1, 2.3
    • Quiz
    • MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • MOODLE_21_STABLE, MOODLE_22_STABLE
    • 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.

      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 "

            timhunt Tim Hunt
            rjerz Rick Jerz
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Sam Hemelryk Sam Hemelryk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.