Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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 ForumsFeedbackFeedbackUnalbe to install, SQL ErrorsUnalbe to install, SQL Errors
Previous
 
Next
New Post
7/12/2010 7:19 PM
 
DNN 5.04.04 Community Edition

My Story:

I uninstalled the old feedback module because I could not get the email function to work properly, It would only send emails if I used my account.  If someone else entered in their email account for the email field the emails simply got lost and no one was getting any emails from the form requests.  Only if I used my email address would it work.  Didnt matter about whos account was logged in.  So pretty much the feedback module was useless as a contact form.  It was only good as... a feedback module.

So then I seen the new release you have been working on version 5.  I tried beta and the RC got the same errors as below.

I had uninstalled the old feedback module already.  I had some good feedback too I hope it wasnt lost although I will not hold my breath.  I want to be able to have multiple portals with pages that have contacts and a form for each contact that emails them (not me) each time.  There is only one place for SMTP settings in DNN so using one account to send all these emails is fine I have full control of the servers.  Using basic setting for sending emails with authentication but only if I use the same email as the one that is in the SMTP as the reply address did the version 4 work.

Now with trying to install 5 I simply cant get it to install to even see if this issue has been resolved so that I can send different emails to different users from different clients using the one SMTP setting to authenticate and send the emails.

I am hoping this is something easy to fix here below is the error I get when trying to install.

I am using windows 2003 server IIS 6.0, MySQL Express 2008 (although I plan to upgrade to standard edition soon)

Thanks for the support!


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: 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.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 dbo.dnn_CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into dnn_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.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 dbo.dnn_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 dnn_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 dnn_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 dbo.dnn_GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from dnn_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 dbo.dnn_UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update dnn_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
7/12/2010 10:49 PM
 
Based on the following lines in the upgrade report:

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

it appears that there were artifacts left over from the prior Feedback installation that did not get removed when you uninstalled the earlier version. As I recall, there were some uninstall issues in versions 3.02.01 and 4.04.01. At any rate, when installing the 5.00.00 Beta or 5.00.01 RC (not sure from which install you posted the package installation report), the installer saw that there was still a 3.02.01.SqlDataProvider script, created a backup copy of it, then tried to install from version 03.02.01 onward rather than from 5.00.00 onward. Since the feedback table (which still existed following the uninstall) had already been altered previously, the re-run of the 03.02.01.SqlDataProvider script caused numerous errors.

I do believe that when you uninstalled the old feedback module you lost all of your feedback items. When upgrading modules in the future, do not uninstall the older version first - simply install the newer version over the existing using the Host-->Extensions-->Install Extension Wizard. That way, your old data should be preserved.

I would also caution against installing beta or even RC releases on live sites unless you have backed up both the files and database prior to the beta/RC install and are prepared to roll back using the backups should something go wrong.

As far as resolving your current situation, it will be first necessary to manually remove all traces of the Feedback module from the DesktopModules\Feedback folder and any tables and stored procedures relating to the Feedback module from the database. There are two feedback related tables, Feedback and FeedbackLists. Prior to version 5.00.00, the feedback related stored procedures did not have the prefix Feedback_ which makes finding and deleting them a bit difficult. Once you have removed all traces of the Feedback module, and made backups (just in case) you may attempt an install of Feedback 05.00.01 RC. Ideally, this would be done on a test site rather than your live site.

Regarding your problem with emails not being sent when the sender email was different than your account, that is not a Feedback module problem but rather a common condition imposed by your site's hosting provider to prevent relay of emails having a different sender domain than that of the hosting account. The Feedback module provides in its settings a field in which to enter a "Send From" address. The Send From address should be in the same domain as your hosting account and will be used instead of the sender's email address entered on the Feedback form. In Feedback 05.00.00 and above, the sender's actual email address is made available in the email body.

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
 
New Post
7/27/2010 12:04 AM
 
Thanks for the help this was the issue and has been resolved.

I will be seeing if I can use this as an actual contact form for people now.  I could not seem to send emails to other people unless they where from me.  I am not going to open a relay server and I have had stuff like this work before.  I look forward to testing out all the new features thanks a lot for supporting this module.

William
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackUnalbe to install, SQL ErrorsUnalbe to install, SQL Errors


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out