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

Gradebook System hangs when there is calculated fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 3.6.2
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:
      None
    • Affected Branches:
      MOODLE_36_STABLE

      Description

      In Moodle 3.6.2 I have a few courses that use a calculated field in their gradebook. When I go to view the gradebook, the system just hangs and the process does not stop.

       

      To fix a currently active course, I went into the db and removed the calculation from that grade item. Then my instructor could go in and proceed normally.

       

      The calculation stored in the db is and I cannot get in to edit the gradebook setup (system hangs):

      =(0.02*##gi41829##+0.01*##gi41827##+0.02*##gi19313##+0.02*##gi41831##+0.02*##gi41832##+0.02*##gi41833##+0.02*##gi41834##+0.02*##gi41835##+0.2*##gi41836##+0.10*##gi41837##+0.02*##gi41838##+0.02*##gi41839##+0.05*##gi41840##+0.02*##gi41841##+0.01*##gi41845##+0.02*##gi41842##+0.01*##gi41843##+0.3*##gi41844##+0.1*##gi41830##)

       

      I checked another course that had a calculation in it, and received this message:

      Note: Some errors have been detected in calculating the grades displayed in the gradebook. If your course has not started or is in progress, it is recommended that the errors are fixed by clicking the button below, though this will result in some grades being changed. If your course has already ended and grades have been submitted, you probably do not want to fix this issue. The newer version is 20190118; you are using gradebook version 20160518. You can see a list of changes in Gradebook calculation changes.

      In another course that has no errors

      Stored in the DB:

      =(0.025*##gi38914##+0.02*##gi38906##+0.025*##gi38915##+0.025*##gi38916##+0.02*##gi38907##+0.025*##gi38917##+0.02*##gi38908##+0.025*##gi38918##+0.2*##gi38919##+0.02*##gi38909##+0.025*##gi38921##+0.025*##gi38922##+0.03*##gi38910##+0.06*##gi38923##+0.03*##gi38913##+0.1*##gi38924##+0.3*##gi38925##+0.025*##gi45470##)

      Appears in Course item as:

      =(0.025*[[1]]+0.02*[[2]]+0.025*[[3]]+0.025*[[4]]+0.02*[[5]]+0.025*[[6]]+0.02*[[7]]+0.025*[[8]]+0.2*[[9]]+0.02*[[10]]+0.025*[[12]]+0.025*[[13]]+0.03*[[14]]+0.06*[[16]]+0.03*[[17]]+0.1*[[18]]+0.3*[[19]]+0.025*[[21]])

       

      So my issue is why doesn't the first one work, why does one give an error and why does the last one have no issue.

       

      The first one - the course is done, but might need to review grades but can't, so I need a way to fix the formula.

       

      I think this may have happened when I upgraded to 3.6.2

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              tigger996 Lori Bakken
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: