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

get_my_courses() broken on MSSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a bug
    • Affects Version/s: 1.8.3
    • Fix Version/s: 1.8.4
    • Component/s: Roles / Access
    • Labels:
      None
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE

      Description

      One of the SQL queries in gmc is concatenating ctx.path with an id field. MSSQL barfs at the idea of casting the numeric id.

      Credit for the fix to Dennis Rochford <Dennis.Rochford@usq.edu.au>

      [I initially misinterpreted the patch - thinking that the implicit CAST caused Oracle to complain. It is MSSQL that complains about it.]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Jan/08