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

Too short mdl_log.action causing "Could not insert a new entry to the Moodle log"

XMLWordPrintable

    • MOODLE_22_STABLE
    • Hide

      The work-around is to adjust the size of log.action manually, to 40.

      Show
      The work-around is to adjust the size of log.action manually, to 40.

      The log.action column on our Moodle instance is varchar(15) (MySQL) and it should be:
      <FIELD NAME="action" TYPE="char" LENGTH="40" NOTNULL="true" SEQUENCE="false" PREVIOUS="cmid" NEXT="url"/>
      The instance was upgraded from 1.9 to 2.2 - I imagine that something during an upgrade went wrong and column was no resized.

      Easy way to reproduce it is to simply re-start a quiz, "continue attempt" message is too long (16 characters).

      One way of dealing with it would be to add check like "Check indexes" or "Check defaults" from XMLDB editor, that would check if the column sizes are as defined in install.xml.

            moodle.com Moodle HQ
            tmuras Tomasz Muras
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

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