Thanks mate that worked a treat, there was a spelling mistake in there (for the noobs) might just make it clear.

Change #1:
Before: @sql = 'INSERT INTO #PageIndex(ThreadID) SELECT DISTINCT(P.ThreadID) CreatedDate ' + 
After:    @sql = 'INSERT INTO #PageIndex(ThreadID) SELECT P.ThreadID ' +

Change #2:
Before: @Filter + ' GROUP BY P.ThreadID , P.CreatedDate ORDER BY P.CreatedDate '
After: @Filter + ' GROUP BY P.ThreadID ORDER BY MAX(P.CreatedDate) DESC '

To keep it brief, so no-one needs to waste time trawling the forums, the procedure is Forum_SearchGetResults, you'll find it in programmability under your database in ms sql manager.

thanks heaps

a

Interesting that this is still a bug.  I have the latest version of the Forum module, clean install 4.6.2 DNN Core and yet I still had this issue.  I just found the info on how to fix the stored procedure and modified it.  It works.  Thanks to DNN Forums.  I hope this is getting addressed in the new Forum module.

@Matthías,

Regarding your answer to edgar, you are right, he cannot edit Database.mdf with Notepad. But his question was more about "How to apply this solution when the DNN installation is on a Shared Hosting and he does not have direct access to the database".

I am facing the same situation, with another shared hosting provider, and I do not have direct access to my Database.mdf. The only "tool" I have available from my "Hosting Admin Panel" is a very simple window with one textbox in which to insert an SQL statment, and below a button called "Execute".

I know there be a way to solve this issue just sending a command through that SQL statement window. But it its out of my experience's reach ;-)

Any suggestions will be very welcome. Thank you!

Alejandro.