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

Error writing to table in Grade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • 2.0.1
    • None
    • Gradebook
    • None
    • MOODLE_20_STABLE

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              andyjdavis Andrew Davis
              vrrandall Vernellia Randall
              Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: