November Happy Hour will be moved to Thursday December 5th.

Comments and Ratings in Commerce 8.0

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
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
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.