Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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 ForumsFeedbackFeedbackerror while installingerror while installing
Previous
 
Next
New Post
1/28/2008 1:00 PM
 

Hi,

I got the following error while installing Feedback
What to do?

With regards, Ton Hermes

TaakBeginnen Start uitvoer Sql: 04.04.02.SqlDataProvider bestand
Mislukt SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ModuleSettings'. Cannot insert duplicate key in object 'ModuleSettings'. 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.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) UPDATE dbo.[ModuleSettings] SET SettingName = N'Feedback_Width' FROM dbo.[DesktopModules] dm INNER JOIN dbo.[ModuleDefinitions] md ON dm.DesktopModuleID = md.DesktopModuleID INNER JOIN dbo.[ModuleSettings] ms INNER JOIN dbo.[Modules] m ON ms.ModuleID = m.ModuleID ON md.ModuleDefID = m.ModuleDefID WHERE (ms.SettingName = 'width') AND (dm.ModuleName = N'DNN_Feedback')
TaakEindigen Einde Sql uitvoer: 04.04.02.SqlDataProvider gereed


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
1/28/2008 4:31 PM
 

Ton - can you please try running the above mentioned script from within Enterprise manager and send me the results? The error indicates that you are violating some constraint, however all we're doing is an update.... Did you have a previous version installed on the same database?

Sanjay


AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
1/29/2008 2:51 PM
 

Hi Sanjay,

I do not have any knowledge about running a script within an enterprise manager.

I think the database has some corrupt fields now.
I tried to delete all the feedback items so I could start with an empty database.
However some feedback items are not  removed when I click the delete button.
I get the messagebox with the "are you sure" message, and after a click on the yes button the "deleted" item is not removed.
Maybe it is better to delete everything ?
Do I have to uninstall the feedback module for that to empty the database?
Do you have a script for me that deletes everything in the database that I can run in the DNN application

Many thanks.
Regards, Ton Hermes


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
1/29/2008 3:48 PM
 

If you go through the module definitions, you can delete the module which will automatically delete all the tables for the feedback module...

Sanjay


AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
1/30/2008 4:03 AM
 

Hi Sanya,

I deleted everything and installed the module again.
I added an instance of the module on a page ang got the error mentioned below.
After changing the language from Dutch to English and adding an instance of the module to a page again, everything went fine.
I did not get the error message again.
I tested the feedback module and it works fine now.

Thanks for your qiuck reply and the wonderfull feedback module.
With regards, Ton Hermes.

DotNetNuke.Services.Exceptions.ModuleLoadException: Exception of type 'System.Exception' was thrown. ---> System.Exception: Exception of type 'System.Exception' was thrown. at DotNetNuke.UI.ControlPanels.ControlPanelBase.AddNewModule(String title, Int32 desktopModuleId, String paneName, Int32 position, ViewPermissionType permissionType, String align) at DotNetNuke.UI.ControlPanels.IconBar.AddModule_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackerror while installingerror while installing


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