Dzień dobry,
po podniesieniu PHP z 7.2 do 7.4 (MariaDB 10.5, Moodle 3.10.1+ (Build: 20210204) ) w dodawaniu do istniejącego kursu quizu pojawia się błąd:
Debug info: You have an error in
your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near '125,sortorder =
'2',display = '0',decimals = NULL,locked = '0',locktime = '0'...' at
line 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 => '1149',
1 => '1002',
2 => 'Test nr 1 - Logistyka w systemie gospodarczym',
3 => 'mod',
4 => 'quiz',
5 => '753',
6 => '0',
7 => NULL,
8 => '',
9 => NULL,
10 => '1',
11 => 10.0,
12 => 0.0,
13 => NULL,
14 => NULL,
15 => '0.00000',
16 => 1.0,
17 => 0.0,
18 => 0.0,
19 => 0.125,
20 => '2',
21 => '0',
22 => NULL,
23 => '0',
24 => '0',
25 => 1,
26 => '0',
27 => '1603715242',
28 => 1613372434,
29 => '1',
30 => '4265',
)]
Error code: dmlwriteexception
Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1587 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1619 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 307 of /lib/grade/grade_item.php: call to grade_object->update()
line 1743 of /lib/grade/grade_category.php: call to grade_item->update()
line 453 of /lib/grade/grade_category.php: call to grade_category->auto_update_weights()
line 1182 of /lib/gradelib.php: call to grade_category->pre_regrade_final_grades()
line 378 of /course/modlib.php: call to grade_regrade_final_grades()
line 180 of /course/modlib.php: call to edit_module_post_actions()
line 168 of /course/modedit.php: call to add_moduleinfo()