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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 1.8
    • Database SQL/XMLDB
    • None
    • Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2
    • Oracle
    • MOODLE_18_STABLE
    • /user/view.php?id=x&course=y

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

            stronk7 Eloy Lafuente (stronk7)
            protzek D P
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.