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

Upgrade from 2.2 to 2.4 Failed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.6
    • Fix Version/s: 2.2.8
    • Component/s: Installation
    • Labels:
      None
    • Testing Instructions:
      Hide

      1/ install any 1.9-2.2 moodle version before this patch
      2/ execute upgrade to this patched version
      3/ verify there are no notices or errors

      Show
      1/ install any 1.9-2.2 moodle version before this patch 2/ execute upgrade to this patched version 3/ verify there are no notices or errors
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE
    • Pull from Repository:

      Description

      I am building an upgrade path from our legacy moodle 1.9 instances to moodle 2.4. My upgrade system works well when I upgrade from 1.9 to 2.2 using the CLI systems, but I get a problem that Google has no answer for when I try to then leap-frog from 2.2 to 2.4.

      Here is the error:
      http://goo.gl/EK1yn

      Debug info: Out of range value for column 'sortorder' at row 106
      ALTER TABLE `mdl_course` MODIFY COLUMN `sortorder` bigint(10) signed NOT NULL DEFAULT '0'
      Error code: ddlexecuteerror
      Stack trace:

      line 432 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      line 860 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 139 of /lib/db/upgradelib.php: call to mysqli_native_moodle_database->change_database_structure()
      line 232 of /lib/db/upgrade.php: call to upgrade_mysql_fix_unsigned_columns()
      line 1493 of /lib/upgradelib.php: call to xmldb_main_upgrade()
      line 284 of /admin/index.php: call to upgrade_core()

      I don't often post, so please give me feedback as to more information that I can give on the subject. I don't want to brain-dump everything about the instance for fear of getting tl;dr from everyone who could help me, so I want to know what's relevant.

      These are the exact packages I am using.
      http://downloads.sourceforge.net/project/moodle/Moodle/stable22/moodle-latest-22.tgz?r=&ts=1355340759&use_mirror=superb-dca2
      http://downloads.sourceforge.net/project/moodle/Moodle/stable24/moodle-latest-24.tgz?r=&ts=1355355328&use_mirror=superb-dca3

        Attachments

          Activity

            People

            • Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Mar/13