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

Error sorting feedback responses, when using Oracle DB

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • 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

    Description

      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 "

      Attachments

        Issue Links

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Clockify

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