ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Comment entries not ordering by date descending

December 28, 2010 12:38pm

Subscribe [4]
  • #1 / Dec 28, 2010 12:38pm

    Matt Weinberg

    489 posts

    Hello,

    I have this code on EE 2.1.1.

    {exp:comment:entries
        limit="10"
        dynamic="no"
        sort="desc"
        orderby="date"
        channel="channel1|channel2"
    }
        <li>
            <em>{author}</em> on <a href="http://{url_title_path="><strong>{title}</strong></a>
        </li>
    {/exp:comment:entries}

    However, the output puts out comments in this comment_id order:

    5, 6, 7, 8, 9, 14, 13, 12, 11, 10

    Obviously that’s not in date descending order—it starts by ascending, then jumps, then descends. Putting it in date ascending order works—it gives a comment_id order of:

    4, 5, 6, 7, 8, 9, 10, 11, 12, 13

    I looked in the 2.1.2 and 2.1.3 changelogs and didn’t see anything having to do with this kind of bug. I’d prefer not to upgrade unless this is a known issue fixed in those builds. Can you let me know?

    Thanks,
    Matt

  • #2 / Dec 28, 2010 4:24pm

    Ingmar

    29245 posts

    When you look at the actual entry dates, do they match that order? Are you using any sticky entries? An uzpgrade to 2.1.3 is still strongly recommneded, by the way.

  • #3 / Dec 28, 2010 4:26pm

    Matt Weinberg

    489 posts

    When I write the query manually (basically, SELECT * FROM exp_comments ORDER BY comment_date DESC LIMIT 10) it orders fine. Shouldn’t this tag sort by the comment dates regardless of the entry dates they’re attached to?

  • #4 / Dec 29, 2010 1:18am

    John Henry Donovan

    12339 posts

    Matt,

    In my testing I have replicated to some extent and have reported it as a bug on your behalf here

  • #5 / Jan 08, 2011 8:27am

    brebre

    75 posts

    same bug for me… with a count over 18 things go screwy and count order become unpredictable.

  • #6 / Jan 10, 2011 2:10am

    John Henry Donovan

    12339 posts

    Bug now has a status of Fixed for Next Release so closing this one out

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases