Developer forum

Forum » CMS - Standard features » ProductFieldTranslationErrorMessage v9.15.8

ProductFieldTranslationErrorMessage v9.15.8

Kevin O'Driscoll
Reply

Anyone know why we get an error like this?

[IndexOutOfRangeException: ProductFieldTranslationErrorMessage]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2158699
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +141
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +21
   Dynamicweb.Ecommerce.Products.ProductFieldTranslation.Fill(IDataReader reader) +430
   Dynamicweb.Ecommerce.Products.ProductFieldTranslation.GetProductListBySql(String query) +213
   Dynamicweb.Ecommerce.Products.ProductFieldTranslation.GetAllTranslations() +143
   Dynamicweb.Ecommerce.Products.ProductFieldDependencies.GetCachedProductFields() +702
   Dynamicweb.Ecommerce.Products.ProductField.GetProductFields(Boolean excludeStandartFields) +135
   Dynamicweb.Admin.eComBackend.EcomField_List.FillList() +378
   Dynamicweb.Admin.eComBackend.EcomField_List.Page_PreRender(Object sender, EventArgs e) +18
   System.Web.UI.Control.OnPreRender(EventArgs e) +11727996
   System.Web.UI.Control.PreRenderRecursiveInternal() +132
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671

Symptoms are : Go to any product on the frontend.

Go to Settings > Ecommerce > Product Catalog >  Product fields

Go to Repositories > All Indexes

Go to Repositories > Any Ecommerce Index there are no instances of  Instances / Builds / Fields Etc and If I add new instance it just wont save. All other indexes (Non Ecom) work fine.

Ive tried restoring a good database, re-installing a known working index file system, reinstalling licence. re-installing all v9.15.8 DLLs and Admin folder.

Re-Installing a complete new DW installation with no custom code and no third party .dlls

Any Ideas?

Rgds

Kev


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply
This post has been marked as an answer

Looks like a missing column in the database.

Go to system settings and re-run the updates from i.e. 2000

Votes for this answer: 1
 
Kevin O'Driscoll
Reply

Sorry false alarm.... It was a data issue

Sorted now

 
Kevin O'Driscoll
Reply

Thanks Nicolai, Just saw your reply, Ill mark it as answer

 

You must be logged in to post in the forum