doujiu3768
2018-07-10 05:50
浏览 49
已采纳

SonataUserBundle + FOSUserBundle注释问题Doctrine主键错误

Using Symfony 4.1, Sonata User Bundle 4.x, and FOSUserBundle 2.1.2.

I am trying to override the table names for the User and Group tables. I therefore added annotations to the auto generated user and group classes:

use Sonata\UserBundle\Entity\BaseGroup as BaseGroup;
use Doctrine\ORM\Mapping as ORM;

/**
 * This file has been generated by the SonataEasyExtendsBundle.
 * @ORM\Entity()
 * @ORM\Table(name="aegis_group")
 * @link https://sonata-project.org/easy-extends 
 * References:
 * @link http://www.doctrine-project.org/projects/orm/2.0/docs/reference/working-with-objects/en
 */
class Group extends BaseGroup
{
    /**     
     * @ORM\Id      
     * @var int $id
     */
    protected $id;

   /**
     * Get id.
     *
     * @return int $id
     */
    public function getId()
    {
        return $this->id;
    }    
}

I then modified doctrine.yaml to factor in these annotations:

        mappings:                    
                App:
                    is_bundle: false
                    type: annotation
                    dir: '%kernel.project_dir%/src/Entity'
                    prefix: 'App\Entity'
                    alias: App
                FOSUserBundle: ~                                          
                ApplicationSonataUserBundle: 
                    type: annotation
                SonataUserBundle: ~   

However, when I run migrations, doctrine gives me an error:

In MappingException.php line 46:

No identifier/primary key specified for Entity "App\Application\Sonata\User Bundle\Entity\Group" sub class of "Sonata\UserBundle\Entity\BaseGroup". Every Entity must have an identifier/primary key.

How to fix this issue, so that I can use my own custom table names ? All I want to do is to change the database table names, this should not be this involved.

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • duanmi8349 2018-07-14 04:13
    已采纳

    Well, turns out an XML orm file is generated by the SonataEasyExtendsBundle, in directory Application\Sonata\UserBundle\Resources\config\doctrine folder. One should modify this file (User.orm.xml) to make changes to the table config.

    <?xml version="1.0" encoding="UTF-8"?>
    <doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping"
                      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                      xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
                      http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
    
        <entity name="App\Application\Sonata\UserBundle\Entity\User" table="aegis_user">
    
            <id name="id" column="id" type="integer">
                <generator strategy="AUTO" />
            </id>
    
        </entity>
    
    </doctrine-mapping>
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • dongshendi3599 2018-07-10 07:44

    First you forgot namespace in your class.

    Second: Try to add a strategy and a column for your primary key like

    /**
     * @var int $id
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题