c5-8.4.2: User Groups null

Permalink
The User Groups page in the Dashboard shows a few groups as 'null' (see attached). I have checked the database tables: Groups, GroupSetGroups, GroupSets, TreeGroupNodes, UserGroups and none of them has the null groups.

How can I clean that up? Where else are those null groups stored?

Thank you.

1 Attachment

linuxoid
 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Try This
Click the group name (Null) and choose 'Edit Group' > Click delete.
linuxoid replied on at Permalink Reply
linuxoid
It throws an 'Invalid Group' exception
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
How are you creating user groups, programmatically or via the dashboard.
If programmatically (in a custom theme for example) check your code for errors.
If via the dashboard turn off all caches and clear the cache, also disconnect from any external cache systems such as a server cache and clear your browser cache...
linuxoid replied on at Permalink Reply
linuxoid
It doesn't really matter how they have been created. How can I get rid of them now? Which DB table are they in?
JohntheFish replied on at Permalink Reply
JohntheFish
Other than the UserGroups table, the other data that may be corrupted would be TreeNodeGroups. Perhaps that has rows that don't correspond to current UserGroups.

The safest option may be to edit it to valid groups rather than delete rows, otherwise you will have consequential issues with other parts of the tree-node tables.

How this arose does matter. Having hacked the database to fix it, you wouldn't want to immediately recreate the problem.
linuxoid replied on at Permalink Reply 2 Attachments
linuxoid
I have already checked these tables: Groups, GroupSetGroups, GroupSets, TreeGroupNodes, UserGroups and none of them has the null group IDs, I mean they only have IDs of the 5 valid groups - see the TreeGroupNodes and Groups attached
JohntheFish replied on at Permalink Reply
JohntheFish
If all that data ties up correctly, then I don't know.

You could try tracking down the code that builds the view and add some diagnostic dumps or logging to it, or step through it in a debugger to work out what is happening.
linuxoid replied on at Permalink Reply
linuxoid
It all works fine programmatically. If I get a GroupList, it only gets those 5 valid groups. It's the Dashboard page that's the problem. I'm just wondering where I can clean that up so that only valid groups are shown in the Dashboard.