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

Fixes for upgrade issues (from 1.6 to 1.8 on Postgres 8.1)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.4, 1.9
    • Fix Version/s: 1.6.6, 1.7.4, 1.8.4, 1.9, 2.0
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Linux 2.6.22, Ubuntu 7.10, Postgres 8.1
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      While doing an upgrade from 1.6.? to MOODLE_18_STABLE for a client, I had to remove a few calls to rebuild_course_cache() which were interfering with the upgrade process:

      • 16_to_18_upgrade_on_postgres.patch

      Then, I compared the database schemas of a fresh MOODLE_18_STABLE install with the upgraded database and fixed the following discrepancies:

      • mod-exercise_add_late_field.patch: add the 'late' field which was missing from exercise_submissions
      • mod-scorm_version_field.patch: add the 'version' field which was missing from scorm
      • question-type-rqp_missing_servers_table.patch: adds the missing 'question_rqp_servers' table

      These patches are against:

      • MOODLE_18_STABLE
      • MOODLE_19_STABLE
      • CVSHEAD

      except for the rqp question type one since it's no longer part of the core. I have committed a fix for that one in contrib HEAD.

      After making these changes, I was able to upgrade this install of Moodle 1.6 to 1.8 without any errors or differences in the schema.

      Francois

        Gliffy Diagrams

          Attachments

          1. 16_to_18_upgrade_log.html
            711 kB
          2. 16_to_18_upgrade_on_postgres_16STABLE.patch
            0.0 kB
          3. 16_to_18_upgrade_on_postgres_16STABLE.patch
            1 kB
          4. 16_to_18_upgrade_on_postgres_17STABLE.patch
            0.4 kB
          5. 16_to_18_upgrade_on_postgres_17STABLE.patch
            2 kB
          6. 16_to_18_upgrade_on_postgres_18STABLE.patch
            0.4 kB
          7. 16_to_18_upgrade_on_postgres_18STABLE.patch
            2 kB
          8. 16_to_18_upgrade_on_postgres_19STABLE.patch
            0.4 kB
          9. 16_to_18_upgrade_on_postgres_19STABLE.patch
            2 kB
          10. 16_to_18_upgrade_on_postgres_CVSHEAD.patch
            0.4 kB
          11. 16_to_18_upgrade_on_postgres_CVSHEAD.patch
            2 kB
          12. mod-exercise_add_late_field_16STABLE.patch
            2 kB
          13. mod-exercise_add_late_field_17STABLE.patch
            2 kB
          14. mod-exercise_add_late_field_18STABLE.patch
            2 kB
          15. mod-exercise_add_late_field_18STABLE.patch
            2 kB
          16. mod-exercise_add_late_field_19STABLE.patch
            2 kB
          17. mod-exercise_add_late_field_19STABLE.patch
            2 kB
          18. mod-exercise_add_late_field_19STABLE.patch
            2 kB
          19. mod-exercise_add_late_field_CVSHEAD.patch
            2 kB
          20. mod-exercise_add_late_field_CVSHEAD.patch
            2 kB
          21. mod-scorm_version_field_16STABLE.patch
            0.5 kB
          22. mod-scorm_version_field_16STABLE.patch
            0.5 kB
          23. mod-scorm_version_field_18STABLE.patch
            1 kB
          24. mod-scorm_version_field_19STABLE.patch
            1 kB
          25. mod-scorm_version_field_19STABLE.patch
            1 kB
          26. mod-scorm_version_field_CVSHEAD.patch
            1 kB
          27. mod-scorm_version_field_CVSHEAD.patch
            1 kB
          28. question-type-rqp_missing_servers_table_16STABLE.patch
            2 kB
          29. question-type-rqp_missing_servers_table_17STABLE.patch
            2 kB
          30. question-type-rqp_missing_servers_table_18STABLE.patch
            2 kB

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Jan/08