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

On some old installs that have been upgraded, the log.action column is CHAR(15), not CHAR(40)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.0
    • Fix Version/s: None
    • Component/s: Administration, Logging
    • Labels:
      None

      Description

      Go to the admin/qtypes.php. You see the number of each questions as a link to questioninstances report. However, trying to access it you get an error:

      Debug info: Data too long for column 'action' at row 1
      INSERT INTO mdl_log (time,userid,course,ip,module,cmid,action,url,info) VALUES(?,?,?,?,?,?,?,?,?)
      [array (
      0 => 1283712904,
      1 => '2',
      2 => '1',
      3 => '127.0.0.1',
      4 => 'admin',
      5 => 0,
      6 => 'report questioninstances',
      7 => 'report/questioninstances/index.php?qtype=preg',
      8 => 'preg',
      )]
      Stack trace:
      line 394 of \lib\dml\moodle_database.php: dml_write_exception thrown
      line 816 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1676 of \lib\datalib.php: call to mysqli_native_moodle_database->insert_record_raw()
      line 22 of \admin\report\questioninstances\index.php: call to add_to_log()

      Should be easy to fix thought.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              oa_sychev Oleg Sychev
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: