Register | Log In
Download Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsFeedbackFeedbackFeed back module Error Feed back module Error
Previous
 
Next
New Post
1/27/2011 5:25 AM
 
User is offline netsoft netsoft


Joined: 7/22/2010
Posts: 5
Hi,

I have upgraded Dotnetnuke from 5.5 to 5.6.01

Previously Feedback module was working Properly. after upgradation it is not working.
so I have uninstalled and trying to install once again.
During installation Iam getting this exception.

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.SqlInternalConnection. (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.SqlInternalConnection. (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.SqlInternalConnection. (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.SqlInternalConnection. (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

Can any one help me please.
 
New Post
1/27/2011 8:55 AM
 
User is offline William Severance


William Severance's Avatar

www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3167
Do you recall what version of Feedback you were running?

How did you uninstall the Feedback module - using the delete command for the Feedback module in Host --> Extensions?

I am assuming that the Feedback module was not the current release version 05.00.02. The install errors that you posted are occuring in the database SQL script for the first released version, 03.02.01, and are an indication that the uninstall of the module that you did was not successfull in deleting the table Feedback (and probably other Feedback related objects) from the database. As I recall, the uninstall scripts of several of the earlier versions did not completely uninstall the module from the database.

You will have to manually delete the Feedback and FeedbackList tables from the database before attempting a re-install of Feedback 05.00.02. I think that you can leave any of the stored proceedures relating to the Feedback module in the database but if you are careful to identify and delete only those related to Feedback you should delete those also.

By the way, what were the problems with the Feedback module after upgrading to DNN 5.06.01?
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
1/27/2011 11:20 PM
 
User is offline netsoft netsoft


Joined: 7/22/2010
Posts: 5
Hi,

Thank You for your Reply.

This is the exception Iam getting after upgrading  from 5.5 to 5.6.01.

DotNetNuke.Services.Exceptions.ModuleLoadException: Could not load type 'DotNetNuke.Modules.Feedback.Feedback'. ---> System.Web.HttpParseException: Could not load type 'DotNetNuke.Modules.Feedback.Feedback'. ---> System.Web.HttpParseException: Could not load type 'DotNetNuke.Modules.Feedback.Feedback'. ---> System.Web.HttpException: Could not load type 'DotNetNuke.Modules.Feedback.Feedback'. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throw ) at System.Web.UI.TemplateParser.ProcessInheritsAttribute(String baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirectiveAttributes(IDictionary parseData) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ProcessException(Exception ex) at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseReader(StreamReader reader, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseInternal() at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.Parse(ICollection referencedAssemblies, VirtualPath virtualPath) at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType() at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider) at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace

The previous feedback version I have installed is 5.0.2
 
New Post
1/27/2011 11:28 PM
 
User is offline netsoft netsoft


Joined: 7/22/2010
Posts: 5
Hi,

Thank you.

I have taken old back up and uninstalled the complete feeed back module and installed it freshly. It is working fine Now.
 
 Page 1 of 1
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsFeedbackFeedbackFeed back module Error Feed back module Error


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP