since I can't start the website I guess I can't use admin console
or is there possibility to use some special url and go to admin console directly without that error occuring?

unless you mean I have to clone the curren live site at other machine and then log in there, strip personalization info from admin console, then upgrade site and db. Sounds long way if there is a way I can edit the db by hand.

* do you have some script I can run at sql server to remove personalization data or is thete some stored procedure that does it?

thanx in advance

Yes you can do it by hand, you can just delete the ASP.NET membership personalization table data - aspnet_PersonalizationPerUser, aspnet_PersonalizationAllUsers this will remove everything from personalization. If you don't want to do that you can find the path of your page in the aspnet_Paths table and then delete personalization for only that path.

Let me know if you need anything else.

I guess you mean to clean that table, not delete it, right?

Yup, "you can just delete the ASP.NET membership personalization table data " :)

Thanks, emptied the all users personalization table and it seems to work now

not sure what the problem was though, since I couldn't visit any page of the site, even a new one (Home.aspx) that we had created by hand after the database snapshot (so it couldn't be trying to apply personalization data on it).

I looked for the pathid of default.aspx in the personalization data, but with a quick look couldn't find it (also there were 57 entries in there and not sure why they were needed, probably were left overs from monox demo site for pages that had been removed or something)

Mixing MonoX demo pages and your custom pages can induce this kind of behavior because MonoX has saved demo page zone and data and you are trying to load your own data. This happens especially when you remove or add new zones and existing data expect old zone to be present.

I'm glad that you fixed the problem and that your site is back online.

Regards

since I've just needed this again, mentioning here the SQL script used to clear those tables for other users' convenience:

DELETE FROM aspnet_PersonalizationAllUsers

DELETE FROM aspnet_PersonalizationPerUser

(info on DELETE SQL command at http://www.w3schools.com/sql/sql_delete.asp)

obviously have to execute this on MonoX2 database