Morning Quicky: Cant Change Page Settings
So a user of mine tried to edit a page in our massive collection of sites that document software applications and their use. When they went to (in editing mode) Page -> Page setting they got the following in their face:
My predecessor had a search problem after he migrated users over to the MOSS 2007 server. A few users had the same GUID as each other, even tho they are suppose to be unique. So his solution was to delete the offending user out of the database manually... And that is how i got my problem. Parts of the sharepoint sites pull from the tp_ID feild and reference that. Others reference tp_GUID. This page uses tp_ID to pull the information it needs to generate the settings page.
My hack-solution:
This is unsupported by microsoft, note that i only did this as a temporay measure.
I created, manually, a fake user in the database that used the same tp_ID as the one he deleted a while ago.. yes i had to do some annoying sql to get it to allow me to insert. But it did fix the problem, lets see what other problems my "fix" brings up.
The Proper solution V1:
The idea here is to rebuild the SID for all of the users on the site, but in order to do this you have to remove all of the currently-setup security levels and access for all users on the website. The most straight forward method to do this is to import your website and export it:
Error returned: User Not FoundSource of problem:
My predecessor had a search problem after he migrated users over to the MOSS 2007 server. A few users had the same GUID as each other, even tho they are suppose to be unique. So his solution was to delete the offending user out of the database manually... And that is how i got my problem. Parts of the sharepoint sites pull from the tp_ID feild and reference that. Others reference tp_GUID. This page uses tp_ID to pull the information it needs to generate the settings page.
My hack-solution:
This is unsupported by microsoft, note that i only did this as a temporay measure.
I created, manually, a fake user in the database that used the same tp_ID as the one he deleted a while ago.. yes i had to do some annoying sql to get it to allow me to insert. But it did fix the problem, lets see what other problems my "fix" brings up.
The Proper solution V1:
The idea here is to rebuild the SID for all of the users on the site, but in order to do this you have to remove all of the currently-setup security levels and access for all users on the website. The most straight forward method to do this is to import your website and export it:
- stsadm -o export -url
-filename -versions 2 - Delete the site collection.
- stsadm -o import -url
-filename -updateversions 2 -nofilecompression
Comments