-
Bug
-
Resolution: Fixed
-
Critical
-
2.2.8
-
MOODLE_22_STABLE
-
MOODLE_22_STABLE
-
git@github.com:totara/moodle.git
-
- Install a moodle 2.2.7 site (older than 2a9af190)
- Upgrade it to MOODLE_22_STABLE integration branch
- No warnings/errors should occur during the upgrade
*Steps to reproduce*
- Install a fresh Moodle 2.2.7 site
- Replace the code with the 2.2.8 code
- Visit the notification page to trigger the upgrade
What should happen
Upgrade should complete without errors
What happens
The following errors are displayed during upgrade:
mod_label
|
|
|
XMLDB has detected one CHAR NOT NULL column (name) with '' (empty string) as DEFAULT value. This type of columns must have one meaningful DEFAULT declared or none (NULL). XMLDB have fixed it automatically changing it to none (NULL). The process will continue ok and proper defaults will be created accordingly with each DB requirements. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 208 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 94 of /mod/label/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_label_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
XMLDB has detected one TEXT/BINARY column (intro) with some DEFAULT defined. This type of columns cannot have any default value. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 214 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 95 of /mod/label/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_label_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
Success
|
mod_survey
|
|
|
XMLDB has detected one TEXT/BINARY column (intro) with some DEFAULT defined. This type of columns cannot have any default value. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 214 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 71 of /mod/survey/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_survey_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
XMLDB has detected one CHAR NOT NULL column (questions) with '' (empty string) as DEFAULT value. This type of columns must have one meaningful DEFAULT declared or none (NULL). XMLDB have fixed it automatically changing it to none (NULL). The process will continue ok and proper defaults will be created accordingly with each DB requirements. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 208 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 72 of /mod/survey/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_survey_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
XMLDB has detected one TEXT/BINARY column (answer1) with some DEFAULT defined. This type of columns cannot have any default value. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 214 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 74 of /mod/survey/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_survey_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
XMLDB has detected one TEXT/BINARY column (answer2) with some DEFAULT defined. This type of columns cannot have any default value. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 214 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 75 of /mod/survey/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_survey_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
XMLDB has detected one CHAR NOT NULL column (intro) with '' (empty string) as DEFAULT value. This type of columns must have one meaningful DEFAULT declared or none (NULL). XMLDB have fixed it automatically changing it to none (NULL). The process will continue ok and proper defaults will be created accordingly with each DB requirements. Please fix it in source (XML and/or upgrade script) to avoid this message to be displayed.
|
line 2000 of /lib/datalib.php: call to debugging()
|
line 426 of /lib/xmldb/xmldb_object.php: call to xmldb_debug()
|
line 208 of /lib/xmldb/xmldb_field.php: call to xmldb_object->debug()
|
line 104 of /lib/xmldb/xmldb_field.php: call to xmldb_field->setDefault()
|
line 62 of /lib/xmldb/xmldb_field.php: call to xmldb_field->set_attributes()
|
line 76 of /mod/survey/db/upgrade.php: call to xmldb_field->__construct()
|
line 540 of /lib/upgradelib.php: call to xmldb_survey_upgrade()
|
line 271 of /lib/upgradelib.php: call to upgrade_plugins_modules()
|
line 1437 of /lib/upgradelib.php: call to upgrade_plugins()
|
line 269 of /admin/index.php: call to upgrade_noncore()
|
Success
|
- is a regression caused by
-
MDL-38003 Sites installed with Moodle version < 1.7 using Postgres have null database columns
-
- Closed
-