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

Enrolment sync need to be cross-db

    XMLWordPrintable

    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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jerome Jérôme Mouneyrac
              Reporter:
              jerome Jérôme Mouneyrac
              Tester:
              Mathieu Petit-Clair
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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