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

ORA error: 904 invalid column name on profile page (Admin)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2
    • Database:
      Oracle
    • URL:
      /user/view.php?id=x&course=y
    • Affected Branches:
      MOODLE_18_STABLE

      Description

      Please take a look at the screenshot!
      Similar errors occur - when logged in as course creator - on the front page!
      There seems to be no loss of function...besides the error message...

      ORA-00904: Ungültiger Spaltenname (invalid column name)

      SELECT c.* FROM m_role_assignments ra INNER JOIN m_context x ON x.id=ra.contextid INNER JOIN m_course c ON x.instanceid=c.id AND x.contextlevel=50 WHERE ra.userid=2 UNION SELECT c.* FROM m_role_assignments ra INNER JOIN m_context x ON x.id=ra.contextid INNER JOIN m_course_categories a ON x.instanceid=a.id AND x.contextlevel=40 INNER JOIN m_course c ON c.category=a.id WHERE ra.userid=2 UNION SELECT c.* FROM m_role_capabilities ca INNER JOIN m_context x ON x.id=ca.contextid AND x.contextlevel=50 INNER JOIN m_course c ON c.id=x.instanceid WHERE ca.contextid 1 AND ca.capability='moodle/course:view' ORDER BY visible DESC,sortorder ASC

      • line 677 of lib/dmllib.php: call to debugging()
      • line 746 of lib/datalib.php: call to get_recordset_sql()
      • line 302 of user/view.php: call to get_my_courses()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              protzek D P
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: