Hi, I'm Brian. I'm a Danish guy primarily working with ASP.NET e-commerce solutions using Microsoft Commerce Server. I'm co-founder and core-member of Aarhus .NET Usergroup (ANUG), which is a offline community for .NET developers in Denmark. You can visit my or follow me on Twitter @brianh_dk. Also please feel free to contact me via e-mail .
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
E-mail
Sign In
The other day I wrote a blog post about a search problem in the Commerce Server Starter Site. I had added a new property to the propertiesToReturn element of web.config and that caused all search operations on the web-site to fail with the following exception from the database: 'Invalid column name 'Show_Variants_As_Products'.
In my efforts to solve the problem I stumbled across another issue when I tried to execute the "Refresh Catalog FullText Index" command on one of my catalogs in the Catalog Manager (screenshot provided).
This command executed without errors but when I tried to perform a new search on the web-site the database threw another exception with the following error message:
Full-text table or indexed view has more than one LCID among its full-text indexed columns.
This post helped me to the solution.
The solution
In SQL Server Management Studio I opened the Product Catalog database and found the table holding the products for the specific catalog I initially performed the Refresh command on. I changed the "Language for Word Breaker" setting for the CategoryName column from 'English' back to 'Neutral' in the properties Full Text Indexing (screenshot provided below).
dbo.[catalogname]_CatalogProducts > Full Text index > Properties > Columns > CategoryName=Neutral (from English)