即使级联删除，foreferkeyconstraintviolationException即使

发布于 2025-02-01 12:50:29 字数 661 浏览 3 评论 0原文

我正在尝试删除OneToone实体关系。

需求只能有一个公认的目的（命题）。 So, this is my demand entity:

class DemandeTransport extends AbstractEntity
{
    /**
     * @ORM\OneToOne(targetEntity=PropositionTransport::class, cascade={"remove"})
     */
    private ?PropositionTransport $propositionAcceptee;
}

It's a

该学说有一个erightekekyconstraintaintviolationexception 与“需求转运”相关的实体。 SQLSTATE [23000]：违反完整性约束：1451无法删除或更新父行：外键约束失败（transporteur。demande_transport，约束fk_1387dbfbf9edb3e8 外键（ession_acceptee_id）参考 ession_transport（<代码> ID ））

原文

I'm trying to delete a OneToOne Entity relation.

A demand can only have one accepted purpose (proposition).
So, this is my demand entity:

class DemandeTransport extends AbstractEntity
{
    /**
     * @ORM\OneToOne(targetEntity=PropositionTransport::class, cascade={"remove"})
     */
    private ?PropositionTransport $propositionAcceptee;
}

It's a unidirectional relationship.
So when I delete a demand, it would delete the propositionAccepte too; but I got this error:

There is a ForeignKeyConstraintViolationException for the Doctrine
entity associated with "DemandeTransport".
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or
update a parent row: a foreign key constraint fails
(transporteur.demande_transport, CONSTRAINT FK_1387DBFBF9EDB3E8
FOREIGN KEY (proposition_acceptee_id) REFERENCES
proposition_transport (id))