Xibo

Deleting user (group) gives foreign key error

Asked by Pieter van der Veen

I run version 1.6.4

When I try to delete a User group I get:

"Unable to delete User Group"

Here's what i get in the error log:

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`xibo`.`lkcampaigngroup`, CONSTRAINT `lkcampaigngroup_ibfk_2` FOREIGN KEY (`GroupID`) REFERENCES `group` (`groupID`))

I notice the word Campaign in this error message... however I don't have/use campaigns.

This problem, or something like this as I recall, was also present in version 1.6.1/2 and was supposedly fixed in 1.6.3.
Can someone please help as to why this happens and how I can resolve it?

Thanks!

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said : 		#1

Delete user group doesn't make any attempt to delete any associated permissions (at the moment). It probably should... i'll add a bug.

All layouts belong to a hidden campaign of 1 item.

Revision history for this message
Pieter van der Veen (pwpvanderveen) said : 		#2

I would like to add that I already removed all permissions associated with the group I want to remove, prior to my attempts to remove the group.

Can you help with this problem?

Provide an answer of your own, or ask Pieter van der Veen for more information if necessary.

To post a message you must log in.