Symfony2 - SQLSTATE[23000]:完整性约束违反:1062重复条目- SonataAdminBund

我使用SonataAdminBundle。我的目标是管理我的文章，从而允许管理员通过管理界面创建。

这是在我的User类中如何定义关系的。

所以我必须使用:

     /**
    * @var articles
    *
    * Here we will set the OneToMany relationship (Many: One - article : user) 
    * @ORM'OneToMany(targetEntity="Kark'RecetteBundle'Entity'Article", mappedBy="user", cascade={"persist", "remove"})
    */
    protected $articles;
    public function __construct()
    {
        //Une classe à pour instrctruction dans sont constructeur, le constructeur du parent
        parent::__construct();
        $this->articles = new 'Doctrine'Common'Collections'ArrayCollection();
    }
   /**
    * Get articles
    *
    * @return ArrayCollection
    */
    public function getArticles()
    {
        return 
$articles;
    }

   /**        
    *
    * @param $unArticle
    */
    public function addArticle('Kark'RecetteBundle'Entity'Article $unArticle)
    {
        $this->articles[] = $unArticle;
        $unArticle->setUser($this);
    }

在我的class中Article:

/**
  *      @ORM'ManyToOne(targetEntity="Kark'UserBundle'Entity'User", inversedBy="articles")
  */
  private $user;
/**
 * Set user
 *
 * @param User
 * @return article
 */
 public function setUser('Kark'UserBundle'Entity'User $unUser)
 {
    $this->user = $unUser;
    return $this;
 }
 /**
 * Get user
 *
 * @return User
 */
  public function getUser()
  {
     return $this->user;
  }

在我的SonataAdminBundle我然后定义了两个实体CRUD控制器User和Article:

    namespace Kark'AdminBundle'Controller;
    use Sonata'AdminBundle'Controller'CRUDController as Controller;
    class ArticleAdminController extends Controller
    {
    }

下面是CRUD用户:

<?php
namespace Kark'AdminBundle'Controller;
use Sonata'AdminBundle'Controller'CRUDController as Controller;
class UserAdminController extends Controller
{
}

和它们在admin.cfg中的配置:

# Kark/AdminBundle/Resources/config/admin.yml
services:
    kark.admin.admin.article:
        class: Kark'AdminBundle'Admin'ArticleAdmin
        tags:
            - { name: sonata.admin, manager_type: orm, group: Article, label: articles }
        arguments:
            - ~
            - Kark'RecetteBundle'Entity'Article
            - KarkAdminBundle:ArticleAdmin

下面是User实体的部分:

kark.admin.admin.userarticle:
    class: Kark'AdminBundle'Admin'UserAdmin
    tags:
        - { name: sonata.admin, manager_type: orm, group: user, label: users }
    arguments:
        - ~
        - Kark'UserBundle'Entity'User
        - KarkAdminBundle:UserAdmin

一切都设置好了，我在我的文章的Admin类中有以下定义:

<?php
namespace Kark'AdminBundle'Admin;
use Sonata'AdminBundle'Admin'Admin;
use Sonata'AdminBundle'Form'FormMapper;
use Sonata'AdminBundle'Datagrid'DatagridMapper;
use Sonata'AdminBundle'Datagrid'ListMapper;
use Sonata'AdminBundle'Show'ShowMapper;
use Kark'RecetteBundle'Entity'Article;
use Kark'RecetteBundle'Entity'ImageArticle;
use Knp'Menu'ItemInterface as MenuItemInterface;
class ArticleAdmin extends Admin
{
     // setup the default sort column and order
    protected $datagridValues = array(
        '_sort_order' => 'ASC',
        '_sort_by' => 'name'
    );

    // L'ensemble des champs qui seront montrer lors de la création ou de la modification d'une entité
    protected function configureFormFields(FormMapper $formMapper)
    {
        $formMapper
            ->with('General')
                ->add('titre', 'text')
                ->add('imageArticle', 'sonata_type_admin', array('delete' => false), array('required' => true, 'edit' => 'inline'))
                ->add('contenu','textarea');
     }
    /**
    *
    * Fonction qui va permettre d'afficher les différent filtres de recherche dans notre tableau
    * de notre interface.
    *
    */
    protected function configureDatagridFilters(DatagridMapper $datagridMapper)
    {
        $datagridMapper
            ->add('titre')
            ->add('user.username')
        ;
    }
    /**
    * Fonction qui redéfini celle de la classe mère Admin. Cette fonction va nous permettre de préciser les
    * champs qui seront affiché dans notre tableau lorsque l'on listera nos entités
    */
    protected function configureListFields(ListMapper $listMapper)
    {
        $listMapper
            ->addIdentifier('titre')
            ->add('date', null, array('route' => array('name' => 'show')))
            ->add('contenu')
            ->add('user.username')
            ->add('_action', 'actions', array(
                'actions' => array(
                'show' => array(),
                'edit' => array(),
                'delete' => array()
                )
            ))
        ;
    }
    /**
    * Fonction qui redéfinie la fonction de la classe mère qui permet d'indiquer les champs qui seront affiché
    * lorsque l'on consultera un article
    */
    protected function configureShowFields(ShowMapper $showMapper)
    {
        $showMapper
            ->add('date')
            ->add('titre')
            ->add('contenu')
            ->add('imageArticle.getWebPath()', 'string', array('template' => 'KarkAdminBundle:ArticleAdmin:list_image.html.twig'))
            ->add('user.username')
        ;
    }

 /**
     * {@inheritdoc}
     */
    public function prePersist($object)
    {
        $user = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
        $user->addArticle($object);
    }
    /**
     * {@inheritdoc}
     */
    public function preUpdate($object)
    {
        $user = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
        $user->addArticle($object);
    }
}

但是，文章没有插入，因为它执行了insert和UPDATE，并且在表'article_audit中它执行了两次相同的插入，因此存在一个重复主键…

[3/4] UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["545", "UPD", 43, 1, 43, "2014-06-16 23:28:40", "qsmodjqskdjqslkdqjsk", "<p>qsldkqsmldkqslmdkqsmdlqslk lmqskdmlqskdqsmld qskdjqslkdqjsldqksd<'/p>", 0, "2014-06-16 23:28:40", "qsmodjqskdjqslkdqjsk"]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '43-545' for key 'PRIMARY'
 PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '43-545' for key 'PRIMARY'

日志文件如下:

DEBUG - INSERT INTO article (date, titre, contenu, publication, dateEdition, slugTitre, imageArticle_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - UPDATE article SET date = ?, titre = ?, contenu = ?, publication = ?, dateEdition = ?, slugTitre = ?, imageArticle_id = ?, user_id = ? WHERE id = ?
DEBUG - INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - "ROLLBACK"
CRITICAL - Uncaught PHP Exception Sonata'AdminBundle'Exception'ModelManagerException: "Failed to create object: Kark'RecetteBundle'Entity'Article" at /var/www/recette-etudiant/vendor/sonata-project/doctrine-orm-admin-bundle/Model/ModelManager.php line 142

UPDATE -

我尝试以传统的方式插入，也就是说，在我的ArticleController中插入一个操作，该操作如下:

ajouterNewsAction($_local)｛//整个创作将通过这个表单完成$monArticle = new Article();

         // We create our form using an external class 
         $monFormulaire = $this->createForm(new ArticleType, $monArticle);                   
       // Query is recovered 
       $request = $this->get('request');
         // When sending a form, it is realized through transfer data from page to page via a method 
    //called POST. So we'll check when calling this function if this method is effective, if the case is 
    //data that have been transmitted via a data form. 
       if($this->get('request')->getMethod() == 'POST')
       {
         // Process the data here we will moisturize our form with what was before retrieving values 
      // my $ _POST superglobal via a rather fast function
         $monFormulaire->bind($request);
         // Check that the values ​​entered are correct. Validation objects is via annotation 
      // Constraints our class Validator aliased via our @ Assert. 
         if($monFormulaire->isValid())
         {

            // If the item is actually add is that everything is good then created a Tag 
           $this->get('session')->getFlashBag()->add('AjoutRealise', 'L''article a été rajouté avec succès');

            // Get the current utilistaeur 
           $user = $this->getUser();
           // We persist then our body hydrated by Form 
           $entity_manager = $this->getDoctrine()->getManager();
           // Get the service management of user FOSUserBundle
           $userManager = $this->get('fos_user.user_manager');

           //We add a user to our article
           $user->addArticle($monArticle);
           $userManager->updateUser($user);
           $entity_manager->flush();
           //We redirect to the page display section 
           return $this->redirect($this->generateUrl('karkrecette_voir_article', array("id" => $monArticle->getId(), "slugTitre" => $monArticle->getSlugTitre() )));
       }
     }
     // If we're not in the presence of a méthde get is that the form is not sent, then it is blank 
//Otherwise it is possible that the form is not valid, it displays the form hydrating value previously entered 
     return $this->render('KarkRecetteBundle:Article:ajouter.html.twig', array("form" => $monFormulaire->createView(), "langue" => $_local));
     }

如果我在admin。为管理我的Article类而定义的服务;没有问题，因为SonataAdmin没有被触发。但是我真的需要管理我的文章对象。

谢谢。