Tried to upgrade my license to the CSS editor.
Got the message below....I uninstalled and reinstalled...same thing. The editor appears in the list of placeable modules but doesn't install to a pane.


I upgraded to DNN 4.8.1. yesterday with no apparent problems. Need help with completely removing the editor so I can install cleanly.


ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DNN4_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.DNN4_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()

The version you are using does it say CSS.Editor or CSS_Editor?

Also have you tried placing any other modules onto a page?

It says CSS_Editor

DNN: 4.8.1
Module version 1.9.9

I am able to add other 3rd party modules to the page.

One other thing to try and I am going to try and recreate this here, but can you create a new page and try to add the CSS module to that

Dave,

Great minds think alike....that's the first thing I tried before posting.

Thanks for your help.

I installed in 4.8.. uninstalled.. reinstalled... then I upgraded to 4.8.1 uninstalled.. installed.. and still working fine.

Is there anything else you can tell me about the install that might give me a clue?

Ah...the things that should be reported...

There was an install of an earlier version of the editor.

I did not uninstall that version before attempting to install the updated

I attempted to install 1.9.9 twice. I simply overlooked the fact that I'd installed it once.

Appears that my few other 3rd party modules are working on live sites.

Ken

I _think_ I got the above error installing it the second time but I am not certain.

After the second attempt, there there were two referencess to CSS_Editor in the module list.

I uninstalled both.

I reinstalled the editor, and got the error.

I tried to add the module to an existing page...nothing displayed.

I created a new page, tried to add the module...nothing displayed.

Dave,

any luck? If you can give me the sql code to 'clean out' the old install that would help.

Ken

Hello,
It appears that the index that is added to this table is causing the problem. On my instance of DNN 4.8.1 I do not have that index that is failing. Could this be something installed by one of the other modules on your site?
Thanks,