OpenStore
OpenStore copied to clipboard
Error upgrading from version 4.0.5
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' `
OK, tank you for reporting it Vincenc. I doubt it will be fixed and this will be the workaround.