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

Forum summary report multiplies counts by number of enrollments a user has

    XMLWordPrintable

Details

    • MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_39_STABLE
    • MOODLE_310_STABLE, MOODLE_311_STABLE
    • MDL-71029-311
    • MDL-71029-master
    • Hide

      Setup

      1. Log in as admin.
      2. Create a new course
      3. On the enrolment page, click on the cog and select Enrolment methods
      4. Enable Self enrolment (Student) enrol method
      5. Go to course and create a new forum changing Display word count to Yes.

      Testing

      1. In another window, log in as s1
      2. Go to the course and enrol yourself.
      3. As admin, go to the enrolment page and enrol s1 as student again, this time as a manual enrolment.
      4. As s1, go to the forum and add a discussion post, please make note of the number of words and count the number of chars in your sentence.
      5. As admin, go to the forum, click on the cog and select Forum summary report
      6. Make sure the number of discussions posted is 1.
      7. Make sure the Word count and Character count matches the actual counts.
      Show
      Setup Log in as admin. Create a new course On the enrolment page, click on the cog and select Enrolment methods Enable Self enrolment (Student) enrol method Go to course and create a new forum changing Display word count to Yes . Testing In another window, log in as s1 Go to the course and enrol yourself. As admin , go to the enrolment page and enrol s1 as student again, this time as a manual enrolment. As s1 , go to the forum and add a discussion post, please make note of the number of words and count the number of chars in your sentence. As admin, go to the forum, click on the cog and select Forum summary report Make sure the number of discussions posted is 1. Make sure the Word count and Character count matches the actual counts.
    • 0
    • Internationals - 4.0 Sprint 1, HQ Team International Sprint 2, HQ Team International Sprint 3, HQ Team International Sprint 4, HQ Team International Sprint 5, HQ Team International Sprint 6, HQ Team International Sprint 7

    Description

      Sometimes our users have more than one enrollment, for example they may have started as self enrolled but later were enrolled officially. As a result, the forum summary report will double the number of posts it says the user has made. One of our users had three enrollments and his posts were tripled in the forum summary report. This problem is especially bad for meta courses because you cannot drop one of the enrollments.

      Attachments

        1. MDL-71029_master Forum Summary Report.png
          MDL-71029_master Forum Summary Report.png
          54 kB
        2. MDL-71029_master Word Count.png
          MDL-71029_master Word Count.png
          58 kB
        3. MDL-71029_v3.10 Forum Summary Report.png
          MDL-71029_v3.10 Forum Summary Report.png
          54 kB
        4. MDL-71029_v3.10 Word Count.png
          MDL-71029_v3.10 Word Count.png
          32 kB
        5. MDL-71029_v3.11 Forum Summary Report.png
          MDL-71029_v3.11 Forum Summary Report.png
          51 kB
        6. MDL-71029_v3.11 Word Count.png
          MDL-71029_v3.11 Word Count.png
          55 kB
        7. query_original.png
          query_original.png
          1.21 MB
        8. query_with_subquery.png
          query_with_subquery.png
          1.40 MB
        9. subquery.patch
          5 kB
        10. v1.sql
          2 kB
        11. v2.sql
          3 kB

        Activity

          People

            dongsheng Dongsheng Cai
            dsoini Diane Soini
            Simey Lameze Simey Lameze
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Angelia Dela Cruz Angelia Dela Cruz
            Adrian Greeve, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              13/Sep/21

              Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 days, 24 minutes
                4d 24m