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

Error writing to table in Grade

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 2.0.1
    • Gradebook
    • None
    • MOODLE_20_STABLE

      I upgrade 2.01+. After up grading I received the following error:

      Debug info: Data too long for column 'value' at row 1
      UPDATE mdl_user_preferences SET value = ? WHERE id = ?
      [array (
      0 => 'a:2:{s:14:"aggregatesonly";a:10:

      {i:5;s:3:"108";i:7;s:3:"114";i:8;s:2:"60";i:9;s:2:"59";i:10;s:2:"62";i:11;s:3:"219";i:12;s:3:"107";i:17;s:3:"218";i:18;s:2:"61";i:19;s:3:"173";}

      s:10:"gradesonly";a:4:{i:0;s:2:"69";i:1;s:3:"205";i:2;s:3:"217";i:3;s:3:"221";}}',
      1 => '806',
      )]
      Stack trace:

      • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 1031 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1441 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->set_field_select()
      • line 1416 of /lib/moodlelib.php: call to moodle_database->set_field()
      • line 1491 of /grade/report/grader/lib.php: call to set_user_preference()
      • line 104 of /grade/report/grader/index.php: call to grade_report_grader::process_action()

      The following steps initated the error:

      (3) click on course: "Race and Racism"
      (4) Click on Syllabus in left hand column
      (5) Click on Course administration in right hand column
      (6) Click on Grades
      (7) Click on "turn editing on" in right hand corner
      (8) Click on "-" by "race and racism

            andyjdavis Andrew Davis
            vrrandall Vernellia Randall (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.