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

Database error when sorting responses by "Groups"

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      Prerequisite:

      course with

      • at least two groups (e.g. group-1, group-2)
      • a user enroled as teacher
      • two or more users enroled as student
      • student-1 assigned to on group
      • student-2 assigned to two groups

      Testing scenario:

      1. Log in as teacher in the course.
      2. Create a new feedback instance.
      3. Define the "Question and submission settings" as "User's name will be logged and shown with answers".
      4. Save this new instance.
      5. Open this instance and create at least one new question.
      6. Log in as student-1 and complete this feedback.
      7. Log in as student-2 and complete this feedback.
      8. Log in as teacher again.
      9. Open the feedback instance and click on "Show responses".
      10. You will see the response table with the responses you've made before.
      11. Check the header of the column "Groups" is not a link, so it is not sortable.

       

      Show
      Prerequisite: course with at least two groups (e.g. group-1, group-2) a user enroled as teacher two or more users enroled as student student-1 assigned to on group student-2 assigned to two groups Testing scenario: Log in as teacher in the course. Create a new feedback instance. Define the "Question and submission settings" as "User's name will be logged and shown with answers". Save this new instance. Open this instance and create at least one new question. Log in as student-1 and complete this feedback. Log in as student-2 and complete this feedback. Log in as teacher again. Open the feedback instance and click on "Show responses". You will see the response table with the responses you've made before. Check the header of the column "Groups" is not a link, so it is not sortable.  
    • Affected Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_37_STABLE, MOODLE_38_STABLE
    • Pull from Repository:
    • Pull 3.8 Branch:
    • Pull Master Branch:
      MDL-67894-master

      Description

      At the "Show responses" page is a column "Groups". This column is defined as "sortable" and can be clicked. But if you click it a database error is show because there is no column "groups" in the SELECT statement called "groups".

      Test instructions to reproduce:

      You need a user who is enroled as student in the course you are testing with.

      1. Log in as trainer in your course.
      2. Create a new feedback instance.
      3. Define the "Question and submission settings" as "User's name will be logged and shown with answers".
      4. After saving open this instance and create at least one new question.
      5. Log in as a student and complete this feedback.
      6. Log in as trainer again.
      7. Open the feedback instance and click on "Show responses".
      8. You will see the table with the at least one response you've made before.
      9. Click on the column head "Groups" to sort this table by groups.
      10. The database error message appears.

        Attachments

          Activity

            People

            Assignee:
            grabs Andreas Grabs
            Reporter:
            grabs Andreas Grabs
            Peer reviewer:
            Amaia Anabitarte
            Integrator:
            Sara Arjona (@sarjona)
            Tester:
            Anna Carissa Sadia
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
            Votes:
            7 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              9/Mar/20

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 7 hours, 20 minutes
                7h 20m