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

ORA error when admin wants to view the uploaded files from students (Assignments - Advanced uploading of files)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7, 1.7.1, 1.8
    • Fix Version/s: 1.7.3, 1.8.1, 1.9
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2
    • Database:
      Oracle
    • URL:
      /mod/assignment/submissions.php?id=x
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      Some of our students have uploaded files, but neither teachers nor admins can view these files...
      (/mod/assignment/submissions.php?id=x)

      The following ORA error (see screenshot) is displayed, if developer-messages is switched on.

      ORA-00918: Spalte nicht eindeutig definiert (column ambiguously defined)

      SELECT u.id, u.id, u.firstname, u.lastname, u.picture,
      s.id AS submissionid, s.grade, s.submissioncomment,
      s.timemodified, s.timemarked FROM m_user u LEFT JOIN m_assignment_submissions s ON u.id = s.userid
      AND s.assignment = 1 WHERE u.id IN (4,5) ORDER BY lastname ASC

      • line 677 of lib/dmllib.php: call to debugging()
      • line 918 of lib/dmllib.php: call to get_recordset_sql()
      • line 1116 of mod/assignment/lib.php: call to get_records_sql()
      • line 560 of mod/assignment/lib.php: call to assignment_base->display_submissions()
      • line 43 of mod/assignment/submissions.php: call to assignment_base->submissions()

        Attachments

          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:
              Fix Release Date:
              11/Jun/07