c2corg / c2corg/v6_api

Constraint error with the feed when deleting an image

Open
#634 8 comments 0 reactions 0 assignees View on GitHub
Admin tools bug Home Page / activity feed
Dominant language
Python
Stars
26
Forks
28
Avg merge
4h
Merged PRs (30d)
9

Description

Not sure the changes done in the feed entries when deleting an image
https://github.com/c2corg/v6_api/blob/master/c2corg_api/views/document_delete.py#L323-L346
are sufficient: while trying to remove an image in my instance I got the following error message:
> sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) update or delete on table "images" violates foreign key constraint "feed_document_changes_image1_id_fkey" on table "feed_document_changes"
DETAIL: Key (document_id)=(842105) is still referenced from table "feed_document_changes".
[SQL: 'DELETE FROM guidebook.images WHERE guidebook.images.document_id = %(document_id_1)s'] [parameters: {'document_id_1': (842105,)}]

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.