Hi,

not sure if this has been already reported:

I am on blog version 03.04.00 and noticed that the comments of a blog are not sorted at all. I figured the reason quite fast, it is a missing ORDER BY in the used stored procedure.

Here is the complete "fixed" one:

ALTER PROCEDURE [dbo].[dnn_Blog_ListComments]
@EntryID as Int,
@ShowNonApproved bit=0
AS

SELECT
    C.[CommentID],
    C.[EntryID],
    C.[UserID],
    C.[Title],
    C.[Comment],
    C.[AddedDate],
    U.[UserName],
    U.[FirstName] + ' ' + U.[LastName] AS UserFullName,
    C.[Author],
    C.[Approved]

FROM
    dbo.dnn_Blog_Comments C
    LEFT JOIN
    dbo.dnn_Users U ON C.[UserID] = U.[UserID]

WHERE
    [EntryID] = @EntryID AND
    (C.[Approved]=1 OR C.[Approved] <> @ShowNonApproved)

ORDER BY
    C.[AddedDate]

Please note: you might have to alter the dnn_ in the name of the stored prodecure. I use it on my systems as dnn prefix.

Regards,
Tom.

Hi Tom,

I just modified the Blog_ListComments stored procedure in the databese as you suggested, and it works great. Thank you very much for the enhancement, I hope that Don will be including this in the next version, thank you Don.

Best regards,
Dario Rossa