Details
Bug
Closed
Major
Description
I've seen sites with a lot of group members who are deleted. They are still displayed in the interface and caused a lot of confusion.
mysql> select count
from mdl_user u, mdl_groups_members m WHERE u.id = m.userid AND u.deleted = 1;
We need to clean this up in upgrade & also ensure the group members are deleted when removing courses & users etc.
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
Role assignments look ok, but don't know about how many of these we care about:
mysql> select count from mdl_user u, mdl_forum_subscriptions s WHERE u.id = s.userid AND u.deleted = 1;
----------
| count |
----------
| 13 |
----------
1 row in set (0.07 sec)
mysql> select count from mdl_user u, mdl_user_preferences p WHERE u.id = p.userid AND u.deleted = 1;
----------
| count |
----------
| 1232 |
----------
1 row in set (0.12 sec)
mysql> select count from mdl_user u, mdl_user_lastaccess a WHERE u.id = a.userid AND u.deleted = 1;
----------
| count |
----------
| 4546 |
----------
1 row in set (0.03 sec)
Also user_info_data? blogs?
from mdl_user u, mdl_forum_subscriptions s WHERE u.id = s.userid AND u.deleted = 1;
----------
| count |
| 13 |
from mdl_user u, mdl_user_preferences p WHERE u.id = p.userid AND u.deleted = 1;
----------
| count |
| 1232 |
from mdl_user u, mdl_user_lastaccess a WHERE u.id = a.userid AND u.deleted = 1;
----------
| count |
| 4546 |
I guess something like delete m from mdl_user u, mdl_groups_members m WHERE u.id = m.userid AND u.deleted = 1;