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

Gradebook System hangs when there is calculated fields

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Minor
    • None
    • 3.6.2
    • Gradebook
    • None
    • 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

              Unassigned Unassigned
              tigger996 Lori Bakken
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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