使用错误的表别名生成查询的原则 - Symfony 5

Question

我试图在我的数据库中插入一个用户，并在此之前生成学说：An exception occurred while executing 'SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.username AS username_4, t0.password AS password_5, t0.aRoles AS aRoles_6, t0.create_date AS create_date_7, t8.id AS id_9, t8.name AS name_10, t8.siren AS siren_11, t8.social_network_list AS social_network_list_12, t8.sponso AS sponso_13, t8.created_date AS created_date_14, t8.user_id AS user_id_15 FROM user t0 LEFT JOIN company t8 ON t8.user_id = t16.id WHERE t0.username = ?' with params ["[e-mail]"]:出现以下错误：SQLSTATE[42S22]: Column not found: 1054 Unknown column 't16.id' in 'on clause'Doctrine 创建了一个别名“t16”，但好的别名是“t0”在我的控制器中，我使用一个表单来管理用户注册。我的用户实体在这里：*** @ORM\Entity(repositoryClass=UserRepository::class)* @UniqueEntity(*     fields={"username"},*     message="Le compte est existant !"* )*/class User implements UserInterface{/** * @ORM\Id() * @ORM\GeneratedValue() * @ORM\Column(type="integer") */private $id;/** * @ORM\Column(type="string", length=255) */private $name;/** * @ORM\Column(type="string", length=255) */private $firstName;/** * @ORM\Column(type="string", length=255) * @Assert\Email() */private $username;/** * @ORM\Column(type="string", length=255) * @Assert\Length(min="8", minMessage="Votre mot de passe doit faire au minimum 8 caractères") */private $password;/** * @Assert\EqualTo(propertyPath="password", message="Les mots de passes ne sont pas identiques") */public $confirm_password;/** * @var array * * @ORM\Column(name="aRoles", type="array", length=400, nullable=false) */private $aroles;/** * @ORM\Column(type="datetime") */private $createDate;/** * @ORM\OneToOne(targetEntity=Company::class, mappedBy="user") */private $company;

Answer 1

可能与某些错误配置有关。将您的映射更改为：

用户

/**

 * @ORM\OneToOne(targetEntity="Company", mappedBy="user")

 */

private $company;

公司（见用户上限）

/**

 * @ORM\OneToOne(targetEntity="User", inversedBy="company")

 * @ORM\JoinColumn(name="user_id", referencedColumnName="id")

 */

private $user;