Thread: 4.0 patch 2 Blog order

Blogs appear as earliest first, not most recent. I think it would be more convenient to read the most current blog first and then scroll to see the previous posts if desired.

Hi - you are the winner!

The first aeDating v4.0 Patch 2 bug posted here in the CLEAN Bug forum.

I agree - this is a functionality bug. Where something does not function as most people would expect it too.

Most People would expect to the the latest blog first.

Smoge

Here is a possible fix for the blog order issue. Perhaps some of you can test it and see if it fits your needs.

The blogs the owner writes are in DESC order... newest first.

The comments made by others are under the original blog post, in an ASC order.

This has been added to CLEAN v0.04 for now - if there is some issue with it - it will be updated

Find in blog.php

Code:

$res = db_res("SELECT *, count( branch )-1 AS comments
                    FROM `Blog`
                    WHERE `owner` = '{$owner}
'
                    GROUP BY `branch`
                    ORDER BY `date`, `branch` ASC
                    LIMIT {$from}, {$step}");
    while($blogs = mysql_fetch_array($res))

Change to

Code:

$res = db_res("SELECT *, count( branch )-1 AS comments
                    FROM `Blog`
                    WHERE `owner` = '{$owner}
'
                    GROUP BY `branch`
                    ORDER BY `date` DESC
                    LIMIT {$from}, {$step}");
    while($blogs = mysql_fetch_array($res))

Smoge,

I made the single line change per your post to the blog.php file:-

ORDER BY `date` DESC

Does not seem to work? Am i not doing this right or could Drakontas confirm if this works ?? Seems like not coming out in descending order, newest first?

chris c

There are too many problems in 4.0 patch 2 for me to fix on my own so I'm awaiting Smoge to install the Clean version... I haven't gone in to try any fixes yet, sorry.

I just applied the fix Smoge suggested and it worked fine on my site.

Originally Posted by Drakontas

I just applied the fix Smoge suggested and it worked fine on my site.

Thanks for letting me know, it must be me not doing this right. Let me attempt a retry or wait I might until Smoge updates to Clean v004.

chris c

With this - blogs should be descending - but comments are not (if I am not mistaken)... perhaps this should be changed too?

Chris - I'll get you upgraded to CLEAN v0.04 as soon as I can - it looks like you are in a testing mood! (which is great!)

Smoge

Originally Posted by chris c

Smoge,

I made the single line change per your post to the blog.php file:-

ORDER BY `date` DESC

Does not seem to work? Am i not doing this right or could Drakontas confirm if this works ?? Seems like not coming out in descending order, newest first?

chris c

Originally Posted by Smoge

With this - blogs should be descending - but comments are not (if I am not mistaken)... perhaps this should be changed too?

Chris - I'll get you upgraded to CLEAN v0.04 as soon as I can - it looks like you are in a testing mood! (which is great!)

Smoge

G4 template, IE 6.0.29, i checked and confirmed your revised code on my site.

The blog however still shows up as last in , last out (meaning latest post at the bottom and original first post on top); irrespective of blog owner or third party appending. ? (see attachment)

Duplicates were from browser refresh.


Could someone else confirm (Cleanv0004), Drakontas seems to have it working correctly ?

chris c