Assignments not displaying in week blocks

Re: Assignments not displaying in week blocks

by Huw Dixon -
Number of replies: 0
FYI -
Spent several hours poking around the moodle tables. Finally stumbled across mdl_course_sections and found it had some doubled entries for these two problematic weeks:

$mysql> select * from mdl_course_sections where course = 4 and (section = 11 or section = 12);
+----+--------+---------+---------+-------------------------+---------+
| id | course | section | summary | sequence | visible |
+----+--------+---------+---------+-------------------------+---------+
| 69 | 4 | 11 | | 102,103,107,114,118,121 | 1 |
| 70 | 4 | 11 | | NULL | 1 |
| 71 | 4 | 12 | | 108,110,112,113 | 1 |
| 72 | 4 | 12 | | NULL | 1 |
+----+--------+---------+---------+-------------------------+---------+
4 rows in set (0.00 sec)

I figured the latest ones were being used as the section to print. I deleted them and now the weeks display with all assignments just fine. Dunno how the sections got duplicated in the first place.

peace