doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-23 22:42:18 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

Delete doctrine entity with multiple ID properties and relation #6916

New Issue
Open
opened 2026-01-22 15:41:17 +01:00 by admin · 1 comment
admin commented 2026-01-22 15:41:17 +01:00
Owner
Copy Link

Originally created by @TomAMarine on GitHub (Jan 27, 2022).

Hi,

I have a problem in the configuration of Doctrine.

I have two PHP classes described below. A class that represents a boat model "Model" and another that represents an alias "ModelAlias". Example: "ANTARES 6 FISHING" is an alias of "ANTARES 6". These two names correspond to the same boat.

A model can have 0 or more aliases.
The unique key of my "ModelAlias" entity is a combination of the model id and the alias name.
So, I added the annotation "@ORM\Id" on "model" and "name" properties. The property "model" is a relation to the "Model" entity.

Simplified class "Model"

/**
 * Boat model
 * @ORM\Entity(repositoryClass=ModelRepository::class)
 * @ORM\Table(name="model")
 * @Vich\Uploadable
 */
class Model
{

	/**
	 * @ORM\Id
	 * @ORM\GeneratedValue(strategy="IDENTITY")
	 * @ORM\Column(type="integer", nullable=false, options={"unsigned":true})
	 */
	private ?int $id = null;

	/**
         * The aliases of the model boat.
	 * @ORM\OneToMany(targetEntity=ModelAlias::class, mappedBy="model", cascade={"persist"}, orphanRemoval=true)
	 *
	 * @var Collection<ModelAlias>
	 */
	private Collection $aliases;

        public function __construct()
	{
		$this->aliases = new ArrayCollection();
	}

        //...
}

Simplified Class "ModelAlias"

/**
 * Alias 
 * @ORM\Entity(repositoryClass=ModelAliasRepository::class)
 * @ORM\Table(name="model_alias")
 */
class ModelAlias
{
	/**
	 * @ORM\Id
	 * @ORM\ManyToOne(targetEntity=Model::class, inversedBy="aliases")
	 * @ORM\JoinColumn(name="model_id", referencedColumnName="id", onDelete="CASCADE")
	 */
	private ?Model $model = null;

	/**
	 * @ORM\Id
	 * @ORM\Column(type="string", length=50, nullable=false)
	 */
	private ?string $name = null;

	/**
	 * @ORM\Column(type="boolean", nullable=false, options={"default":true})
	 */
	private bool $auto = false;

	/**
         * Disable the use of this alias.
	 * @ORM\Column(type="boolean", nullable=false, options={"default":true})
	 */
	private bool $active = true;

       //...
}

When I delete the alias with "remove" function Doctrine, I get an error message :

