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

El Profesor no puede ver las tareas creadas

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: Assignment
    • Labels:
      None
    • Database:
      Oracle
    • Affected Branches:
      MOODLE_24_STABLE

      Description

      El Profesor no puede ver las tareas creadas

      Debug info: ORA-00905: missing keyword
      SELECT COUNT(s.userid)
      FROM m_assign_submission s
      JOIN(SELECT DISTINCT eu2_u.id
      FROM m_user eu2_u
      JOIN m_role_assignments eu2_ra3 ON (eu2_ra3.userid = eu2_u.id AND eu2_ra3.roleid IN (5) AND eu2_ra3.contextid IN (1,3,57,128))
      JOIN m_user_enrolments eu2_ue ON eu2_ue.userid = eu2_u.id
      JOIN m_enrol eu2_e ON (eu2_e.id = eu2_ue.enrolid AND eu2_e.courseid = :o_eu2_courseid)
      WHERE eu2_u.deleted = 0 AND eu2_u.id <> :o_eu2_guestid) AS e ON e.id = s.userid
      WHERE
      s.assignment = :o_assignid AND
      s.timemodified IS NOT NULL AND
      s.status = :o_submissionstatus
      [array (
      'o_eu2_courseid' => '5',
      'o_eu2_guestid' => '1',
      'o_assignid' => '8',
      'o_submissionstatus' => 'draft',
      )]
      Error code: dmlreadexception
      Stack trace:

      line 426 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 1382 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_records_sql()
      line 1035 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->get_record_sql()
      line 1455 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_record_sql()
      line 1626 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      line 1268 of /mod/assign/locallib.php: call to moodle_database->count_records_sql()
      line 2846 of /mod/assign/locallib.php: call to assign->count_submissions_with_status()
      line 421 of /mod/assign/locallib.php: call to assign->view_submission_page()
      line 53 of /mod/assign/view.php: call to assign->view()

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: