-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
3.9.11, 3.10.8, 3.11.4
-
MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_39_STABLE
-
MDL-73309-master
-
Category events itself also remain untouched in the database, when the category is deleted and courses within are moved.
The orphaned event subscriptions cause \core\task\calendar_cron_task to show these errors.
Execute scheduled task: Send calendar notifications (core\task\calendar_cron_task)
|
... started 23:55:24. Current memory use 60.8MB.
|
Updating calendar subscription Course Subscription in course 11
|
Error updating calendar subscription: Can't find data record in database table course. (SELECT id,category FROM {course} WHERE id = ?
|
[array (
|
0 => '11',
|
)])
|
Updating calendar subscription Group Subscription in course 11
|
Error updating calendar subscription: Can't find data record in database table course. (SELECT id,category FROM {course} WHERE id = ?
|
[array (
|
0 => '11',
|
)])
|
Updating calendar subscription Category Subscription in course 0
|
Error updating calendar subscription: Can't find data record in database table course_categories. (SELECT id,parent FROM {course_categories} WHERE id = ?
|
[array (
|
0 => '4',
|
)])
|
Replicating steps:
- Create a top course category "Category 1"
- Create a course "Course 1" within Category 1 and enrol yourself
- Create a group "Group 1" within Course 1
- In the Course Calendar, click on "Manage subscriptions"
- Once each for Category 1, Course 1, Group 1, import a calendar (for example the moodle release calendar https://www.google.com/calendar/ical/moodle.com_p4c2oe7hsb77ltaro5qtihb5d4%40group.calendar.google.com/public/basic.ics)
- Go to Site Adminstration > Courses > Manage courses and categories
- Delete Category 1 and choose "Move content to another category"
- Delete Course 1
- Run UPDATE mdl_event_subscriptions SET pollinterval = 1; in the DB, so you don't have to wait.
- Run cron
- The output for \core\task\calendar_cron_task shows the error for each of the three calendar subscriptions
- The category events are still in the event table.
- has a non-specific relationship to
-
MDL-66551 Orphaned users calendar subscriptions
- Closed
-
MDL-79435 Deleting category with calendar event subscription orphans subscription data
- Closed
-
MDL-66605 Consider removal of events on user deletion
- Open
- is duplicated by
-
MDL-79435 Deleting category with calendar event subscription orphans subscription data
- Closed