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

Grading Bug

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Gradebook
    • Labels:
      None
    • Environment:
      windows 2003, MSSQL, IIS
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      I login as a teacher, editing my lesson.
      At the administrator block, I clicked the GRADE link and I got....

      [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to bigint.

      SELECT COUNT(DISTINCT u.id) FROM mdl_grade_grades g RIGHT OUTER JOIN mdl_user u ON (u.id = g.userid AND g.itemid = lastname) LEFT JOIN mdl_role_assignments ra ON u.id = ra.userid WHERE ra.roleid in (5) AND ra.contextid IN (24,20,1)
      line 686 of lib\dmllib.php: call to debugging()
      line 379 of lib\dmllib.php: call to get_recordset_sql()
      line 361 of grade\report\grader\lib.php: call to count_records_sql()
      line 140 of grade\report\grader\index.php: call to grade_report_grader->get_numusers()

        Attachments

        1. patch_mssql.txt
          1.0 kB
          Mathieu Petit-Clair
        2. usq-oracle-graderlib-accesslib.patch
          3 kB
          Jonathon Fowler

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              lowjiunjack Low Jiun Jack
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08