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.
How can I clean that up? Where else are those null groups stored?
Thank you.
It throws an 'Invalid Group' exception
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...
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...
It doesn't really matter how they have been created. How can I get rid of them now? Which DB table are they in?
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.
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.
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
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.
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.
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.
Click the group name (Null) and choose 'Edit Group' > Click delete.