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

ldap enrol.php contains reserved oracle keyword in sql

    XMLWordPrintable

    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.)

        Attachments

          Activity

            People

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            smily03 Chris Myers
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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