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

Setting display type for the main course item causes an error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.4
    • Fix Version/s: 1.9.5
    • Component/s: Gradebook
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      1. Start with a course that has some stuff in it. 2 categories in my case, no extra settings different to the defaults.
      2. go to the edit categories and items page
      3. click on the uppermost edit icon in the cateogry table, next to the course name
      4. set the display type to 'Real (letter)' and click save
      5. get this error:

      Out of range value for column 'decimals' at row 1

      UPDATE mdl_grade_items SET courseid = '216',categoryid = NULL,itemname = '',itemtype = 'course',itemmodule = NULL,iteminstance = '269',itemnumber = NULL,iteminfo = '',idnumber = '',calculation = '=sum(##gi742##,##gi744##)',gradetype = '1',grademax = '100',grademin = '0',scaleid = NULL,outcomeid = NULL,gradepass = '0.00000',multfactor = '1',plusfactor = '0',aggregationcoef = '0',sortorder = '1',display = '13',decimals = '-1',hidden = '0',locked = '0',locktime = '0',needsupdate = '1',timecreated = '1212392853',timemodified = '1241515328' WHERE id = 726

      • line 1704 of lib\dmllib.php: call to debugging()
      • line 205 of lib\grade\grade_object.php: call to update_record()
      • line 277 of lib\grade\grade_item.php: call to grade_object->update()
      • line 593 of lib\grade\grade_item.php: call to grade_item->update()
      • line 160 of grade\edit\tree\category.php: call to grade_item->set_hidden()

      Out of range value for column 'decimals' at row 1

      UPDATE mdl_grade_items SET courseid = '216',categoryid = NULL,itemname = '',itemtype = 'course',itemmodule = NULL,iteminstance = '269',itemnumber = NULL,iteminfo = '',idnumber = '',calculation = '=sum(##gi742##,##gi744##)',gradetype = '1',grademax = '100',grademin = '0',scaleid = NULL,outcomeid = NULL,gradepass = '0.00000',multfactor = '1',plusfactor = '0',aggregationcoef = '0',sortorder = '1',display = '13',decimals = '-1',hidden = '0',locked = '0',locktime = '0',needsupdate = '1',timecreated = '1212392853',timemodified = '1241515328' WHERE id = 726

      • line 1704 of lib\dmllib.php: call to debugging()
      • line 205 of lib\grade\grade_object.php: call to update_record()
      • line 277 of lib\grade\grade_item.php: call to grade_object->update()
      • line 549 of lib\grade\grade_item.php: call to grade_item->update()
      • line 163 of grade\edit\tree\category.php: call to grade_item->set_locktime()

      Out of range value for column 'decimals' at row 1

      UPDATE mdl_grade_items SET courseid = '216',categoryid = NULL,itemname = '',itemtype = 'course',itemmodule = NULL,iteminstance = '269',itemnumber = NULL,iteminfo = '',idnumber = '',calculation = '=sum(##gi742##,##gi744##)',gradetype = '1',grademax = '100',grademin = '0',scaleid = NULL,outcomeid = NULL,gradepass = '0.00000',multfactor = '1',plusfactor = '0',aggregationcoef = '0',sortorder = '1',display = '13',decimals = '-1',hidden = '0',locked = '0',locktime = '0',needsupdate = '1',timecreated = '1212392853',timemodified = '1241515329' WHERE id = 726

      • line 1704 of lib\dmllib.php: call to debugging()
      • line 205 of lib\grade\grade_object.php: call to update_record()
      • line 277 of lib\grade\grade_item.php: call to grade_object->update()
      • line 507 of lib\grade\grade_item.php: call to grade_item->update()
      • line 164 of grade\edit\tree\category.php: call to grade_item->set_locked()

      Error output, so disabling automatic redirect.

        Attachments

          Activity

            People

            Assignee:
            skodak Petr Skoda
            Reporter:
            mattgibson Matt Gibson
            Tester:
            Sam Hemelryk
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              13/May/09