[solved] Doctrine Association Mapping Many-To-Many, Unidirectional

Permalink January 22, 2019 at 11:29 AM

Hi,

I am currently testing including doctrine entities in my Package.

Normal entities and many-to-one and one-to-one associations have not been a problem so far. Everything works fine.

Now I try something fancier. A Many-to-Many Association to an existing concrete5 system table.

Of course I read the doctrine documentation as well as the concrete5 Developer documentation and I have already looked at the forum here.

But no matter what I have tried so far, I always get the following error:
"Column name` id` referenced for relation from TestEntities \ Entity \ TestProject towards Concrete \ Core \ Entity \ User \ User does not exist. "

But I do NOT specify a column named 'id' in my code?!?

Here's my example with the question: What am I doing wrong?

<?php
namespace TestEntities\Entity;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;
/**
 * @ORM\Entity
 * @ORM\Table(name="TestProjects")
 */
class TestProject {
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue
     */
    protected $ID;

Viewing 15 lines of 27 lines. View entire code block.

<?php
namespace TestEntities\Entity;
 
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;
 
/**
 * @ORM\Entity
 * @ORM\Table(name="TestProjects")
 */
class TestProject {
 
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue
     */
    protected $ID;
 
    /**
    * @ORM\ManyToMany(targetEntity="Concrete\Core\Entity\User\User")
    * @JoinTable(name="TestProjects_Users",
     *      joinColumns={@ORM\JoinColumn(name="TestProject_ID", referencedColumnName="ID")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="User_ID", referencedColumnName="uID")}
     *      )
    */
    protected $Users;
 
   public function __construct() {
        $this->Users = new ArrayCollection();
    }
}

Does anyone have an idea / suggestion / tip for me?

---System environment---------------------------
# concrete5 Version
Core Version - 8.4.4
Version Installed - 8.4.4
Database Version - 20180717000000

# PHP Version
7.2.12
--------------------------------------------------------

Greetings

Forums

Developing (v7+)

[solved] Doctrine Association Mapping Many-To-Many, Unidirectional

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?