Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-343

Module: Questionnaire - Installation error with changed field default value during creation of questionnaire_survey table

XMLWordPrintable

    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      Mike,

      I confirmed the error mentioned by Jonathan at: http://moodle.org/mod/forum/discuss.php?d=93024

      To reproduce I downloaded the 19STABLE branch of questionnaire and popped it into a fresh 1.9 install. When I went to the notification page it started to set things up properly and then errored on the questionnaire_survey table creation.

      I'm not sure exactly what is intended to happen on creating a new table. Looking at the upgrade, it appears as though this was initially a timestamp field that you are in the process of converting to an integer field to be more "Moodle-like". In any case, the current definition in install.xml causes an error. One quick work around is to simply remove the default value parameter so that line 45 reads:

      <FIELD NAME="changed" TYPE="datetime" NOTNULL="false" SEQUENCE="false" ENUM="false" PREVIOUS="thank_body"/>

      Since this prevents a successful install, I'm marking this as a blocker. Let me know if you have any questions.

      Peace - Anthony

            mchurch Mike Churchward
            aborrow Anthony Borrow
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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