We are getting the following installation error on a DNN v. 5.04.01 Portal.
Info |
Start Sql execution: 02.98.00.SqlDataProvider file |
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'SortOrder'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Smith_ListCatSubCat @TabModuleId int, @PortalId int AS SELECT c.CategoryID, c.CategoryName,c.SortOrder, c.Share, c.ParentID, c.catseourl, p.categoryname as 'parentcategoryname' FROM Smith_Category c left join Smith_Category p on c.parentid = p.categoryid WHERE ( C.TabModuleId = @TabModuleId OR C.Share = 1) and c.PortalId = @PortalId ORDER BY [SortOrder] |