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

Enrolment sync need to be cross-db

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8.6, 1.9.2, 2.0
    • Fix Version/s: 1.8.7, 1.9.3
    • Component/s: Enrolments
    • Labels:
      None
    • Environment:
      LAMP
      external database Oracle
    • Database:
      MySQL, Oracle
    • Affected Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      enrolment sync doesn't work if external database is Oracle because database field names are UPPERCASE by default on oracle. We need to convert all retrieved fieldnames from the database into lowercase (all the enrolment code considers that database fieldnames are in lowercase)

      QA


      In order to retest:

      • use Oracle and MySQL as external database
      • if could you retest with PHP4, it would be great
      • activate course>enrolment>external database plugin
      • help yourself with the moodle docs: http://docs.moodle.org/en/External_database
      • check that it works

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    15/Oct/08