Can't delete user

Permalink
Hi,

I cant delete users from dashboard (c5 8.2.1.). For workaround I've just deactivated users.

It gives me this error.

An exception occurred while executing 'DELETE FROM Users WHERE uID = ?' with params [4]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`XXXXXXXXXXXXXXX`.`UserSignups`, CONSTRAINT `FK_FEB5D909D3564642` FOREIGN KEY (`createdBy`) REFERENCES `Users` (`uID`))

Temposaur
 
biplob replied on at Permalink Reply
biplob
I'm also facing similar problem on version 8.2.1

An exception occurred while executing 'DELETE FROM Users WHERE uID = ?' with params [7]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`concrete5`.`usersignups`, CONSTRAINT `FK_FEB5D909D3564642` FOREIGN KEY (`createdBy`) REFERENCES `Users` (`uID`))
JohntheFish replied on at Permalink Reply
JohntheFish
Capitalisation of UserSignups is wrong.

Did you by any chance copy the site from a case insensitive install (Windows) to Linux and then run one of the DB case fixer utilities - that turned out to be incomplete?
biplob replied on at Permalink Reply
biplob
No, my local environment is mac and remote environment is Amazon Linux.
I found no files in my project with lowercase `usersignups`, but found some cache files with `usersignups`. And all other table names are lowercased on cache files.
JackVanson replied on at Permalink Reply
Hi Guys

I am getting the same issue. Same error message. Has anyone got this fixed yet?

Jack
biplob replied on at Permalink Reply
biplob
It should already be fixed.
Which version of concrete5 are you using?