Opened 7 years ago
Last modified 7 years ago
#2065 closed defect
Can't delete data file type that is referenced from item subtype — at Initial Version
| Reported by: | Nicklas Nordborg | Owned by: | everyone |
|---|---|---|---|
| Priority: | minor | Milestone: | BASE 3.11 |
| Component: | core | Version: | |
| Keywords: | Cc: |
Description
We have an item subtype and a data file type. The item subtype has been configured with a reference to the data file type.
When trying to delete the data file type there is no indication that it is used in the trashcan. This results in the following exception:
update or delete on table "DataFileTypes" violates foreign key constraint "FKmnjqbi7ofj7k0bam7cyh5t3k5" on table "ItemSubtypeFileTypes" Detail: Key (id)=(204867) is still referenced from table "ItemSubtypeFileTypes".
The workaround is to manually remove the link between the item subtype and the data file type. This is done from the item subtype edit dialog.
Note:
See TracTickets
for help on using tickets.
