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

1.9->2.x upgrade: Unknown error upgrading mod_resource to version 2009062600, can not continue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.2.11
    • Component/s: Unknown
    • Labels:
      None
    • Environment:
      cPanel access.
    • Database:
      MySQL
    • Testing Instructions:
      Hide

      1/ install 1.9.x and all different resource types
      2/ add several more resources
      3/ go to DB and change the last two course_modules.instance fields to point to different resource (one from the same, other from different course)
      4/ upgrade to 2.2.x
      5/ verify the resources were upgraded correctly

      Show
      1/ install 1.9.x and all different resource types 2/ add several more resources 3/ go to DB and change the last two course_modules.instance fields to point to different resource (one from the same, other from different course) 4/ upgrade to 2.2.x 5/ verify the resources were upgraded correctly
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE
    • Pull from Repository:

      Description

      Giving error during upgrade process.

      • line 154 of /lib/upgradelib.php: upgrade_exception thrown
      • line 107 of /mod/resource/db/upgrade.php: call to upgrade_mod_savepoint()
      • line 490 of /lib/upgradelib.php: call to xmldb_resource_upgrade()
      • line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
      • line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
      • line 302 of /admin/index.php: call to upgrade_noncore()

        Gliffy Diagrams

          Issue Links

            Activity

            tguy890 Timothy Guy created issue -
            skodak Petr Skoda made changes -
            Field Original Value New Value
            Affects Version/s 2.0 [ 10122 ]
            Affects Version/s 1.9.7 [ 10360 ]
            skodak Petr Skoda made changes -
            Assignee moodle.com [ moodle.com ] Petr ?koda (skodak) [ skodak ]
            skodak Petr Skoda made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            skodak Petr Skoda made changes -
            Assignee Petr Škoda (skodak) [ skodak ] moodle.com [ moodle.com ]
            Fix Version/s STABLE backlog [ 10463 ]
            dougiamas Martin Dougiamas made changes -
            Workflow jira [ 40278 ] MDL Workflow [ 47098 ]
            dougiamas Martin Dougiamas made changes -
            Workflow MDL Workflow [ 47098 ] MDL Full Workflow [ 75300 ]
            blepoxp Glenn Ansley made changes -
            Link This issue has a non-specific relationship to MDL-29451 [ MDL-29451 ]
            markn Mark Nelson made changes -
            Assignee moodle.com [ moodle.com ] Mark Nelson [ markn ]
            markn Mark Nelson made changes -
            Affects Version/s STABLE Sprint 28 Alpha [ 12450 ]
            markn Mark Nelson made changes -
            Parent MDL-34086 [ 57118 ]
            Rank (Obsolete) 23470000000
            Issue Type Bug [ 1 ] Sub-task [ 5 ]
            markn Mark Nelson made changes -
            Assignee Mark Nelson [ markn ] moodle.com [ moodle.com ]
            dougiamas Martin Dougiamas made changes -
            Summary Unknown error upgrading mod_resource to version 2009062600, can not continue. When upgrading to Moodle 2.0 1.9->2.x upgrade: Unknown error upgrading mod_resource to version 2009062600, can not continue
            dougiamas Martin Dougiamas made changes -
            Fix Version/s BACKEND [ 12582 ]
            dougiamas Martin Dougiamas made changes -
            Parent MDL-34086 [ 57118 ]
            Issue Type Sub-task [ 5 ] Bug [ 1 ]
            dougiamas Martin Dougiamas made changes -
            Rank Ranked lower
            skodak Petr Skoda made changes -
            Testing Instructions 1/ install 1.9.x
            2/ add some resources
            3/ go to DB and delete some cm records for resources
            4/ upgrade to 2.2.x
            skodak Petr Skoda made changes -
            Assignee moodle.com [ moodle.com ] Petr Škoda [ skodak ]
            skodak Petr Skoda made changes -
            Status Open [ 1 ] Development in progress [ 3 ]
            skodak Petr Skoda made changes -
            Status Development in progress [ 3 ] Waiting for integration review [ 10010 ]
            Pull from Repository git://github.com/skodak/moodle.git
            Fix Version/s 2.2.11 [ 12655 ]
            Fix Version/s STABLE backlog [ 10463 ]
            Fix Version/s BACKEND [ 12582 ]
            Testing Instructions 1/ install 1.9.x
            2/ add some resources
            3/ go to DB and delete some cm records for resources
            4/ upgrade to 2.2.x
            1/ install 1.9.x
            2/ add several resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            Pull 2.2 Diff URL https://github.com/skodak/moodle/compare/MOODLE_22_STABLE...w24_MDL-25248_m22_reshacks
            Pull 2.2 Branch w24_MDL-25248_m22_reshacks
            skodak Petr Skoda made changes -
            Testing Instructions 1/ install 1.9.x
            2/ add several resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            1/ install 1.9.x and add different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            samhemelryk Sam Hemelryk made changes -
            Currently in integration Yes [ 10041 ]
            poltawski Dan Poltawski made changes -
            Status Waiting for integration review [ 10010 ] Integration review in progress [ 10004 ]
            Integrator poltawski
            poltawski Dan Poltawski made changes -
            Testing Instructions 1/ install 1.9.x and add different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            1/ install 1.9.x and four different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            poltawski Dan Poltawski made changes -
            Testing Instructions 1/ install 1.9.x and four different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            1/ install 1.9.x and all different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            poltawski Dan Poltawski made changes -
            Status Integration review in progress [ 10004 ] Reopened [ 4 ]
            cibot CiBoT made changes -
            Status Reopened [ 4 ] Reopened [ 4 ]
            Currently in integration Yes [ 10041 ]
            skodak Petr Skoda made changes -
            Status Reopened [ 4 ] Waiting for integration review [ 10010 ]
            skodak Petr Skoda made changes -
            Testing Instructions 1/ install 1.9.x and all different resource types
            2/ add several more resources
            3/ go to DB and change the last two cm->instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            1/ install 1.9.x and all different resource types
            2/ add several more resources
            3/ go to DB and change the last two course_modules.instance fields to point to different resource (one from the same, other from different course)
            4/ upgrade to 2.2.x
            5/ verify the resources were upgraded correctly
            poltawski Dan Poltawski made changes -
            Status Waiting for integration review [ 10010 ] Integration review in progress [ 10004 ]
            Currently in integration Yes [ 10041 ]
            poltawski Dan Poltawski made changes -
            Status Integration review in progress [ 10004 ] Waiting for testing [ 10005 ]
            dmonllao David Monllaó made changes -
            Tester rwijaya
            rwijaya Rossiani Wijaya made changes -
            Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
            rwijaya Rossiani Wijaya made changes -
            Status Testing in progress [ 10011 ] Tested [ 10006 ]
            marina Marina Glancy made changes -
            Status Tested [ 10006 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Currently in integration Yes [ 10041 ]
            Integration date 14/Jun/13
            stronk7 Eloy Lafuente (stronk7) made changes -
            Affects Version/s STABLE Sprint 28 Alpha [ 12450 ]

              People

              • Votes:
                13 Vote for this issue
                Watchers:
                18 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  8/Jul/13