Umbraco and Ghost/Cached/Deleted pages appearing in menu

I'm currently investigating a new Open Source ASP.Net CMS system called Umbraco. It looks very promising as it can be fully accessible and has full support for XHTML among many other interesting features. I met with a couple of the guys that are developing the system in Manchester a couple of weeks ago and they've got big plans so keep an eye on it.

Anyway yesterday while setting up the new The Site Doctor site on Umbraco I ran into an issue where by I had "broken" the menu. Basically I had deleted the template from the system which should have deleted all copies of the pages that use that template but instead a cache remained somewhere. I ran through a number of steps to re-create the cache but nothing worked.

If you run into the same issue as I did, follow these steps:

1. Find out the ID of the page in question (easiest way is just to add the ID to the output of the menu XSLT)
2. Search the database for the ID using the T-SQL I posted in "How to search every table and field in a SQL Server Database"
3. Download and install a Unicode and UTF-8 search program such as Text Workbench and search for the ID (I only found it in /data/Umbraco.config)
4. Reset the applications cache -the easiest way to do this is to simply re-upload the web.config file

That should sort it :)