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

admin/tool/monitor A not null field does not contain a default value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.6.2
    • Fix Version/s: None
    • Component/s: Administration
    • Labels:
      None
    • Affected Branches:
      MOODLE_36_STABLE

      Description

      In the XMLDB for the admin/tool/monitor and in the definition of the table tool_monitor_events, the field link is declared as not null but not given a default value.

      Please add a DEFAULT='' to remedy this issue

       

      Thanks

       

      Running a test on all install.xml files, the list of not null no sequence fields without a default value given is large and extends to both core and non core plugins. 

       

      Here is the command pipe where all plugins with the same issue can be listed 

      for f in $(find $PWD -name install.xml);do grep -n 'NOTNULL="true"' ${f} /dev/null | grep 'SEQUENCE="false"'|grep -v 'DEFAULT=';done| awk -F '/db/' '{print $1}' | awk -F '/test36/' '{print $2}'| sort -u 

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              amfipolis VASILEIOS SOTIRAS
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: