Blog Made Simple: Posting Order

[mnapiork]

I've installed Blog Made Simple and everything appears to be working fine except the ordering of the posts.  Newer posts appear after older posts. I've set the oldestfirst="false" and the oldestfirst="true" and neither parameter seems to affect the order of the posts. 

Does anyone know how to fix this problem?

Thanks in advance,
Michael

[mnapiork]

Found a solution. I ended up modifying the SQL statements in Blogs.module.php in the Blog module directory  to DESC instead of ASC.  I'm never going to want the blog in the reverse order so this works for me.

Michael

[blaquekaat]

Hi Micheal

I'm having the same issue as you. I've changed every mention of ASC to DESC that I could find with no luck. Could you be more specific as to what you changed and where?

Blaquekaat

[swapdude]

Hi mnapiork,

Find this statement in Blogs.Module.php

$query="SELECT DISTINCT entry.* FROM ".cms_db_prefix()."module_blogs_entries AS entry LEFT JOIN ".cms_db_prefix()."module_blogs_comments AS comment ON entry.id=comment.entry WHERE entry.category=? $active ORDER BY comment.createtime";

And change the last part from comment.createtime -> entry.createtime

That should do it.

Swap