delete gallery in mappics-admin

[buildvoc10]

hello when I go to delete a gallery in mappics-admin get the following error

There is a ForeignKeyConstraintViolationException for the Doctrine entity associated with "Gallery". Solution: disable the "delete" action for this entity or configure the "cascade={"remove"}" attribute for the related property in the Doctrine entity. Full exception: An exception occurred while executing 'DELETE FROM gallery WHERE id = ?' with params ["7c22edec-c259-4ea3-8ff5-a83a461025e6"]:

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (mp_db.image, CONSTRAINT FK_C53D045F4E7AF8F FOREIGN KEY (gallery_id) REFERENCES gallery (id))

also when i add a folder in /var/galleries doesn't automatically create a gallery in mappics
any help would be greatly appreciated

[antodippo]

Hey @buildvoc10 , yes there is a constraint on that relationship indeed. What you can do is delete all the images for that gallery before trying to delete the gallery.

On the second problem, what's the output that you get when you try to run the bin/console mappics:process-galleries command, after putting the pictures in the /var/galleries directory?

[buildvoc10]

@antodippo thanks got working in the end