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

AI OnAI Off

Dropping properties from Catalog Entries gives error

Arve Systad
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
Quan Mai
Vote:
 
<p>Hi,</p> <p>Thank you for bringing this to our attention. This should have been covered by our tests - I'll notify our QA about this.</p> <p>Regards,</p> <p>.Q</p>
#111719
Oct 19, 2014 20:01
Quan Mai
Quan Mai
Vote:
 
<div class="yj-message-list-item--body yj-message-body"><span data-qaid="message-text">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.</span> <p>Regards.</p> <p>/Q</p> </div>
#111733
Oct 20, 2014 11:40
* 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.