Saturday, February 2, 2008

How to cheat the Prescan ? or just call it a Workaround...

A few days ago, after installing sp1 on my moss server, I saw that I can't run an upgrade for database that didn't pass the prescan without any errors.

I had this small database that I wanted to upgrade but god knows what a weird error I got on a certain website, that didn't have any special customization or any unusual data.

So I just wanted to get over with it, and move on.
I checked what is the difference between the sites that did pass the prescan, and dthen decided to do a small change in my content database...

Be aware, this tweak is NOT supported. But it does work.

So what you need to do ?

Change the 'bitflags' column in the 'sites' table in the content database so that its marked for a successful prescan.

If the prescan hasn't been running then value is 0 and after successful prescan the value changes to 262144.