Your question has been submitted and is awaiting moderation.
Thank you for reporting this content, moderators have been notified of your submission.
I am trying to install DNN documents module 6 on DNN 7 using the Extension install wizard but I am receiving the following error:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ForceDownload'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:e1233812-5aec-469e-be6c-f8233acf1b5d CREATE PROCEDURE dbo.UpdateDocument @ModuleId INT, @ItemId INT, @Title nvarchar(150), @URL nvarchar(250), @UserId INT, @Category nvarchar(50), @OwnedByUserID INT, @SortOrderIndex INT, @Description nvarchar(255), @ForceDownload BIT AS UPDATE dbo.Documents SET Title = @Title, URL = @URL, Category = @Category, OwnedByUserID = @OwnedByUserID, ModifiedByUserID = @UserId, ModifiedDate = getdate(), SortOrderIndex = @SortOrderIndex, Description = @Description, ForceDownload = @ForceDownload WHERE ItemId = @ItemId AND ModuleId = @ModuleId System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ForceDownload'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:7e1ac083-fcb3-4128-920c-a8d651b9d407 CREATE PROCEDURE dbo.GetDocument @ItemId INT, @ModuleId INT AS SELECT Documents.Itemid, Documents.Moduleid, Documents.Title, Documents.Url, Documents.Category, CreatedByUser.FirstName + ' ' + CreatedByUser.LastName AS "CreatedByUser", OwnedByUser.FirstName + ' ' + OwnedByUser.LastName AS "OwnedByUser", ModifiedByUser.FirstName + ' ' + ModifiedByUser.LastName AS "ModifiedByUser", Files.Size, Files.ContentType, UrlTracking.TrackClicks, UrlTracking.Clicks, UrlTracking.NewWindow, Documents.OwnedByUserID, Documents.ModifiedByUserID, Documents.ModifiedDate, Documents.CreatedByUserID, Documents.CreatedDate, Documents.SortOrderIndex, Documents.Description, Documents.ForceDownload FROM dbo.Documents LEFT OUTER JOIN dbo.Users AS CreatedByUser on Documents.CreatedByUserID = CreatedByUser.UserId LEFT OUTER JOIN dbo.Users AS OwnedByUser on Documents.OwnedByUserID = OwnedByUser.UserId LEFT OUTER JOIN dbo.Users AS ModifiedByUser on Documents.ModifiedByUserID = ModifiedByUser.UserId LEFT OUTER JOIN dbo.UrlTracking on Documents.URL = UrlTracking.Url and UrlTracking.ModuleId = @ModuleID LEFT OUTER JOIN dbo.Files on Documents.URL = 'fileid=' + convert(varchar,dbo.Files.FileID) WHERE dbo.Documents.ItemId = @ItemId and dbo.Documents.ModuleId = @ModuleId System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ForceDownload'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ce1c3421-9382-4402-a75e-3fe38b87bbec CREATE PROCEDURE dbo.GetDocuments @ModuleId INT, @PortalId INT AS SELECT Documents.ItemId, Documents.Moduleid, Documents.Title, Documents.Url, CreatedByUser.FirstName + ' ' + CreatedByUser.LastName AS "CreatedByUser", OwnedByUser.FirstName + ' ' + OwnedByUser.LastName AS "OwnedByUser", ModifiedByUser.FirstName + ' ' + ModifiedByUser.LastName AS "ModifiedByUser", Documents.Category, Files.Size, UrlTracking.TrackClicks, UrlTracking.Clicks, UrlTracking.NewWindow, Documents.OwnedByUserID, Documents.ModifiedByUserID, Documents.ModifiedDate, Documents.CreatedByUserID, Documents.CreatedDate, Documents.SortOrderIndex, Documents.Description, Documents.ForceDownload FROM dbo.Documents LEFT OUTER JOIN dbo.Users AS CreatedByUser on dbo.Documents.CreatedByUserID = CreatedByUser.UserId LEFT OUTER JOIN dbo.Users AS OwnedByUser on dbo.Documents.OwnedByUserID = OwnedByUser.UserId LEFT OUTER JOIN dbo.Users AS ModifiedByUser on dbo.Documents.ModifiedByUserID = ModifiedByUser.UserId LEFT OUTER JOIN dbo.Files on dbo.Documents.URL = 'fileid=' + convert(varchar,dbo.Files.FileID) LEFT OUTER JOIN dbo.UrlTracking on dbo.Documents.URL = dbo.UrlTracking.Url and dbo.UrlTracking.ModuleId = @ModuleID WHERE Documents.ModuleId = @ModuleId ORDER by Documents.Title System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ForceDownload'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:03a1d234-b070-4231-813c-0a638521b426 CREATE PROCEDURE dbo.AddDocument @ModuleId INT, @Title NVARCHAR(150), @URL NVARCHAR(250), @UserId INT, @OwnedByUserId INT, @Category NVARCHAR(50), @SortOrderIndex INT, @Description NVARCHAR(255), @ForceDownload BIT AS INSERT INTO dbo.Documents ( ModuleId, Title, URL, CreatedByUserID, CreatedDate, Category, OwnedByUserID, ModifiedByUserID, ModifiedDate, SortOrderIndex, Description, ForceDownload ) VALUES ( @ModuleId, @Title, @URL, @UserId, getdate(), @Category, @OwnedByUserId, @UserId, getdate(), @SortOrderIndex, @Description, @ForceDownload ) SELECT SCOPE_IDENTITY()