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

Error sorting feedback responses, when using Oracle DB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 4.0.7, 4.1.2
    • 3.8.6, 3.9.3, 3.10, 4.0.6, 4.1.1
    • Feedback
    • Oracle
    • MOODLE_310_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE, MOODLE_401_STABLE
    • MOODLE_400_STABLE, MOODLE_401_STABLE
    • MDL-70613-401
    • Hide

      Test on Oracle DB and another one (e.g. PostgreSQL)

      1. Log in as admin
      2. Create two new users
      3. Create course
      4. Enrol both users as students
      5. Add a Feedback activity to the course
      6. Press Edit questions > Add question > Short text answer
        • Question: Q1
        • Label: Short text
      7. Press Add question > Multiple choice
        • Question: Q2
        • Label: Multi choice
        • Multiple choice values:

          Cat
          Dog
          

      8. Log out
      9. Log in as first user
      10. Navigate to Feedback activity in course
      11. Press Answer the questions
        • Q1: Apples
        • Q2: Dog
        • Submit, then log out
      12. Log in as second user
      13. Navigate to Feedback activity in course
      14. Press Answer the questions
        • Q1: Bananas
        • Q2: Cat
        • Submit, then log out
      15. Log in as admin
      16. Navigate to Feedback activity in course
      17. Press Responses
      18. Sort by Q1 and Q2 table columns
      19. Confirm they sort both ascending and descending without producing exceptions
      Show
      Test on Oracle DB and another one (e.g. PostgreSQL) Log in as admin Create two new users Create course Enrol both users as students Add a Feedback activity to the course Press Edit questions > Add question > Short text answer Question: Q1 Label: Short text Press Add question > Multiple choice Question: Q2 Label: Multi choice Multiple choice values: Cat Dog Log out Log in as first user Navigate to Feedback activity in course Press Answer the questions Q1: Apples Q2: Dog Submit, then log out Log in as second user Navigate to Feedback activity in course Press Answer the questions Q1: Bananas Q2: Cat Submit, then log out Log in as admin Navigate to Feedback activity in course Press Responses Sort by Q1 and Q2 table columns Confirm they sort both ascending and descending without producing exceptions

      When sorting the responses for a "Feedback" activity (click on the column you want to sort by - feedback1.png), a DB error appears (feedback2.png) :

      "Debug info: ORA-00932: inconsistent data types: expected - gotten CLOB "

            pholden Paul Holden
            jaume77 Jaume Rocarias
            Carlos Escobedo Carlos Escobedo
            Jun Pataleta Jun Pataleta
            CiBoT CiBoT
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 55 minutes
                2h 55m

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