Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Dropping properties from Catalog Entries gives error
<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
<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
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)