问题描述
我正在关注 symblog symfony2 教程的第 5 部分:
i am following part 5 of the symblog symfony2 tutorial:
http://tutorial.symblog.co.uk/docs/customising-the-view-more-with-twig.html
在标题下:主页 - 博客和评论
under heading: The Homepage - Blogs and Comments
什么时候更新:
// src/Blogger/BlogBundle/Repository/BlogRepositoy.php
public function getLatestBlogs($limit = null)
{
$qb = $this->createQueryBuilder('b')
->select('b, c')
->leftJoin('b.comments', 'c')
->addOrderBy('b.created', 'DESC');
if (false === is_null($limit))
$qb->setMaxResults($limit);
return $qb->getQuery()
->getResult();
}
以及当我更新时:
{# src/Blogger/BlogBundle/Resources/views/Page/index.html.twig #}
{# .. #}
<footer class="meta">
<p>Comments: <a href="{{ path('BloggerBlogBundle_blog_show', { 'id': blog.id }) }}#comments">{{ blog.comments|length }}</a></p>
<p>Posted by <span class="highlight">{{ blog.author }}</span> at {{ blog.created|date('h:iA') }}</p>
<p>Tags: <span class="highlight">{{ blog.tags }}</span></p>
</footer>
{# .. #}
然后我刷新浏览器并出现错误:
i then refresh my browser and get error:
[Semantical Error] line 0, col 71 near 'c ORDER BY b.created': Error: Class
Blogger\BlogBundle\Entity\Blog has no association named comments
500 Internal Server Error - QueryException
<?php
// src/Blogger/BlogBundle/Entity/Blog.php
namespace Blogger\BlogBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;
/**
* @ORM\Entity(repositoryClass="Blogger\BlogBundle\Repository\BlogRepository")
* @ORM\Table(name="blog")
* @ORM\HasLifecycleCallbacks()
*/
class Blog
{
public function __toString()
{
return $this->getTitle();
}
/**
* @ORM\Id
* @ORM\Column(type="integer")
* @ORM\GeneratedValue(strategy="AUTO")
*/
protected $id;
/**
* @ORM\Column(type="string")
*/
protected $title;
/**
* @ORM\Column(type="string", length=100)
*/
protected $author;
/**
* @ORM\Column(type="text")
*/
protected $blog;
/**
* @ORM\Column(type="string", length="20")
*/
protected $image;
/**
* @ORM\Column(type="text")
*/
protected $tags;
protected $comments;
/**
* @ORM\Column(type="datetime")
*/
protected $created;
/**
* @ORM\Column(type="datetime")
*/
protected $updated;
public function __construct()
{
$this->comments = new ArrayCollection();
$this->setCreated(new \DateTime());
$this->setUpdated(new \DateTime());
}
public function setUpdatedValue()
{
$this->setUpdated(new \DateTime());
}
/**
* Get id
*
* @return integer
*/
public function getId()
{
return $this->id;
}
/**
* Set title
*
* @param string $title
*/
public function setTitle($title)
{
$this->title = $title;
}
/**
* Get title
*
* @return string
*/
public function getTitle()
{
return $this->title;
}
/**
* Set author
*
* @param string $author
*/
public function setAuthor($author)
{
$this->author = $author;
}
/**
* Get author
*
* @return string
*/
public function getAuthor()
{
return $this->author;
}
/**
* Set blog
*
* @param text $blog
*/
public function setBlog($blog)
{
$this->blog = $blog;
}
/**
* Get blog
*
* @return text
*/
public function getBlog($length = null)
{
if (false === is_null($length) && $length > 0)
return substr($this->blog, 0, $length);
else
return $this->blog;
}
/**
* Set image
*
* @param string $image
*/
public function setImage($image)
{
$this->image = $image;
}
/**
* Get image
*
* @return string
*/
public function getImage()
{
return $this->image;
}
/**
* Set tags
*
* @param text $tags
*/
public function setTags($tags)
{
$this->tags = $tags;
}
/**
* Get tags
*
* @return text
*/
public function getTags()
{
return $this->tags;
}
/**
* Set created
*
* @param datetime $created
*/
public function setCreated($created)
{
$this->created = $created;
}
/**
* Get created
*
* @return datetime
*/
public function getCreated()
{
return $this->created;
}
/**
* Set updated
*
* @param datetime $updated
*/
public function setUpdated($updated)
{
$this->updated = $updated;
}
/**
* Get updated
*
* @return datetime
*/
public function getUpdated()
{
return $this->updated;
}
}
请帮忙解决这个问题.我不知道我哪里错了
please help solve this. i dont know where i went wrong
谢谢
推荐答案
您没有粘贴 src/Blogger/BlogBundle/Entity/Blog.php 文件.这将有助于解决您的问题.
You didn't paste the src/Blogger/BlogBundle/Entity/Blog.php file. It would help resolving your issue.
很可能您没有向实体添加评论字段(或没有正确注释).
Most probably you didn't add comments field to your entity (or didn't annotate it properly).
类似问题:Doctrine2:有什么问题这些实体之间的关联?
现在当你粘贴你的实体时,我可以看到评论字段没有被注释.Doctrine 的实体管理器对此一无所知.您必须提供映射(在您的情况下通过注释).
Now when you pasted your entity I can see the comments field is not annotated. Doctrine's entity manager doesn't know anything about it. You have to provide mapping (in your case via annotations).
编辑 2:
在你的实体中你应该有 (src/Blogger/BlogBundle/Entity/Blog.php):
In your entity you should have (src/Blogger/BlogBundle/Entity/Blog.php):
/**
* @ORM\OneToMany(targetEntity="Comment", mappedBy="blog")
*/
protected $comments;
但你有:
protected $comments;
缺少映射.Doctrine 不知道如何使用你的领域.
Mapping is missing. Doctrine doesn't know how to use your field.
这篇关于我如何解决语义错误:“类没有名为..的关联"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!