Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackinstall failure on 5.5.1install failure on 5.5.1
Previous
 
Next
New Post
12/7/2010 12:55 PM
 
I  got the following error on the install:

Package Installation Report

See below for the results of the package installation
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 - Providers\DataProviders\SqlDataProvider\03.02.01.SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\03.02.01.SqlDataProvider
Info Executing 03.02.01.SqlDataProvider
Info Start Sql execution: 03.02.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Category'. Invalid column name 'CreatedByEmail'. Invalid column name 'DateCreated'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 dbo.dnn1_CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into dnn1_Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Category'. Invalid column name 'CreatedByEmail'. Invalid column name 'DateCreated'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'CreatedByEmail'. Invalid column name 'DateCreated'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.dnn1_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 dnn1_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 dnn1_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 (0x80131904): Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.dnn1_GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from dnn1_Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.dnn1_UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update dnn1_Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID
Info End Sql execution: 03.02.01.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Feedback
Info Deleted temporary install folder
EndJob Installation Failed
 
New Post
12/7/2010 9:18 PM
 
I assume that you are installing Feedback version 05.00.02 and that you are not upgrading a prior install of an earlier version of Feedback.

It appears that a prior attempt to install the Feedback module had failed to complete. When the DotNetNuke extensions installer encounters an error, it attempts to rollback the changes made to the file system and entension registration but is not able to roll back changes that were made to the database. In this case, the scripts for the creation of a later version the Feedback table had completed leaving it still in the database. When you tried (again) to install the Feedback module, the installer thought this was a first time installation of Feedback 05.00.02 and re-ran the database object creation scripts from the beginning, starting with 03.02.01. However, since later versions of the module had renamed or removed some of the columns in the Feedback table (which still exists in the database), the 03.02.01.SqlDataProvider script reported errors due to missing columns in the table.

Following a failed attempt to install a module, it is important to either completely restore the site from a backup of the filesystem and database or manually remove any database objects related to that failed module install.  In this case, if you manually delete the two tables Feedback and FeedbackList from the database, you should be able to reattempt the installation successfully.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer.
Coming Soon: By Invitation and FRBO-For Rent By Owner
 
New Post
12/7/2010 10:38 PM
 
Thanks, once again for your assistance. There was an older version that was installed, although this is a relativily new dnn install from early, I tried to uninstall it prior to installing the newer version as I had only one test instance of the module on a test page. The uninstall failed saying there was a ModuleLoadException: Object reference not set to an instance of an object---. System.NullReferenceException: Object reference not set to an instance of an object at DotNetNukeServices.InstallerPackages.PackageController.CanDeletePackage(packageInfo package, PortalSettings portalSettings) at DotNetNuke.Modules.Admin.Extensions. Uninstall.Page_Load(Object sender, EventArgs e)-- Its really all greek to me not being a coder guy, however I do have the tools to access my database and delet the tables it that fits with the above.
 
New Post
12/11/2010 11:01 AM
 
It turns out I had some folder permission problems. Thanks
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackinstall failure on 5.5.1install failure on 5.5.1


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Copyright 2014 by DNN Corp | Terms of Use | Privacy | Design by Parker Moore Design