(reported initially via e-mail by matt goins):
I just noticed that when I create a new list in providence, then
delete it, I get a foreign key constraint error.
We're using providence from git, currently at revision:
The install we're using was installed using an earlier version and then
Here are the steps to reproduce:
Create a list
Manage -> Lists and Vocabularies
Click "Add New List"
On the form, choose a Preferred Names and List Code, but leave
everything else as the default.
Then delete the item:
Navigate to Manage -> Lists and Vocabularies
Find the list you created, on its form, hit delete.
Upon trying to delete, I get this error
DELETE FROM ca_lists WHERE list_id = 43Cannot delete or update a parent row: a foreign key constraint fails (`ca0`.`ca_list_items`, CONSTRAINT
`fk_ca_list_items_list_id` FOREIGN KEY (`list_id`) REFERENCES `ca_lists` (`list_id`))
This can be manually fixed by running these two queries after the fact.
DELETE FROM ca_list_item_labels WHERE item_id = (item_id of Root Node item)
DELETE FROM ca_list_items WHERE list_id = (list_id of list you were trying to delete)
Thanks for your help!
debian wheezy, collective access git master
There's a fix for this in GitHub master. Let us know if this works for you. Thanks!