Search Feature Broken Migrating To Community Server (CS) 2.1

I just realized today that the Searching Feature on this site was broken while migrating from CS 2.0 to CS 2.1.  

According to Jayson Knight's post, this happens when you upgrade from ASP.NET 1.1 to ASP.NET 2.0 because of the differences in the implementation of the GetHashCode Algorithm between ASP.NET 1.1 and 2.0

As far as I know, this site was running under ASP.NET 2.0 even in CS 2.0.  According to Jayson, the fix is to truncate the cs_searchBarrel table and update all of your IsIndexed column values in cs_Posts to 0

I will try it now and see if it works.  

Thanks Jason for the tip

Notes:

These are the SQL Statements I ran:

TRUNCATE TABLE CS_SEARCHBARREL
GO

UPDATE CS_POSTS SET ISINDEXED = 0

SELECT COUNT(*) FROM CS_POSTS WHERE ISINDEXED = 1
GO