*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()