Comments and Ratings in Commerce 8.0

Viktar Slapik

Vote:

As we know from post there is a way to renew comments and rating functionality in Commerce 8.0.

Actually we have an issue with old comments and ratings in EpiServer CMS 7.18 & Commerce 8.3.
All files from "CommentsAndRatings.zip" were included in our site, required strings were added in initialization module.
The comments and ratings functionality works fine for new posted product comments and ratings, but old product comments and ratings disappeared.
Is there any way to solve the issue?
Thank you in advance.

#115679

Jan 16, 2015 8:24

Viktar Slapik

Vote:

Solution was found, after you add files in your project, just run this simple script with small changes from your side, because the files are already located in the new assembly:

UPDATE [dbo].[tblEntityType]
SET [strName] = 'EPiServer.Business.Commerce.DynamicEntities.ProductEntity, [MySiteAssembly]'
WHERE [dbo].[tblEntityType].[strName] = 'EPiServer.Business.Commerce.DynamicEntities.ProductEntity, EPiServer.Business.Commerce'
GO

UPDATE [dbo].[tblBigTable]
SET [ItemType] = 'EPiServer.Business.Commerce.DynamicEntities.ProductEntity, [MySiteAssembly], [Version=[], Culture=[], PublicKeyToken=[]]'
WHERE [dbo].[tblBigTable].[StoreName] = 'EPiServer.Business.Commerce.DynamicEntities.ProductEntity'

Old values was next:

EPiServer.Business.Commerce.DynamicEntities.ProductEntity, EPiServer.Business.Commerce
EPiServer.Business.Commerce.DynamicEntities.ProductEntity, EPiServer.Business.Commerce, Version=7.6.1.36, Culture=neutral, PublicKeyToken=8fe83dea738b45b7

#116060

Jan 22, 2015 12:45