Smart search index returns error

stark g asked on March 25, 2019 18:31

Hi Team, I tried to update my page type using this query UPDATE [dbo].[CMS_Class] SET [ClassTableName] = 'newtablename' WHERE [ClassTableName] = 'oldtablename'; GO But my search index is still trying to run using the old table name how to change that, do i need to implicitly change any query for search index.

Recent Answers

Brenden Kehren answered on March 25, 2019 19:13

The problem is there are other columns of data which have the table name in it. Your best bet is to go to the custom class and modify the table name from there. If you can't then I suggest cloning it and modifying the table name when you clone it.

If you must modify the SQL directly, which not recommeneded at all because of the issues you're already seeing, you must not only modify the ClassTableName property of the CMS_Class table but you must also modify the ClassXmlSchema property of the CMS_Class table.

After you do that, restart the site in IIS (recycle the app pool) and try to make a minor change to a field on your custom class. If it saves, you should be set, try to rebuild your index. If not, I'd suggest reverting your datbase changes and cloning the object instead.

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.