dsft8327 2018-10-24 13:01
浏览 21

Symfony 3.4 new Entity:语法错误或访问冲突

Hello guys i have an error when i am creating a new "conversation" entity i really don't see where is the error :/ i have this :

An exception occurred while executing 'INSERT INTO conversation (read, last_send, id_user_one, id_user_two) VALUES (?, ?, ?, ?)' with params [0, 8, 8, 9]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read, last_send, id_user_one, id_user_two) VALUES (0, 8, 8, 9)' at line 1

My entity :

/**
 * @var integer
 *
 * @ORM\Column(name="id", type="integer", nullable=false)
 * @ORM\Id()
 * @ORM\GeneratedValue(strategy="IDENTITY")
 */
protected $id;

/**
 * @var \AppBundle\Entity\User
 *
 * @ORM\GeneratedValue(strategy="NONE")
 * @ORM\ManyToOne(targetEntity="User")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="id_user_one", referencedColumnName="id")
 * })
 */
protected $id_user_one;

/**
 * @var \AppBundle\Entity\User
 *
 * @ORM\GeneratedValue(strategy="NONE")
 * @ORM\ManyToOne(targetEntity="User")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="id_user_two", referencedColumnName="id")
 * })
 */
protected $id_user_two;

/**
 * @var int
 *
 * @ORM\Column(name="read", type="integer")
 */
protected $read;

/**
 * @var int
 *
 * @ORM\Column(name="last_send", type="integer")
 */
protected $last_send;

My controller :

$em = $this->getDoctrine()->getManager();

$user = $em->getRepository(User::class)->findOneBy(array('id' => ($request->get('id_user'))));
$friend = $em->getRepository(User::class)->findOneBy(array('id' => ($request->get('id_friend'))));

$new_conv = new Conversation();
$new_conv->setLastSend($user->getId());
$new_conv->setRead(0);
$new_conv->setIdUserOne($user);
$new_conv->setIdUserTwo($friend);
$em->persist($new_conv);
$em->flush();
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 iOS开发关于快捷指令截屏后如何将截屏(或从截屏中提取出的文本)回传给本应用并打开指定页面
    • ¥15 unity连接Sqlserver
    • ¥15 图中这种约束条件lingo该怎么表示出来
    • ¥15 VSCode里的Prettier如何实现等式赋值后的对齐效果?
    • ¥15 流式socket文件传输答疑
    • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
    • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
    • ¥15 win10,这种情况怎么办
    • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
    • ¥100 在连接内网VPN时,如何同时保持互联网连接