Howdy, Stranger!

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

In this Discussion

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.

purge error

trying to purge records with

./caUtils purge-deleted

CollectiveAccess 1.7.8 (158/RELEASE) Utilities

I get the following error message:

Removing deleted entities from database 10.0% 87/894 ETC: 4 mins, 10 secs. Elapsed: 27 secs [==> ]PHP Fatal error: Uncaught DatabaseException: Cannot delete or update a parent row: a foreign key constraint fails (raubgut.ca_objects_x_entities, CONSTRAINT fk_ca_objects_x_entities_entity_id FOREIGN KEY (entity_id) REFERENCES ca_entities (entity_id)) in /var/www/providence/app/lib/Db/mysqli.php:316
Stack trace:

0 /var/www/providence/app/lib/Db/DbStatement.php(151): Db_mysqli->execute(Object(DbStatement), Object(DbStatement), 'DELETE FROM ca_...', Array, NULL)

1 /var/www/providence/app/lib/Db.php(261): DbStatement->executeWithParamsAsArray(Array)

2 /var/www/providence/app/lib/BaseModel.php(3405): Db->query('DELETE FROM ca_...')

3 /var/www/providence/app/lib/BaseModelWithAttributes.php(606): BaseModel->delete(true, Array, NULL, Array)

4 /var/www/providence/app/lib/BundlableLabelableBaseModelWithAttributes.php(365): BaseModelWithAttributes->delete(true, Array, NULL, NULL)

5 /var/www/providence/app/lib/Utils/CLIUtils.php(601): BundlableLabelableBaseModelWithAttributes->delete(true, Array)

6 /var/www/providence in /var/www/providence/app/lib/Db/mysqli.php on line 316

Any idea how to fix this?




Sign In or Register to comment.