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

PIVOT is a new reserved word in MSSQL. It makes the glossary module unusable at all

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.7
    • 1.7
    • Database SQL/XMLDB
    • None
    • MSSQL
    • Microsoft SQL
    • MOODLE_17_STABLE
    • MOODLE_17_STABLE

      PIVOT is reserved word for MSSQL 2005 (due to some functions using that name).

      The glossary module is full of: SELECT xxx AS pivot FROM.... and all those sentences are broken!

      Solution: Change all those AS PIVOT ocurrences to another thing (ideas are welcome) and change all the ocurrences of PIVOT inside the module too.

      Trick: To be able to do it easily, I propose to change all the "pivot" ocurrences to "glossarypivot" or something similar. Trying it tomorrow.

            lazyfish Yu Zhang
            stronk7 Eloy Lafuente (stronk7)
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.