8.5.1でユーザーの削除
2019年8月14日 at 14:31
8.5.0で普通にできていたのですが、ユーザーの削除でエラーが出ます。
外部キー制約のエラーです。
完全削除ができません。
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 (`pictron_ligar2019`.`ExpressEntityEntries`, CONSTRAINT `FK_B8AE3531FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`))
タグ:
Re: 8.5.1でユーザーの削除
2020年4月27日 at 22:13
Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException
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 (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`))
Previous exceptions
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`)) (23000)
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`)) (23000)
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 (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`))
Previous exceptions
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`)) (23000)
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`soundbb_ct5`.`StripeSubscriptions`, CONSTRAINT `FK_739BAD9FD71026C` FOREIGN KEY (`uID`) REFERENCES `Users` (`uID`)) (23000)
Your post has been saved and will be published after approval by the forum moderator.
takuro hishikawa
Re: 8.5.1でユーザーの削除
http://github.com/concrete5/concrete5/pull/8066