|
Joined: 12/13/2008
Posts: 1
|
|
|
I had a corrupted feedback module. I deleted the mod and tried to reinstall the curent version 4.4.3 of from DotNetNuke. I now get error on the install and unable to use the feedbacl mod.
I am using DNN 5.1
|
Here is the error report.
|
Error loading files from temporary folder - see below |
StartJob |
Starting Installation |
Info |
Starting Installation - DNN_Feedback |
Info |
Starting Installation - Script |
Info |
Begin Sql execution |
Info |
Creating backup of previous version - 03.02.01.SqlDataProvider |
Info |
Created - 03.02.01.SqlDataProvider |
Info |
Executing 03.02.01.SqlDataProvider |
Info |
Start Sql execution: 03.02.01.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. 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 Stored Procedures **/ create procedure usr_sroberts.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. 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 usr_sroberts.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. 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 usr_sroberts.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. 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 usr_sroberts.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
Info |
End Sql execution: 03.02.01.SqlDataProvider file |
Info |
Creating backup of previous version - 04.04.01.SqlDataProvider |
Info |
Created - 04.04.01.SqlDataProvider |
Info |
Executing 04.04.01.SqlDataProvider |
Info |
Start Sql execution: 04.04.01.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. 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) IF NOT (SELECT COLUMNPROPERTY( OBJECT_ID(N'usr_sroberts.[Feedback]'),'PortalID','CategoryID')) IS NULL update usr_sroberts.[Feedback] set [CategoryID] = [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. 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) ALTER TABLE usr_sroberts.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. 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) ALTER TABLE usr_sroberts.[Feedback] DROP COLUMN FeedbackGUID |
Info |
End Sql execution: 04.04.01.SqlDataProvider file |
Info |
Creating backup of previous version - 04.04.02.SqlDataProvider |
Info |
Created - 04.04.02.SqlDataProvider |
Info |
Executing 04.04.02.SqlDataProvider |
Info |
Start Sql execution: 04.04.02.SqlDataProvider file |
Info |
End Sql execution: 04.04.02.SqlDataProvider file |
Info |
Creating backup of previous version - 04.04.03.SqlDataProvider |
Info |
Created - 04.04.03.SqlDataProvider |
Info |
Executing 04.04.03.SqlDataProvider |
Info |
Start Sql execution: 04.04.03.SqlDataProvider file |
Info |
End Sql execution: 04.04.03.SqlDataProvider file |
Info |
Creating backup of previous version - Uninstall.SqlDataProvider |
Info |
Created - Uninstall.SqlDataProvider |
Info |
Finished Sql execution |
Info |
Component installed successfully - Script |
Info |
Starting Installation - Cleanup |
Info |
Processing Cleanup File - 4.4.3 |
Info |
Completed Processing of Cleanup File - 4.4.3 |
Info |
Component installed successfully - Cleanup |
Info |
Starting Installation - Module |
Failure |
ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'usr_sroberts.ModuleDefinitions'. The statement has been terminated. 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.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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install() |
Failure |
Installation Failed - Module |
Info |
Rolling back component install - Script |
Info |
Restored backup of previous version - 03.02.01.SqlDataProvider |
Info |
Restored backup of previous version - 04.04.01.SqlDataProvider |
Info |
Restored backup of previous version - 04.04.02.SqlDataProvider |
Info |
Restored backup of previous version - 04.04.03.SqlDataProvider |
Info |
Restored backup of previous version - Uninstall.SqlDataProvider |
Info |
Component rolled back successfully - Script |
Info |
Rolling back component install - Cleanup |
Info |
Component rolled back successfully - Cleanup |
Info |
Installation Failed - DNN_Feedback |
Info |
Deleted temporary install folder |
EndJob |
Installation Failed |
|
|
|
|
|
|