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

No possibility to create a quiz

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.10.1
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:
      None
    • Affected Branches:
      MOODLE_310_STABLE

      Description

      After upgrade PHP from 7.2 to 7.4.

      MariaDB 10.5, Moodle 3.10.1+ (Build: 20210204)

      No possibility to create a quiz

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

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            mupit MUP Oswiecim
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: