 |
|
|
|
Joined: 5/10/2005
Posts: 2
|
|
|
Hi,
I'm having problem installing the module with the error message pasted below. Below is the system information:
DotNetNuke Community Edition 06.00.02 (72)
Windows Server 2008 R2
SQL Server 2008 R2 (Express Edition)
Any help would be greatly appreciated.
| Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'CreatedByEmail'. Invalid column name 'DateCreated'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection. (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 dbo.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 '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. (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.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. (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.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection. (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.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
|
| |
|
|
 | |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
It appears that there had been a prior failed attempt to install the feedback module which left some related objects (most likely the Feedback table) in the database. All of the invalid columns mentioned in the error were either renamed or dropped in versions of the Feedback module later than the initial 3.02.01. Do you recall that a prior installation attempt was made and what errors resulted at that time?
I would suggest manually removing any traces of the prior installation (in particular the tables Feedback and FeedbackList) from the database then re-attempt the installation.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
Joined: 5/10/2005
Posts: 2
|
|
|
Hi,
Thanks for the advice. Although I don't remember installing it before as I just set up the DNN last week, but the Feedback and FeedbackList tables are in the database. Removed them and the installation goes fine.
|
| |
|
|
| |
|
|
 |
Joined: 10/10/2010
Posts: 9
|
|
|
Hi there
I had the same problem in my DNN 7 installation on Windows Azure and I am sure, I never installed the Feedback Module! However, I had to remove the Feedback and the FeedbackList tables in my database and the installation went fine.
Thanks for this great and simple solution!
|
| |
|
|
| |