change sub-site to a new sub-site URL and wanted the old link auto redirect to the new link.

1. Go to old URL link and open in SPD
2. Create an .aspx page
3. Paste the coding in .aspx page(target site URL)
•  <meta http-equiv="refresh" content="0;url=http://xxxxx/sites/xxxxxxxxxx/yyyyyy">
4. Right click .aspx page > click Set as Home Page
5. Rename the .aspx page to default.apsx

Search log where to see ?

 

problem with the search no results under some subsites , when can check the crawl log or error ?

 

 

1. crawl log under SSP
2. enable ULS for wss query with veberos, then can see the log at ULS log
3. go to search database to run the query on terfert sites , see have crawl or not :
• select * from MSSCrawlURL (nolock)
  where DisplayURL like '%/sites/XXXXX%'

but the problem not yet resolved…to be continue… ha ha

Who Deleted my SharePoint Top Level Sites!!!!

have customer want to know who deleted his top level sites ( aka site collection ).

 

the easy answer is the one site collection admin or the user have full control permission at your site collection!!

 

But let say have 100 site collection admin!!! ha ha..so which one is the one??

 

oh yeah easy to trace is go to the IIS log file then search it at the folder level:

 

A word or phrase in the file with

“/sites/<sites collection name>/_layouts/deleteweb.aspx ”.

 

yeah!!! shoot the one delete it!!! ha ha

-- Query to get all the SharePoint groups in a site collection

 

Another cool query from sharepointkings

 

Customer request the report on all the user in the group on the specify sites collection.

 

-- Query to get all the SharePoint groups in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
dbo.Groups.Title AS Expr2, dbo.Groups.Description
FROM dbo.Groups INNER JOIN
dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId

 

-- Query to get all the members of the SharePoint Groups
SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.GroupMembership INNER JOIN
dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID

 

 

after query the all the memeber of the group, use excel to remove the duplicate data then you will know how many user in the group :)

Unable to reorder content type

Have user copy the list template from another site and want to reorder the content type, when click on the column order at the content type you will see the error :

 

Object reference not set to an instance of an object.   at Microsoft.SharePoint.ApplicationPages.ChangeFieldOrderPage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

Work around:

you will not be able to manage the order of your columns on the list settings page again until you switch “Allow management of content types” back to No. When the management of content types if enabled, you can then reorder the columns for each specific content type. You may or may not want this to be your standard setup, so my best practice here would be to turn this feature back off when you are finished managing the content type.

 

Detail step:

 

1. change the list setting at Advanced settings and change the Allow management of content types to no. > click ok

2. under the column, you will see Column ordering. Click on the column ordering and change the order.> click ok when you done

3. change the list setting at Advanced settings and change the Allow management of content types to yes > click ok

 

guessing of the root cause:

 

i think because the content type is attach to the template and no content type created for the sites. once you click on ordering, then will go to search the content type gallery at site level. once cannot found it and error message will show at above. i guess is consider bug :)