Hi, I have an issue when I try to update grade weight. This is the error message:
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 '25,sortorder = '2',display = '0',decimals = NULL,locked = '0',locktime = '0',...' at line 1
UPDATE mdl0g_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=?
Here are my moodle info:
- Moodle 3.9.2
- PHP 7.4.8 on Moodle server
- Database MariaDB 10.5 with utf8mb4_general_ci server connection collation
- Moodle has dbtype mariadb with dblibrary native, mysqli charset is utf8mb4.
What can I do to resolve this problem?