Media preview image deletion issue

[nikomuse]

Media preview image deletion issue

[llefort001]

I am having the same problem with Entities having a relationship with a media entity.

If you try to remove a linked media, integrity constraint will pop and refuse to remove media, but it is too late, file has been deleted.
Then, as you said, media still exists but file doesn't, which makes unable to delete media forever (with admin interface).

Solution would be to check integrity constraint BEFORE deleting the file

[llefort001]

Depending on your implementation, you may use these annotations to unlink media from your custom entity onDelete:

/**
* @Orm\OneToOne(targetEntity=Media::class)
* @Orm\JoinColumn(onDelete="SET NULL")
*/

/**
* @Orm\ManyToOne(targetEntity=Media::class)
* @Orm\JoinColumn(name="media_id", referencedColumnName="id", onDelete="SET NULL")
*/

/**
* @Orm\OneToMany(targetEntity=ExampleEntityMedia::class, mappedBy="example_entity", orphanRemoval=true, cascade={"persist", "remove"})
* @Orm\OrderBy({"position" = "ASC"})
* @Orm\JoinColumn(name="example_entity_id", referencedColumnName="id", onDelete="CASCADE")
*/

[mamazu]

Wouldn't it maybe make sense to swap the deletion from the database and the file system removal. So that if the constraint gets triggered the media doesn't get deleted?