I have a Umbraco 4.7.2 database handed over to me as a .bak file. But it has been stripped off all the users. I have managed to get the admin user (using forced identity insert) and my login into the database using SQL scripts. I am also setting the nodeuser=0 in the umbracoNode table. However I have seen that the cmsDocument table also contains references to all the deleted users and because of this some of the pages in Umbraco throw up errors on publish.
1) Is updating the cmsdocument table with userid=0 a good way to go about this issue
2) Seeing that there has been much messing around with the database is there anyway to guarantee that the integrity of the database is still intact?
Umbraco 4.7.2 database without any users
Hi ,
I have a Umbraco 4.7.2 database handed over to me as a .bak file. But it has been stripped off all the users. I have managed to get the admin user (using forced identity insert) and my login into the database using SQL scripts. I am also setting the nodeuser=0 in the umbracoNode table. However I have seen that the cmsDocument table also contains references to all the deleted users and because of this some of the pages in Umbraco throw up errors on publish.
1) Is updating the cmsdocument table with userid=0 a good way to go about this issue
2) Seeing that there has been much messing around with the database is there anyway to guarantee that the integrity of the database is still intact?
Any help is much appreciated
Poornima
is working on a reply...