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)
