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

Error writing to table in Grade

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:
      None
    • Affected Branches:
      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

              Assignee:
              andyjdavis Andrew Davis
              Reporter:
              vrrandall Vernellia Randall
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: