OpenStore icon indicating copy to clipboard operation
OpenStore copied to clipboard

Error upgrading from version 4.0.5

Open vmasanas opened this issue 5 years ago • 1 comments

When trying to upgrade from version 4.0.5 to latest I get the following error:

... Info Module registered successfully - OS_ProductFilter Info Component installed successfully - Module Info Installation committed Info Installation successful. - OS_ProductFilter Info Starting Installation - OS_ItemList Info Starting Installation - Module Failure ExceptionSystem.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ModuleDefinitions' with unique index 'IX_ModuleDefinitions'. The duplicate key value is (OS_ItemListRazor).

I think the problem is that on 4.0.5 there a package with name "OS_ItemListRazor", but in latest version it seems to be renamed to "OS_ItemList" on the dnn file. This causes DNN to register a new package, create a new module definition ... and then the module defintion for "OS_ItemList" causes the conflict above.

I've fixed it by running this on the database before doing the upgrade:

`update Packages set name='OS_ItemList',FriendlyName='OS_ItemList' where name='OS_ItemListRazor'

update ModuleDefinitions set FriendlyName='OS_ItemList' where FriendlyName='OS_ItemListRazor'

update DesktopModules set FriendlyName='OS_ItemList', ModuleName='OS_ItemList' where FriendlyName='OS_ItemListRazor' `

vmasanas avatar May 11 '20 14:05 vmasanas

OK, tank you for reporting it Vincenc. I doubt it will be fixed and this will be the workaround.

leedavi avatar May 11 '20 14:05 leedavi