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

upgrade from 3.0.5. to 3.1.2. gives errors on database upgrade

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 3.1.3
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Testing Instructions:
      Hide
      1. Install Moodle 3.0
      2. Create some tags, for example, add interests to users or tag wiki pages or quiz questions
      3. Mark some tags as "standard" through Site administration > Appearance > Manage tags page
      4. Upgrade to Moodle 3.1
      5. Make sure the same tags are marked as standard on manage tags page
      6. Repeat with upgrade from 3.0 to master
      Show
      Install Moodle 3.0 Create some tags, for example, add interests to users or tag wiki pages or quiz questions Mark some tags as "standard" through Site administration > Appearance > Manage tags page Upgrade to Moodle 3.1 Make sure the same tags are marked as standard on manage tags page Repeat with upgrade from 3.0 to master
    • Affected Branches:
      MOODLE_31_STABLE
    • Fixed Branches:
      MOODLE_31_STABLE
    • Pull Master Branch:
      wip-MDL-55990-master

      Description

      Hi there,
      I was running a moodle in 2.7. That was working fine. After a while I installed a new webserver and migrated the whole moodle to that server. After doing this I did an upgrade to moodle 3.0.5.
      There were no errors at that moment. But our theme required a higher version. So I tried to upgrade my 3.0.5. version to 3.1.2. Everything works fine up to when the database has to be changed.. the first thing that happens is: _
      DDL sql execution error

      More information about this error

      Debug info: Key column 'tagtype' doesn't exist in table
      CREATE INDEX mdl_tag_tagtag_ix ON mdl_tag (tagcollid, tagtype)
      Error code: ddlexecuteerror
      _
      And it will not continue... Been trying to fix this for 2 days and am at a loss. Does anyone know what I should do?
      thanx in advance
      pascal Geuze

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/Nov/16