|
|
|
Issue Links:
|
Dependency
|
|
This issue will help resolve:
|
|
CONTRIB-286
Problems when upgrading Questionnaire in Postgres
|
|
|
|
|
|
|
|
| Database: |
PostgreSQL
|
| Participants: |
Anthony Borrow and Mike Churchward
|
| Security Level: |
None
|
| Resolved date: |
11/Apr/08
|
| Affected Branches: |
MOODLE_19_STABLE
|
| Fixed Branches: |
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
|
|
Description
|
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 |
Show » |
|
Peace - Anthony 
Bug
