Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Constant foreign key constraint fails

I have installed Collective Access locally to be moved to a server at later date using XAMPP 7.4.9-0. I can access the interface through my browser, but if I try adding anything I get a foreign key constraint error, as evidenced below:
2020-09-09 14:48:21 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_list_items, CONSTRAINT fk_ca_list_items_list_id FOREIGN KEY (list_id) REFERENCES ca_lists (list_id))
2020-09-09 14:50:00 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_list_items, CONSTRAINT fk_ca_list_items_list_id FOREIGN KEY (list_id) REFERENCES ca_lists (list_id))
2020-09-09 14:51:40 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_list_items, CONSTRAINT fk_ca_list_items_list_id FOREIGN KEY (list_id) REFERENCES ca_lists (list_id))
2020-09-09 14:55:06 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_collections, CONSTRAINT fk_ca_collections_type_id FOREIGN KEY (type_id) REFERENCES ca_list_items (item_id))
2020-09-09 15:04:51 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_objects, CONSTRAINT fk_ca_objects_type_id FOREIGN KEY (type_id) REFERENCES ca_list_items (item_id))
2020-09-09 15:25:56 - ERROR --> DatabaseException: Cannot add or update a child row: a foreign key constraint fails (collectiveaccess.ca_collections, CONSTRAINT fk_ca_collections_type_id FOREIGN KEY (type_id) REFERENCES ca_list_items (item_id))

I have no idea what I'm doing wrong or how to fix this. Any ideas?

Comments

  • What profile did you install with? It looks like your database is totally empty.

  • I installed with Dublin Core

  • I've tried to do a fresh install and am running into a new issue. The installation halts part of the way through and I get the message "The locale default is set to a non-existing locale. Try adding 'en_US' to your profile." I didn't change the locale at all and it was set to en_US in the setup.php file. How do I fix this? I'm using Providence 1.7.8

Sign In or Register to comment.