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

Database error when sorting responses by "Groups"

XMLWordPrintable

    • MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
    • MOODLE_37_STABLE, MOODLE_38_STABLE
    • MDL-67894-master
    • 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.  

      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.

        1. MDL-67894.PNG
          MDL-67894.PNG
          78 kB

            grabs Andreas Grabs
            grabs Andreas Grabs
            Amaia Anabitarte Amaia Anabitarte
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Anna Carissa Sadia Anna Carissa Sadia
            Votes:
            7 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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