Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-1692

MSSQL doesn't allow text or ntext columns in GROUP BY clause

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.7
    • Fix Version/s: 1.9.7, 2.0
    • Component/s: Module: Questionnaire
    • Labels:
      None
    • Environment:
      Moodle : Fedora 10, Apache-2.2, PHP-5.2
      Database : Microsoft SQL
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      Description:
      The "View All Responses" in Questionnaire Report fails to retrieve the responses of type text, bool, date and single from the MS-SQL database.
      This is mainly due to the issue in using fields of type text in GROUP BY clause. The following methods in questiontypes/questiontypes.class.php are affected by this bug:
      1. get_response_text_results()
      2. get_response_date_results()
      3. get_response_single_results()
      4. get_response_rank_results

      Steps to reproduce:
      1. Create a questionnaire with question type "text box", "drop box" and "date"
      2. Login as student and attempt the questionnaire
      3. Login again as administrator/teacher and click on "All Responses" tab in the Questionnaire.

      Expected Result:
      All responses should list all the questions with their responses

      Actual Result:
      The responses of "text box", "date", and "drop box type " are not displayed.

        Attachments

        1. essayboxanswer.jpg
          essayboxanswer.jpg
          16 kB
        2. essayboxTxt.txt
          0.0 kB
        3. screenshot-1.jpg
          screenshot-1.jpg
          151 kB
        4. screenshot-2.jpg
          screenshot-2.jpg
          25 kB

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  25/Nov/09