I'm using DNN 4.5.1 in a hosted environment, no admin access to the SQL database. I updated the Stored Procedure (SP) using the Host SQL module. These instructions assume you have NO custom {databaseOwner} or {objectQualifier} settings in your database or web.config.
1) Download the Forum_03.20.09_Install.zip from DotNetNuke.com
2) Extract the files.
3) Open the 03.20.07.SqlDataProvider file in a text editor and copy ALL the text for Forum_SearchGetResults, from the "CREATE PROCEDURE" statement to the "GO" statement. Paste this into a new text file.
4) Change "CREATE PROCEDURE" to "ALTER PROCEDURE"
5) Delete all instances of {databaseOwner} and {objectQualifier}
6) As noted above, edit the line starting with @Filter. The new line should read:
@Filter + ' GROUP BY P.ThreadID , P.CreatedDate ORDER BY P.ThreadID '
7) Remove the GO command from the bottom of the file.
8) Double check your work...
9) Login to your DNN portal as Host. Go to the SQL page and paste in your edited Stored Procedure. All of it.
10) Cross your fingers. Check the "Run as Script" box and click the "Execute" button.
Now try a search on your portal... it worked for me. Hope it works for you!! Insert standard legal disclaimer here... 