I am trying to run the command doctrine:generate:crud on an entity with two
inverse keys and it seems there is some problem.
I get the following error when after running the crud command and going to
the index page.
An exception occurred while executing 'SELECT t0.id AS id1, t0.name AS
name2, t0.url AS url3, t0.type AS type4, t0.userid_id AS userid_id5 FROM
links t0':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.userid_id' in
'field list'
The following are the properties of my links entity:
class Links
{
/**
* @var integer
*
* @ORM\Column(name="id", type="integer", nullable=false)
* @ORM\Id
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="name", type="string", length=100, nullable=false)
*/
private $name;
/**
* @var string
*
* @ORM\Column(name="url", type="string", length=200, nullable=false)
*/
private $url;
/**
* @var string
*
* @ORM\Column(name="type", type="string", length=100, nullable=true)
*/
private $type;
/**
* @var integer
*
* @ORM\ManyToOne(targetEntity="Users", inversedBy="links")
*/
private $userid;
And this is my User entity
class Users
{
/**
* @var integer
*
* @ORM\Column(name="id", type="integer", nullable=false)
* @ORM\Id
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="userName", type="string", length=30,
nullable=false)
*/
private $username;
/**
* @var string
*
* @ORM\Column(name="name", type="string", length=30, nullable=false)
*/
private $name;
/**
* @var string
*
* @ORM\Column(name="LastName", type="string", length=30,
nullable=false)
*/
private $lastname;
/**
* @var string
*
* @ORM\Column(name="Password", type="string", length=30,
nullable=false)
*/
private $password;
/**
* @var string
*
* @ORM\Column(name="email", type="string", length=30, nullable=false)
*/
private $email;
/**
* @var string
*
* @ORM\OneToMany(targetEntity="Links", mappedBy="userid")
*
*/
private $links;
/**
* @var string
*
* @ORM\OneToMany(targetEntity="Projects", mappedBy="author")
*/
private $projects;
public function __construct(){
$this->links=new ArrayCollection();
$this->projects=new ArrayCollection();
}
Thanks in advanced,
Marcel
--
--
If you want to report a vulnerability issue on Symfony, please read the
procedure on http://symfony.com/security
You received this message because you are subscribed to the Google
Groups "symfony developers" group.
To post to this group, send email to symfony-devs@googlegroups.com
To unsubscribe from this group, send email to
symfony-devs+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
---
You received this message because you are subscribed to the Google Groups
"Symfony developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to symfony-devs+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
