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

Resources are not visible in some courses

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

      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

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            allian Procop Samuraev added a comment -

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

            Show
            allian 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: