I just purchased the module from Snowcovered and did an install. During the install I encountered the following exception. I ran the install again and did not see the same issue, but wanted to confirm that this was the way to correct the error. Please advise
Info Executing 01.00.02.SqlDataProvider
StartJob Start Sql execution: 01.00.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'convert'. 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_GetUpdatedShoppingCart ( @rowIndex int, @rowEnd int ) AS BEGIN -- select top @rowEnd * into #TempShoppingCart from Smith_ShoppingCart order by CartID -- Delete from #TempShoppingCart where CartID in (Select top @rowStart CartID from -- #TempShoppingCart order By CartID DESC) -- Select * from #TempShoppingCart -- Drop Table #TempShoppingCart declare @vSQL varchar(1000) --, @rowIndex int, @rowEnd int -- select @numrows = 25 select @vSQL = 'select top ' convert(varchar, @rowEnd) ' * from Smith_ShoppingCart Order by CartID Delete from #TempShoppingCart where CartID in (Select top ' convert(varchar, @rowIndex) ' * from #TempShoppingCart order By CartID DESC) Select * from #TempShoppingCart Drop Table #TempShoppingCart' Execute (@vSQL) END
EndJob End Sql execution: 01.00.02.SqlDataProvider file
EndJob Finished Sql execution