Hi
I have a forum problem with dnn sites that have been upgraded - all now at 3.4.5 on a good shared host.

When using My Posts or Search I get the following error:
A critical error has occurred.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 0

I'm not sure when this started happening as it was reported by a user but it did work previously.  I have seen another (unanswered) post on this subject so its maybe not an isolated incident. 

The stack trace says:
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 0 ---> System.Data.SqlClient.SqlException: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 0 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Forum.SqlDataProvider.SearchGetResults(String Filter, Int32 PageIndex, Int32 PageSize, Int32 UserID, Int32 ModuleID, DateTime FromDate, DateTime ToDate) at DotNetNuke.Modules.Forum.SearchController.SearchGetResults(String Filter, Int32 PageIndex, Int32 PageSize, Int32 UserID, Int32 ModuleID, DateTime FromDate, DateTime ToDate) at DotNetNuke.Modules.Forum.ThreadSearch.OnPreRender() at DotNetNuke.Modules.Forum.ForumBaseControl.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---


All adds up to Wah !

I can often find and fix from error info but this is beyond me
Any insights greatfully appreciated.

Thanks
Ian

If this is a site that has been upgraded several times, take a look at what DLL files you have in place.  I had substantial problems before, and they turned out to be version mismatches.  Sometimes an upgrade doesn't remove the old .DLL files and for some reason DNN uses the old ones instead of the new ones. 

I went through my DNN install, and removed all the DLL files with an older time/date stamp than the current version.  That cleared up a good 98% of my problems!

Forum Search and My Posts error. x2 sites  4.35 upgraded from 4.2 and 4.3

To follow up on this problem for the benefit of anyone else:

I uninstalled Forum 3.20.08 - installed 3.20.07 same problem.
After uninstalling 07 and trying 3.20.06 the problem goes away.

I guess the message is that when doing an upgrade check complex modules such as the forum before continuing.
Luckily both the sites I have this issue on can stand having old posts lost on this retrograde.

Bring back the discussions module !