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

Assignments not listed for grading ("No items listed")

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 1.7
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Environment:
      Solaris 10 + apache 2.2 or Windows 2003 with IIS6, PHP 5.1.6, Oracle.
    • Database:
      Oracle
    • Affected Branches:
      MOODLE_17_STABLE

      Description

      When trying to grade assignments, the system informs there are four assignments for grading, but upon clicking through to the summary screen, none are listed.

      The problem occurs because of an SQL statement that fails in Oracle. I worked around the problem, by changing two lines of mod/assignment/lib.php to allow the SQL to be executed by oracle.
      on line 835, I changed "((s.timemarked > 0) AND (s.timemarked >= s.timemodified)) AS status" to "\'Unknown\' AS status". I also removed the extra "u.id" from the select line (it is specified twice).

      The same changes were made on line 1094.

        Attachments

          Activity

            People

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            redcane Mark Hetherington
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: