-
Bug
-
Resolution: Fixed
-
Blocker
-
1.9
-
None
-
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
- will help resolve
-
CONTRIB-286 Problems when upgrading Questionnaire in Postgres
-
- Resolved
-