时间戳

首页 > 解决方案 > 当我尝试创建新的时，php bin/console make:crud 中有错误

symfony - 当我尝试创建新的时，php bin/console make:crud 中有错误

问题描述

我在控制台中创建了一个 crud

    php bin/console make:crud Location

它工作正常。我去/location/

PHP 错误

单击新建，我收到此 sql 错误

执行 'SELECT e0_.id AS id_0, e0_.created AS created_1, e0_.updated AS updated_2, e0_.updated_by_id AS updated_by_id_3, e0_.type AS type_4, p1_.name AS name_5, p1_.email AS email_6, e0_ 时发生异常.created_by_id AS created_by_id_7, e0_.permission_id AS permission_id_8, p1_.relationships_id AS relationship_id_9, p1_.locations_id AS locations_id_10 FROM people p1_'：SQLSTATE [42S22]：未找到列：1054 '字段中的未知列'e0_.id'

好像那里有两张桌子。请帮忙。

下面是location课堂。它包括people在其中。创建者是一个person. 我不知道我是否有正确的映射，我很新Symfony。

namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * Class Location
 * @package App\Entity
 * @ORM\Entity() 
 * @ORM\Table("locations")
 */
class Location
{

     /**
     * @ORM\Id
     * @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     */
     protected $id;

    /**
    * @ORM\Column(type="datetime")
    */
    protected $created;

    /**
    * @ORM\Column(type="datetime")
    */
    protected $updated;

    /**
    * @ORM\OneToOne(targetEntity="App\Entity\Person")
    * @ORM\JoinColumn(name="created_by_id", referencedColumnName="id")
    */
    protected $createdBy;

    /**
    * @ORM\OneToOne(targetEntity="App\Entity\Permission")
    * @ORM\JoinColumn(name="permission_id", referencedColumnName="id")
    */
    protected $permissions;

    /**
    * @ORM\Column(name="updated_by_id")
    * @ORM\OneToOne(targetEntity="App\Entity\Person")
    */
    protected $updatedBy;

    /**
    * @ORM\Column(length=255)
    */
    private $name;

    /**
    * @ORM\OneToOne(targetEntity="Address")
    * @ORM\JoinColumn(name="address_id", referencedColumnName="id")
    */
    private $address;

    /**
    * @ORM\Column(length=255)
    */
    private $geoSpatial;


}

标签： symfonydoctrine

解决方案

/**
 * @ORM\ManyToOne(targetEntity="App\Entity\Person")
 * @ORM\JoinColumn(name="created_by_id", referencedColumnName="id")
 */
protected $createdBy;

创建者需要正确映射。我真是个傻逼！

感谢那些注意到“人们从哪里来”帮助我的人，有时您在自己的代码中看不到东西！

推荐阅读