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

Appear the error Out of range value for column 'hidden' at row 1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 3.10.9, 3.11.5, 4.0
    • None
    • Gradebook
    • None
    • MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_400_STABLE

    Description

      *DESCRIPTION*

      When try to enable the item "hidden until" and modify the date on the gradebook setup from a grade category course, it display the following error message
       

      Error writing to database

      More information about this error
      ×Debug info: Out of range value for column 'hidden' at row 1
      UPDATE mdl_grade_categories SET courseid = ?,parent = ?,depth = ?,path = ?,fullname = ?,aggregation = ?,keephigh = ?,droplow = ?,aggregateonlygraded = ?,aggregateoutcomes = ?,timecreated = ?,timemodified = ?,hidden = ? WHERE id=?
      [array (
      0 => 59,
      1 => NULL,
      2 => '1',
      3 => '/73/',
      4 => '?',
      5 => '11',
      6 => '0',
      7 => '0',
      8 => 0,
      9 => 0,
      10 => '1610115516',
      11 => 1645731811,
      12 => 1645904220,
      13 => 73,
      )]
      Error code: dmlwriteexception
      ×Stack trace: * line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown

      • line 1623 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1655 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
      • line 253 of /lib/grade/grade_object.php: call to mysqli_native_moodle_database->update_record()
      • line 263 of /lib/grade/grade_category.php: call to grade_object->update()
      • line 484 of /lib/grade/grade_object.php: call to grade_category->update()
      • line 2602 of /lib/grade/grade_category.php: call to grade_object->set_hidden()
      • line 691 of /grade/edit/tree/lib.php: call to grade_category->set_hidden()
      • line 137 of /grade/edit/tree/category.php: call to grade_edit_tree::update_gradecategory()
        *STEPS TO REPLICATE*

      1) Log in into a course gradebook setup

      2) Click on edit settings on the top grade folder

      3) Enable the "hidden until" option and modify the default date.

      4) Save changes.

      OBSERVED BEHAVIOR:

      Displays an error message

      *REPLICATION  VERSIONS*

      Moodle 3.11.3 (Build: 20210913)
      Moodle 3.11.2+ (Build: 20210827)
      Moodle 4.0dev+ (Build: 20220129)

      *ADDITIONAL INVESTIGATION NOTES*

      Debug message
      Error writing to database

      More information about this error
      ×Debug info: Out of range value for column 'hidden' at row 1
      UPDATE mdl_grade_categories SET courseid = ?,parent = ?,depth = ?,path = ?,fullname = ?,aggregation = ?,keephigh = ?,droplow = ?,aggregateonlygraded = ?,aggregateoutcomes = ?,timecreated = ?,timemodified = ?,hidden = ? WHERE id=?
      [array (
      0 => 59,
      1 => NULL,
      2 => '1',
      3 => '/73/',
      4 => '?',
      5 => '11',
      6 => '0',
      7 => '0',
      8 => 0,
      9 => 0,
      10 => '1610115516',
      11 => 1645731811,
      12 => 1645904220,
      13 => 73,
      )]
      Error code: dmlwriteexception
      ×Stack trace: * line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown

      • line 1623 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1655 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
      • line 253 of /lib/grade/grade_object.php: call to mysqli_native_moodle_database->update_record()
      • line 263 of /lib/grade/grade_category.php: call to grade_object->update()
      • line 484 of /lib/grade/grade_object.php: call to grade_category->update()
      • line 2602 of /lib/grade/grade_category.php: call to grade_object->set_hidden()
      • line 691 of /grade/edit/tree/lib.php: call to grade_category->set_hidden()
      • line 137 of /grade/edit/tree/category.php: call to grade_edit_tree::update_gradecategory()

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cbohorquez Cristhian Bohorquez
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: