Unrecognized field: created_at while trying to get number of comments

[reverso73]

Hello,

I try to display on my "archive" page the number of comments for each post.
When I try to access to the property like this in archive.html.twig

{% for post in pager.getResults() %}
{{ post.getComments|length }}
{% else %}
{{ 'no_post_found'|trans({}, 'SonataNewsBundle') }}
{% endfor %}

I get :

An exception has been thrown during the rendering of a template ("Unrecognized field: created_at")

Do you have a trick to get the number of comments, validated if possible, for each post ?

Thanks

[rande]

Can you be more specific about this issue ?

[pulse00]

I'm getting the same error for the following template:

<div class="post">
    {{ post.title }}    
    {% media post.image, 'big' %}    
    <div  class="comments">
        {% for comment in post.comments %} 
          {% include 'MyBundle:Default:comment.html.twig' with { 'comment' : comment } %}         
        {% endfor %}    
    </div>
</div>

It happens when doctrine tries to load the OneToMany association:

(array('t0.post_id' => '1'), 
    array('fieldName' => 'comments', 
        'targetEntity' => 'Application\Sonata\NewsBundle\Entity\Comment', 
        'mappedBy' => 'post', 
        'cascade' => array('persist'), 
        'orphanRemoval' => true, 
        'orderBy' =>  array('created_at' => 'DESC'), 
        'type' => '4', 
        'inversedBy' => null, 
        'isOwningSide' => false, 
        'sourceEntity' => 'Application\Sonata\NewsBundle\Entity\Post', 
        'fetch' => '2', 
        'isCascadeRemove' => true, 
        'isCascadePersist' => true, 
        'isCascadeRefresh' => false, 
        'isCascadeMerge' => false, 
        'isCascadeDetach' => false)
    , '0', null, null
) 

[pulse00]

The reason is that the Post.orm.xml file in the ApplicationSonataNewsBundle was created with a wrong order_by node by the easy-extends Bundle.

Generated order-by:

 <order-by>
    <order-by-field name="created_at" direction="DESC" />
</order-by>

Shoud be:

<order-by>
    <order-by-field name="createdAt" direction="DESC" />
</order-by>

[rande]

can you create a PR ?

[pulse00]

sure, but it will take some time as i'm really busy atm.

[pulse00]

the PR is here, could you merge it?

It also contains german translations.

[pulse00]

thanks for merging. i guess this is solved then.