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

ldap enrol.php contains reserved oracle keyword in sql

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.10
    • Fix Version/s: 1.9.11
    • Component/s: Enrolments
    • Labels:
    • Environment:
      SLES 11 SP1, Oracle 11i
    • Database:
      Oracle
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      /enrol/ldap/enrol.php contains sql which has an Oracle reserved keyword ("...as user,1") in it, so the sql doesn't execute. (the error message is about "from" not being where it's expected. when you try to execute the select statement in PL/SQL Developer, it underlines the word "user" in the part about ...as user, telling you that it's a reserved keyword.)

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  21/Feb/11