when i try to install on dnn 4.4.1 this module it gives me this error:
| StartJob |
Start Sql execution: 02.00.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 11: Incorrect syntax near '('. Incorrect syntax near the keyword 'As'. Line 40: Incorrect syntax near '('. 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.[Radiant_ListEntriesByPortal] @PortalID int, @MaxEntries int = 10, @CurrentPage int = 1 AS SELECT TOP(@MaxEntries * @CurrentPage) U.[UserID], U.[Username], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, E.[EntryID] as ItemID, E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, B.[ParentBlogID], B.[AllowAnonymous], B.[Syndicated] AS BlogSyndicated, B.[Public] AS BlogPublic, (Select Count(*) FROM dbo.[Blog_Comments] WHERE EntryID = E.EntryID AND (Approved = 1)) As CommentCount INTO #topentries FROM dbo.[Blog_Blogs] B INNER JOIN dbo.[Blog_Entries] E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.[Users] U ON B.[UserID] = U.[UserID] WHERE B.PortalID = @PortalID AND (E.[Published] = 1) AND (B.[Public] = 1) ORDER BY E.AddedDate DESC SELECT * FROM (SELECT TOP(@MaxEntries) * FROM #topentries ORDER BY AddedDate ASC) a ORDER BY AddedDate DESC |
|
|