Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'

Hi,

I installed the module and had some problems with the Open Document Library module which uses Ajax so I uninstalled the Page Blaster module and removed the reference to Page blaster module in the web.config file. I then updated a few settings on the Open Document Library module then tried to reinstall the Page Blaster module however with the following error occurred.

Richard 

ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.ModuleDefinitions'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.RegisterModules(PaFolder Folder, ArrayList Modules, ArrayList Controls) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

Hi John,

PageBlaster is no longer available in the admin menu. I am new to DNN so I am not sure how you go about running a DNN script form the SQL command line.

Richard

I have attached the uninstall script to this post.

All you need to do is copy the text, then go to your Host > SQL page and paste it into the window and click on execute it will remove the records that are causing a conflict.

Then you can re-install it.

Hi John,

Thank you for the time you have spent trying to resolve this issue. All appears to be working however when I entered the license key and then went to save the following error appeared in the dialogue box of the module 'Object reference not set to an instance of an object'

Thanks for letting me know about the website restarting I will try to resovle this issue

Thanks again for your time

No problem.

I have attached a debug version to this post. If you can put the attached files into your /bin file (overwritting the dll that is already there and adding the .pdb), then try saving the config.  The Log Viewer should have more information for us to figure out why it is not saving properly.

After adding the new files to the BIN directory, the following happens the module fails to work, all of the menu items disappear and the module does not show any text  there is also a message stating error on web page on the bottom right hand corner of internet explorer. I have removed the reference to page blaster from the web.config in order to disable the module.