Hi,
There are fonds created with mistakes so we would like to delete them. However, when we tried to delete them, we got a 500 Internal Server Error message.
I checked the error log and there was integrity constraint violation - Cannot delete or update a parent row: a foreign key constraint fails.
"(‘atom’.’information_object’, CONSTRAINT ‘information_object_FK_5’ FOREIGN KEY (‘parent_id’) REFERENCES ‘information_object’ (‘id’))"
These two have this error message - “PHP message: Parent Resource ID ‘198846’ does not exist”
I checked the information_object table and the last two records have the first one (steven-gellman-fonds) as its parent_id and UI indicated that the second record has the first one as descendant.
The first one can't be deleted because it's associated with the last two records, so in order to delete them, I have to remove the last two first, but when I accessed these pages directly, I got a 500 Internal Server Error message because the parent id doesn't exist according to the error log message.
Is there any way to delete these four records in all the related tables in the backend?
Thank you so much for your help,
Yoo Young