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

Warnings on upgrade from 2.2.7 to 2.2.8

    XMLWordPrintable

    Details

    • Testing Instructions:
      1. Install a moodle 2.2.7 site (older than 2a9af190)
      2. Upgrade it to MOODLE_22_STABLE integration branch
      3. No warnings/errors should occur during the upgrade
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE
    • Pull from Repository:
      git@github.com:totara/moodle.git

      Description

      *Steps to reproduce*

      1. Install a fresh Moodle 2.2.7 site
      2. Replace the code with the 2.2.8 code
      3. 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
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markn Mark Nelson
              Reporter:
              simoncoggins Simon Coggins
              Peer reviewer:
              Mark Nelson
              Integrator:
              Damyon Wiese
              Tester:
              David Monllaó
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                13/May/13