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

Upgrade from 2.2 to 2.4 Failed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2.8
    • 2.2.6
    • Installation
    • None
    • MOODLE_22_STABLE
    • MOODLE_22_STABLE
    • 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

      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

            skodak Petr Skoda
            jcapinc Jeffrey Parrish
            Sam Hemelryk Sam Hemelryk
            Frédéric Massart Frédéric Massart
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.