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

Resources are not visible in some courses

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 1.9.17, 2.2.2
    • Course, Resource
    • None
    • MOODLE_19_STABLE, MOODLE_22_STABLE

      Resources are not visible in some courses.
      If you enable debug mode when you try to add a resource have a output:
      SELECT * FROM mdl_course_sections WHERE section = '39 'AND course = '40' (with limits 0 and 100)
      Found more than one record in get_record_sql!

      On table mdl_course_sections I see multiple entries for one section and the courses. see a screenshot.
      If I remove. duplicate entries then all is well.
      With the query I've found a lot more of these duplicates.
      SELECT s1.id AS id1, s1.course, s1.section, s2.id AS id2
      FROM mdl_course_sections s1
      INNER JOIN mdl_course_sections s2 ON s2.id > s1.id
      AND s1.section = s2.section
      AND s1.course = s2.course
      LIMIT 0 , 30

            moodle.com Moodle HQ
            allian Procop Samuraev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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