Custom Content Type Loses its Mind

Been working on a MOSS project that makes extensive use of InfoPath 2003 (gag) forms. One of the tricks with these if that you can publish the 03 forms as custom content types if you do so from InfoPath 2007. We used this "trick" to publish a couple forms and it worked well. Now I'm coming back in to do some modifications, and the fun begins.

While attempted to create a new site in the SharePoint hierarchy, the following error message occurred: "a duplicate name "BusinessCase" was found" and the site creation would fail. It turned out that when I had last updated the custom content type, I had assigned it a site column that conflicted with another site column. The "BusinessCase" column had been redeployed as a type "Multiple lines of text" from "Single line of text" and when I deployed the new content type, the two columns conflicted with each other on the form library.

The fix for this was to republish the content type while only selecting the "BusinessCase" column with the "Multiple lines of text" type, and then removing the site column for the "BusinessCase" with the "Single line of text" type. And the moral to the story is to really watch those site columns when you publish multiple times.