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

ORA-00918: column ambiguously defined when access to grading in Assign module

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.3, 2.4
    • Fix Version/s: 2.3.2
    • Component/s: Assignment
    • Labels:
    • Environment:
      Ubuntu Server 11.10 32 bits
      PHP : 5.3.6
      BD : Oracle 10.2.0.1.0
    • Database:
      Oracle
    • Testing Instructions:
      Hide

      Important note to testers:
      Due to some regressions caused by MDL-31341, this only can be tested under 23_STABLE. Fix is 100% the same for master so it should be enough and will work the same once master is fixed (by MDL-35004).

      Pre-requisites:
      Moodle installed with Oracle database & developer debug enabled.

      Go to "View/grade all submissions" page in new assignment (assign) module.
      Verify you do not see the error described in this bug.

      Show
      Important note to testers: Due to some regressions caused by MDL-31341 , this only can be tested under 23_STABLE. Fix is 100% the same for master so it should be enough and will work the same once master is fixed (by MDL-35004 ). Pre-requisites: Moodle installed with Oracle database & developer debug enabled. Go to "View/grade all submissions" page in new assignment (assign) module. Verify you do not see the error described in this bug.
    • Workaround:
      Hide

      Use a different database

      Show
      Use a different database
    • Affected Branches:
      MOODLE_23_STABLE, MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE
    • Pull Master Branch:

      Description

      When a theacher push in link "View/grade all submissions" in a instance of a new assignment, see these error :

      Example link : "..mod/assign/view.php?id=2&action=grading"

      Debug info: ORA-00918: column ambiguously defined
      SELECT *
      FROM (SELECT
      u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email, u.id as userid, u.firstname as firstname, u.lastname as lastname, s.status as status, s.id as submissionid, s.timecreated as firstsubmission, s.timemodified as timesubmitted, g.id as gradeid, g.grade as grade, g.timemodified as timemarked, g.timecreated as firstmarked, g.mailed as mailed, g.locked as locked
      FROM m_user u LEFT JOIN m_assign_submission s ON u.id = s.userid AND s.assignment = :o_assignmentid1 LEFT JOIN m_assign_grades g ON u.id = g.userid AND g.assignment = :o_assignmentid2
      WHERE u.id IN (:o_user15,:o_user16,:o_user17,:o_user18,:o_user19,:o_user20,:o_user21,:o_user22)
      )
      WHERE rownum <= :o_oracle_num_rows
      [array (
      'o_assignmentid1' => 1,
      'o_assignmentid2' => 1,
      'o_user15' => 21,
      'o_user16' => 22,
      'o_user17' => 23,
      'o_user18' => 24,
      'o_user19' => 25,
      'o_user20' => 26,
      'o_user21' => 27,
      'o_user22' => 28,
      'o_oracle_num_rows' => 10,
      )]
      Error code: dmlreadexception
      Stack trace:

      line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 274 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
      line 1101 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      line 1362 of /lib/tablelib.php: call to oci_native_moodle_database->get_records_sql()
      line 1382 of /lib/tablelib.php: call to table_sql->query_db()
      line 642 of /mod/assign/renderer.php: call to table_sql->out()
      line 546 of /mod/assign/renderer.php: call to mod_assign_renderer->flexible_table()
      line 215 of /lib/outputrenderers.php: call to mod_assign_renderer->render_assign_grading_table()
      line 1764 of /mod/assign/locallib.php: call to plugin_renderer_base->render()
      line 1792 of /mod/assign/locallib.php: call to assign->view_grading_table()
      line 373 of /mod/assign/locallib.php: call to assign->view_grading_page()
      line 53 of /mod/assign/view.php: call to assign->view()

      Moodle plataform :

      Server : Ubuntu 11.10 Server 32 bits
      BD : Oracle 10.2.0.1.0

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  4 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    10/Sep/12