Dropping properties from Catalog Entries gives error

Arve Systad

Vote:

Trying to disable a few columns from a catalog entry, but I'm only getting an error saying Cannot alter or drop column 'ColumnName' because it is enabled for Full-Text Search.

This Exception should be picked up, and if it's there, you should drop the Full text index (like below), and then drop the column. If I'm really after deleting the column, I don't care wheather it's indexed in any way or not.

ALTER FULLTEXT INDEX ON CatalogEntryEx_MyClass DISABLE
ALTER FULLTEXT INDEX ON CatalogEntryEx_MyClass DROP (MyColumn)
ALTER FULLTEXT INDEX ON CatalogEntryEx_MyClass_Localization DISABLE
ALTER FULLTEXT INDEX ON CatalogEntryEx_MyClass_Localization DROP (MyColumn)

#111676

Oct 17, 2014 12:52

Quan Mai

Vote:

Hi, Thank you for bringing this to our attention. This should have been covered by our tests - I'll notify our QA about this. Regards, .Q

#111719

Oct 19, 2014 20:01

Quan Mai

Vote:

<div class="yj-message-list-item--body yj-message-body">There should be a file named PrepareForSqlAzure.sql in packages\EPiServer.Commerce.Azure\epiupdates_commerce\sql\manual, which should be run manually in context of Commerce database. Please try it to see if it fixes the problem for you. Regards. /Q </div>

#111733

Oct 20, 2014 11:40

Try our conversational search powered by Generative AI!

Dropping properties from Catalog Entries gives error