Moodle
  1. Moodle
  2. MDL-32331

Resources are not visible in some courses

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.9.17, 2.2.2
    • Fix Version/s: None
    • Component/s: Course, Resource
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE, MOODLE_22_STABLE
    • Rank:
      39151

      Description

      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

        Issue Links

          Activity

          Hide
          Procop Samuraev added a comment -

          dublicat
          MDL-26706 ( Unresolved)
          MDL-32215 ( Unresolved)

          Show
          Procop Samuraev added a comment - dublicat MDL-26706 ( Unresolved) MDL-32215 ( Unresolved)

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: