MySQL error I can't understand, grademax error

Question

Error that happened recently with my moodle that I can't solve, I don't know what to do. I know I need to change something from my MySQL, but I don't know what. The error is affecting only one Moodle course, causing students to neither see the issue nor solve it. The questions are VPLs.

Debug info: Out of range value for column 'grademax' at row 1
UPDATE mdl_grade_items SET courseid = ?,categoryid = ?,itemname = ?,itemtype = ?,itemmodule = ?,iteminstance = ?,itemnumber = ?,iteminfo = ?,idnumber = ?,calculation = ?,gradetype = ?,grademax = ?,grademin = ?,scaleid = ?,outcomeid = ?,gradepass = ?,multfactor = ?,plusfactor = ?,aggregationcoef = ?,aggregationcoef2 = ?,sortorder = ?,display = ?,decimals = ?,locked = ?,locktime = ?,needsupdate = ?,weightoverride = ?,timecreated = ?,timemodified = ?,hidden = ? WHERE id=?
[array (
0 => '6',
1 => NULL,
2 => NULL,
3 => 'course',
4 => NULL,
5 => '6',
6 => NULL,
7 => NULL,
8 => NULL,
9 => NULL,
10 => 1,
11 => 100103.0,
12 => 0.0,
13 => NULL,
14 => NULL,
15 => '0.00000',
16 => 1.0,
17 => 0.0,
18 => 0.0,
19 => 0.0,
20 => '1',
21 => '0',
22 => NULL,
23 => '0',
24 => '0',
25 => 1,
26 => '0',
27 => '1517923151',
28 => 1572436932,
29 => '0',
30 => '91',
)]
Error code: dmlwriteexception



Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1528 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1560 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
line 254 of /lib/grade/grade_object.php: call to mysqli_native_moodle_database->update_record()
line 307 of /lib/grade/grade_item.php: call to grade_object->update()
line 1559 of /lib/grade/grade_category.php: call to grade_item->update()
line 448 of /lib/grade/grade_category.php: call to grade_category->auto_update_max()
line 1162 of /lib/gradelib.php: call to grade_category->pre_regrade_final_grades()
line 440 of /lib/gradelib.php: call to grade_regrade_final_grades()
line 1314 of /mod/vpl/vpl.class.php: call to grade_get_grades()
line 1807 of /mod/vpl/vpl.class.php: call to mod_vpl->get_grade_info()
line 80 of /mod/vpl/view.php: call to mod_vpl->print_submission_restriction()

The value `100103.0` is apparently too large for the column. — aynber, Oct 30 '19 at 12:45

score 0 · Answer 1 · answered Oct 30 '19 at 12:47

try remove the dot form your values

UPDATE mdl_grade_items 
  SET courseid = ?
  ,categoryid = ?
  ,itemname = ?
  ,itemtype = ?
  ,itemmodule = ?
  ,iteminstance = ?
  ,itemnumber = ?
  ,iteminfo = ?
  ,idnumber = ?
  ,calculation = ?
  ,gradetype = ?
  ,grademax = ?
  ,grademin = ?
  ,scaleid = ?
  ,outcomeid = ?
  ,gradepass = ?
  ,multfactor = ?
  ,plusfactor = ?
  ,aggregationcoef = ?
  ,aggregationcoef2 = ?
  ,sortorder = ?
  ,display = ?
  ,decimals = ?
  ,locked = ?
  ,locktime = ?
  ,needsupdate = ?
  ,weightoverride = ?
  ,timecreated = ?
  ,timemodified = ?
  ,hidden = ? 
  WHERE id=?
    [array (
    0 => '6',
    1 => NULL,
    2 => NULL,
    3 => 'course',
    4 => NULL,
    5 => '6',
    6 => NULL,
    7 => NULL,
    8 => NULL,
    9 => NULL,
    10 => 1,
    11 => 100103,
    12 => 0.0,
    13 => NULL,
    14 => NULL,
    15 => '0',
    16 => 1.0,
    17 => 0.0,
    18 => 0.0,
    19 => 0.0,
    20 => '1',
    21 => '0',
    22 => NULL,
    23 => '0',
    24 => '0',
    25 => 1,
    26 => '0',
    27 => '1517923151',
    28 => 1572436932,
    29 => '0',
    30 => '91',
    )]

We don't know their table schema. It could be defined as `DECIMAL(5,2)` — aynber, Oct 30 '19 at 12:48
@aynber . a decimal don't should raise this problem .. but some integer .. .. — ScaisEdge, Oct 30 '19 at 12:50
It could if the max value is `999.99`, and they're passing in `100103.0` — aynber, Oct 30 '19 at 12:51

MySQL error I can't understand, grademax error

1 Answers1