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

Exception when add Category description in Course datasource

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 4.0.2
    • 4.0
    • Report builder
    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide
      1. Log in as admin
      2. Navigate to Reports in user menu
      3. Create new report from Courses report source, with default setup
      4. Add Course category > Description column
      5. Confirm column was added without exceptions
      Show
      Log in as admin Navigate to  Reports  in user menu Create new report from Courses report source, with default setup Add  Course category > Description  column Confirm column was added without exceptions

      Since category description is a nullable column, when is added to course report datasource shown an exception (if the {course_categories}.description value is equal to NULL)

      Reference: https://github.com/moodle/moodle/blob/1a744030d639f93f2a147d40f0a38572fa0f846d/lib/db/install.xml#L124

      We also need to check the same for {cohort}.description entity column

        1. category_description.jpg
          category_description.jpg
          85 kB
        2. MDL-74710_master.png
          MDL-74710_master.png
          96 kB
        3. MDL-74710_v400.png
          MDL-74710_v400.png
          92 kB

            carlos.castillo@moodle.com Carlos Castillo
            carlos.castillo@moodle.com Carlos Castillo
            Paul Holden Paul Holden
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 35 minutes
                1h 35m

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