Symfony5.1升级6.4 LTS+Doctrine3.0实体主键配置报错求助

核心错误点排查 #

你的实体类存在几个导致主键识别失败的问题，逐一修正即可：

1. 重复的ORM命名空间前缀 #

关联字段sottoconto_id上的主键注解写错了：

#[ORM\ORM\Id()]

应改为：

#[ORM\Id]

2. 关联主键不能设为nullable #

作为复合主键一部分的关联字段，JoinColumn的nullable必须设为false（主键字段不允许为null）：

#[ORM\JoinColumn(name: "sottoconto_id", referencedColumnName: "sottoconto_id", nullable: false)]

3. 未正确导入关联注解 #

你使用了use Doctrine\ORM\Mapping as ORM;，所以ManyToOne和JoinColumn必须加上ORM\前缀：

#[ORM\ManyToOne(targetEntity: Sottoconti::class, inversedBy: "utenti")]
#[ORM\JoinColumn(name: "sottoconto_id", referencedColumnName: "sottoconto_id", nullable: false)]

4. 主键字段类型与getter返回类型不匹配 #

比如$utente_id声明为private int $utente_id;，但getter返回?int，主键字段不可能为null，应修正为：

public function getUtenteId(): int
{
    return $this->utente_id;
}

同理pratica_id、finanziamento_id的getter也要修正返回类型为int。

5. PHP8属性类型声明不完整 #

$nome、$cognome、$rientro应添加明确的类型声明（结合业务逻辑设为string或?string）：

#[ORM\Column(type: "string")]
private string $nome;

#[ORM\Column(type: "string")]
private string $cognome;

#[ORM\Column(type: "string", nullable: true)]
private ?string $rientro;

修正后的完整实体类 #

<?php

namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity(repositoryClass: "App\Repository\SottocontiUtentiRepository")]
class SottocontiUtenti
{
    #[ORM\Id]
    #[ORM\Column(type: "integer")]
    private int $utente_id;

    #[ORM\Id]
    #[ORM\Column(type: "integer")]
    private int $pratica_id;

    #[ORM\Id]
    #[ORM\Column(type: "integer")]
    private int $finanziamento_id;

    #[ORM\Column(type: "string")]
    private string $nome;

    #[ORM\Column(type: "string")]
    private string $cognome;

    #[ORM\Id]
    #[ORM\ManyToOne(targetEntity: Sottoconti::class, inversedBy: "utenti")]
    #[ORM\JoinColumn(name: "sottoconto_id", referencedColumnName: "sottoconto_id", nullable: false)]
    private ?Sottoconti $sottoconto_id;

    #[ORM\Column(type: "float", nullable: true)]
    private ?float $importo_deliberato;

    #[ORM\Column(type: "string", nullable: true)]
    private ?string $rientro;


    public function getUtenteId(): int
    {
        return $this->utente_id;
    }

    public function setUtenteId(int $utente_id): self
    {
        $this->utente_id = $utente_id;

        return $this;
    }

    public function getSottocontoId(): ?Sottoconti
    {
        return $this->sottoconto_id;
    }

    public function setSottocontoId(?Sottoconti $sottoconto_id): self
    {
        $this->sottoconto_id = $sottoconto_id;

        return $this;
    }

    public function getPraticaId(): int
    {
        return $this->pratica_id;
    }

    public function setPraticaId(int $pratica_id): self
    {
        $this->pratica_id = $pratica_id;

        return $this;
    }

    public function getFinanziamentoId(): int
    {
        return $this->finanziamento_id;
    }

    public function setFinanziamentoId(int $finanziamento_id): self
    {
        $this->finanziamento_id = $finanziamento_id;

        return $this;
    }

    public function getImportoDeliberato(): ?float
    {
        return $this->importo_deliberato;
    }

    public function setImportoDeliberato(?float $importo_deliberato): self
    {
        $this->importo_deliberato = $importo_deliberato;

        return $this;
    }

    public function getRientro(): ?string
    {
        return $this->rientro;
    }

    public function setRientro(?string $rientro): self
    {
        $this->rientro = $rientro;

        return $this;
    }
}

额外验证步骤 #

1. 运行Doctrine schema校验命令确认修复：

php bin/console doctrine:schema:validate

2. 若使用缓存，清空Doctrine元数据缓存：

php bin/console doctrine:cache:clear-metadata

内容的提问来源于stack exchange，提问作者Giacomo Vallini