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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.6.6, 1.7.4, 1.8.4, 1.9, 2.0
    • 1.8.4, 1.9
    • Database SQL/XMLDB
    • None
    • Linux 2.6.22, Ubuntu 7.10, Postgres 8.1
    • PostgreSQL
    • MOODLE_18_STABLE, MOODLE_19_STABLE
    • MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      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

        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

            francois Francois Marier
            francois Francois Marier
            Nobody Nobody
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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