{
    "type": "https://tools.ietf.org/html/rfc2616#section-10",
    "title": "An error occurred",
    "status": 500,
    "detail": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'model' in 'where clause'",
    "class": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
    "trace": [
        {
            "namespace": "",
            "short_class": "",
            "class": "",
            "type": "",
            "function": "",
            "file": "/www/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
            "line": 69,
            "args": []
        },
        {
            "namespace": "Doctrine\\DBAL\\Driver\\API\\MySQL",
            "short_class": "ExceptionConverter",
            "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
            "type": "->",
            "function": "convert",
            "file": "/www/vendor/doctrine/dbal/src/Connection.php",
            "line": 1767,
            "args": [
                [
                    "object",
                    "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                ],
                [
                    "object",
                    "Doctrine\\DBAL\\Query"
                ]
            ]
        },
        {
            "namespace": "Doctrine\\DBAL",
            "short_class": "Connection",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "function": "handleDriverException",
            "file": "/www/vendor/doctrine/dbal/src/Connection.php",
            "line": 1706,
            "args": [
                [
                    "object",
                    "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                ],
                [
                    "object",
                    "Doctrine\\DBAL\\Query"
                ]
            ]
        },
        {
            "namespace": "Doctrine\\DBAL",
            "short_class": "Connection",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "function": "convertExceptionDuringQuery",
            "file": "/www/vendor/doctrine/dbal/src/Connection.php",
            "line": 1147,
            "args": [
                [
                    "object",
                    "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                ],
                [
                    "string",
                    "DELETE FROM data_library_model_alias WHERE model = ? AND name = ?"
                ],
                [
                    "array",
                    [
                        [
                            "string",
                            "23185"
                        ],
                        [
                            "string",
                            "ANTARES 6 FISHING"
                        ]
                    ]
                ],
                [
                    "array",
                    [
                        [
                            "string",
                            "integer"
                        ],
                        [
                            "string",
                            "string"
                        ]
                    ]
                ]
            ]
        },
        {
            "namespace": "Doctrine\\DBAL",
            "short_class": "Connection",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "function": "executeStatement",
            "file": "/www/vendor/doctrine/dbal/src/Connection.php",
            "line": 628,
            "args": [
                [
                    "string",
                    "DELETE FROM data_library_model_alias WHERE model = ? AND name = ?"
                ],
                [
                    "array",
                    [
                        [
                            "string",
                            "23185"
                        ],
                        [
                            "string",
                            "ANTARES 6 FISHING"
                        ]
                    ]
                ],
                [
                    "array",
                    [
                        [
                            "string",
                            "integer"
                        ],
                        [
                            "string",
                            "string"
                        ]
                    ]
                ]
            ]
        },
        {
            "namespace": "Doctrine\\DBAL",
            "short_class": "Connection",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "function": "delete",
            "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php",
            "line": 579,
            "args": [
                [
                    "string",
                    "data_library_model_alias"
                ],
                [
                    "array",
                    {
                        "model": [
                            "string",
                            "23185"
                        ],
                        "name": [
                            "string",
                            "ANTARES 6 FISHING"
                        ]
                    }
                ],
                [
                    "array",
                    [
                        [
                            "string",
                            "integer"
                        ],
                        [
                            "string",
                            "string"
                        ]
                    ]
                ]
            ]
        },
        {
            "namespace": "Doctrine\\ORM\\Persisters\\Entity",
            "short_class": "BasicEntityPersister",
            "class": "Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister",
            "type": "->",
            "function": "delete",
            "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php",
            "line": 1232,
            "args": [
                [
                    "object",
                    "App\\Entity\\DataLibrary\\ModelAlias"
                ]
            ]
        },
        {
            "namespace": "Doctrine\\ORM",
            "short_class": "UnitOfWork",
            "class": "Doctrine\\ORM\\UnitOfWork",
            "type": "->",
            "function": "executeDeletions",
            "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php",
            "line": 438,
            "args": [
                [
                    "object",
                    "Doctrine\\ORM\\Mapping\\ClassMetadata"
                ]
            ]
        },
        {
            "namespace": "Doctrine\\ORM",
            "short_class": "UnitOfWork",
            "class": "Doctrine\\ORM\\UnitOfWork",
            "type": "->",
            "function": "commit",
            "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php",
            "line": 388,
            "args": [
                [
                    "null",
                    null
                ]
            ]
        },
        {
            "namespace": "Doctrine\\ORM",
            "short_class": "EntityManager",
            "class": "Doctrine\\ORM\\EntityManager",
            "type": "->",
            "function": "flush",
            "file": "/www/var/cache/dev/ContainerEXkGuc3/EntityManager_9a5be93.php",
            "line": 136,
            "args": [
                [
                    "null",
                    null
                ]
            ]
        }
    ]
}

The DELETE request generated by Doctrine is :

DELETE FROM model_alias WHERE model = ? AND name = ?

But, the column name "model" is invalid. It should be "model_id" because I have this annotation "@ORM\JoinColumn(name="model_id")" on the "model" property.

Do you have an idea to fix my problem ?

Thank you for you help.

Originally created by @TomAMarine on GitHub (Jan 27, 2022). Hi, I have a problem in the configuration of Doctrine. I have two PHP classes described below. A class that represents a boat model "Model" and another that represents an alias "ModelAlias". Example: "ANTARES 6 FISHING" is an alias of "ANTARES 6". These two names correspond to the same boat. A model can have 0 or more aliases. The unique key of my "ModelAlias" entity is a combination of the model id and the alias name. So, I added the annotation "@ORM\Id" on "model" and "name" properties. The property "model" is a relation to the "Model" entity. ### Simplified class "Model" ```php /** * Boat model * @ORM\Entity(repositoryClass=ModelRepository::class) * @ORM\Table(name="model") * @Vich\Uploadable */ class Model { /** * @ORM\Id * @ORM\GeneratedValue(strategy="IDENTITY") * @ORM\Column(type="integer", nullable=false, options={"unsigned":true}) */ private ?int $id = null; /** * The aliases of the model boat. * @ORM\OneToMany(targetEntity=ModelAlias::class, mappedBy="model", cascade={"persist"}, orphanRemoval=true) * * @var Collection<ModelAlias> */ private Collection $aliases; public function __construct() { $this->aliases = new ArrayCollection(); } //... } ``` ### Simplified Class "ModelAlias" ```php /** * Alias * @ORM\Entity(repositoryClass=ModelAliasRepository::class) * @ORM\Table(name="model_alias") */ class ModelAlias { /** * @ORM\Id * @ORM\ManyToOne(targetEntity=Model::class, inversedBy="aliases") * @ORM\JoinColumn(name="model_id", referencedColumnName="id", onDelete="CASCADE") */ private ?Model $model = null; /** * @ORM\Id * @ORM\Column(type="string", length=50, nullable=false) */ private ?string $name = null; /** * @ORM\Column(type="boolean", nullable=false, options={"default":true}) */ private bool $auto = false; /** * Disable the use of this alias. * @ORM\Column(type="boolean", nullable=false, options={"default":true}) */ private bool $active = true; //... } ``` When I delete the alias with "remove" function Doctrine, I get an error message : ```json { "type": "https://tools.ietf.org/html/rfc2616#section-10", "title": "An error occurred", "status": 500, "detail": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'model' in 'where clause'", "class": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException", "trace": [ { "namespace": "", "short_class": "", "class": "", "type": "", "function": "", "file": "/www/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php", "line": 69, "args": [] }, { "namespace": "Doctrine\\DBAL\\Driver\\API\\MySQL", "short_class": "ExceptionConverter", "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter", "type": "->", "function": "convert", "file": "/www/vendor/doctrine/dbal/src/Connection.php", "line": 1767, "args": [ [ "object", "Doctrine\\DBAL\\Driver\\PDO\\Exception" ], [ "object", "Doctrine\\DBAL\\Query" ] ] }, { "namespace": "Doctrine\\DBAL", "short_class": "Connection", "class": "Doctrine\\DBAL\\Connection", "type": "->", "function": "handleDriverException", "file": "/www/vendor/doctrine/dbal/src/Connection.php", "line": 1706, "args": [ [ "object", "Doctrine\\DBAL\\Driver\\PDO\\Exception" ], [ "object", "Doctrine\\DBAL\\Query" ] ] }, { "namespace": "Doctrine\\DBAL", "short_class": "Connection", "class": "Doctrine\\DBAL\\Connection", "type": "->", "function": "convertExceptionDuringQuery", "file": "/www/vendor/doctrine/dbal/src/Connection.php", "line": 1147, "args": [ [ "object", "Doctrine\\DBAL\\Driver\\PDO\\Exception" ], [ "string", "DELETE FROM data_library_model_alias WHERE model = ? AND name = ?" ], [ "array", [ [ "string", "23185" ], [ "string", "ANTARES 6 FISHING" ] ] ], [ "array", [ [ "string", "integer" ], [ "string", "string" ] ] ] ] }, { "namespace": "Doctrine\\DBAL", "short_class": "Connection", "class": "Doctrine\\DBAL\\Connection", "type": "->", "function": "executeStatement", "file": "/www/vendor/doctrine/dbal/src/Connection.php", "line": 628, "args": [ [ "string", "DELETE FROM data_library_model_alias WHERE model = ? AND name = ?" ], [ "array", [ [ "string", "23185" ], [ "string", "ANTARES 6 FISHING" ] ] ], [ "array", [ [ "string", "integer" ], [ "string", "string" ] ] ] ] }, { "namespace": "Doctrine\\DBAL", "short_class": "Connection", "class": "Doctrine\\DBAL\\Connection", "type": "->", "function": "delete", "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php", "line": 579, "args": [ [ "string", "data_library_model_alias" ], [ "array", { "model": [ "string", "23185" ], "name": [ "string", "ANTARES 6 FISHING" ] } ], [ "array", [ [ "string", "integer" ], [ "string", "string" ] ] ] ] }, { "namespace": "Doctrine\\ORM\\Persisters\\Entity", "short_class": "BasicEntityPersister", "class": "Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister", "type": "->", "function": "delete", "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php", "line": 1232, "args": [ [ "object", "App\\Entity\\DataLibrary\\ModelAlias" ] ] }, { "namespace": "Doctrine\\ORM", "short_class": "UnitOfWork", "class": "Doctrine\\ORM\\UnitOfWork", "type": "->", "function": "executeDeletions", "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php", "line": 438, "args": [ [ "object", "Doctrine\\ORM\\Mapping\\ClassMetadata" ] ] }, { "namespace": "Doctrine\\ORM", "short_class": "UnitOfWork", "class": "Doctrine\\ORM\\UnitOfWork", "type": "->", "function": "commit", "file": "/www/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php", "line": 388, "args": [ [ "null", null ] ] }, { "namespace": "Doctrine\\ORM", "short_class": "EntityManager", "class": "Doctrine\\ORM\\EntityManager", "type": "->", "function": "flush", "file": "/www/var/cache/dev/ContainerEXkGuc3/EntityManager_9a5be93.php", "line": 136, "args": [ [ "null", null ] ] } ] } ``` The DELETE request generated by Doctrine is : ```sql DELETE FROM model_alias WHERE model = ? AND name = ? ``` But, the column name "model" is invalid. It should be "model_id" because I have this annotation "@ORM\JoinColumn(name="model_id")" on the "model" property. Do you have an idea to fix my problem ? Thank you for you help.
admin commented 2026-01-22 15:41:18 +01:00
Author
Owner
Copy Link

@wazum commented on GitHub (Mar 4, 2022):

I have the same (or a similar) thing here, maybe I'm doing something wrong, but I can't find the problem.

My Product entity

/**
 * @ORM\Entity
 */
class Product
{
…
    /**
     * @ORM\OneToMany(targetEntity="Release", mappedBy="product", cascade={"persist", "remove"}, orphanRemoval=true, fetch="EAGER")
     */
    protected Collection $releases;

has many releases (with further associations)

/**
 * @ORM\Entity
 */
class Release
{
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="Product", inversedBy="releases")
     */
    private Product $product;

    /**
     * @ORM\Id
     * @ORM\OneToOne(targetEntity="Market")
     */
    private Market $market;

    /**
     * @ORM\Id
     * @ORM\OneToOne(targetEntity="Language")
     */
    private Language $language;
}

whenever I try to remove releases from the product's collection, I get the error unknown field "product", "market", "language".
The Doctrine diff command created migrations with the correct field names product_id, market_id, language_id here.

@wazum commented on GitHub (Mar 4, 2022): I have the same (or a similar) thing here, maybe I'm doing something wrong, but I can't find the problem. My Product entity ``` /** * @ORM\Entity */ class Product { … /** * @ORM\OneToMany(targetEntity="Release", mappedBy="product", cascade={"persist", "remove"}, orphanRemoval=true, fetch="EAGER") */ protected Collection $releases; ``` has many releases (with further associations) ``` /** * @ORM\Entity */ class Release { /** * @ORM\Id * @ORM\ManyToOne(targetEntity="Product", inversedBy="releases") */ private Product $product; /** * @ORM\Id * @ORM\OneToOne(targetEntity="Market") */ private Market $market; /** * @ORM\Id * @ORM\OneToOne(targetEntity="Language") */ private Language $language; } ``` whenever I try to remove releases from the product's collection, I get the error `unknown field "product", "market", "language"`. The Doctrine diff command created migrations with the correct field names `product_id, market_id, language_id` here.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#6916
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?