Hello guys, I found the error, I'll post if someone has the same problem,
I'm using the 'JMS \ Serializer \' package in ZF2 and it seems that the
table or variable 'group' was in conflict. I changed the name of the table
and the variables and everything worked.
Thank you.
Em quarta-feira, 23 de julho de 2014 10h12min56s UTC-3, João Carlos Santa
Ana escreveu:
>
> CREATE TABLE IF NOT EXISTS `group` (
> `group_id` INT NOT NULL AUTO_INCREMENT,
> `group_name` VARCHAR(45) NULL,
> `group_domain` INT NULL,
> PRIMARY KEY (`group_id`),
> UNIQUE INDEX `groupId_UNIQUE` (`group_id` ASC))
> ENGINE = InnoDB;
>
>
> -- -----------------------------------------------------
> -- Table `group_has_user`
> -- -----------------------------------------------------
> CREATE TABLE IF NOT EXISTS `group_has_user` (
> `group_id` INT NOT NULL,
> `user_id` INT NOT NULL,
> PRIMARY KEY (`group_id`, `user_id`),
> INDEX `fk_group_has_User_User1_idx` (`user_id` ASC),
> INDEX `fk_group_has_User_group_idx` (`group_id` ASC))
> ENGINE = InnoDB;
>
>
>
>
>
> Class Group{
> ...
>
> /**
> * @var \Doctrine\Common\Collections\Collection
> *
> * @ORM\ManyToMany(targetEntity="User", inversedBy="group")
> * @ORM\JoinTable(name="group_has_user",
> * joinColumns={
> * @ORM\JoinColumn(name="group_id",
> referencedColumnName="group_id")
> * },
> * inverseJoinColumns={
> * @ORM\JoinColumn(name="user_id", referencedColumnName="user")
> * }
> * )
> */
> private $user;
>
>
> Class User{
> ...
> /**
> * @var \Doctrine\Common\Collections\Collection
> *
> * @ORM\ManyToMany(targetEntity="Group", mappedBy="user")
> */
> private $group;
>
>
> \vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php on line <i>91<
>
> \vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php on line <i>694</i
>
>
>
> I thank HELP
>
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.