Fix “One or more field types are not installed properly. Go to the list settings page to delete these fields.” Error in SharePoint CAML Query

Problem: I got this error when retrieving list items using CAML SPQuery. Root Cause: There was a field “Artifact ID” in the list, but the internal name was “Artifact”, resulting in an error! Correcting the internal name in the Query XML fixed the problem. In another case, I got this error:“The following…

Read more

Run STSADM from anywhere by changing “Path” Environment Variable

Getting “‘stsadm’ is not recognized as an internal or external command, operable program or batch file.” when trying to run the stsadm command-line tool? This is because the stsadm tool is located at: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN folder, and when you try to access it from other folders (typically, command…

Read more

Hide Title Column in SharePoint List

Often, SharePoint users want to remove (or hide at least) the ‘Title’ column from the lists and document libraries. We can hide the title column in SharePoint 2007 by enabling content types. How to hide the title column in a SharePoint list? Follow these steps to hide the title column in SharePoint…

Read more

Move SharePoint Search Index Files Location to Another Drive

Again, C:\ is running out of disk space in a SharePoint Farm because search index files are growing! Huh… So, this time, I decided to move SharePoint 2007 index files from C:\Program Files\Microsoft Office Servers\12.0\Data\Office Server\Applications to E:\. Here are the steps to move the SharePoint search index to another drive: It’s a…

Read more

Server error: https://go.microsoft.com/fwlink?LinkID=96177

SharePoint Central Administration displayed just “Server error: https://go.microsoft.com/fwlink?LinkID=96177” error message on a SharePoint Farm. After little research, Found Hotfixes are installed, but the Products and Technologies wizard has not run! After running “SharePoint Products and Technologies Configuration Wizard” everything turned up. In case psconfig fails, try: stsadm -o upgrade -inplace -url -forceupgrade If…

Read more

Web Part Maintenance Page in SharePoint

Once, I ran across the issue where a web part is dropped onto a page, and then SharePoint errors out for one reason or the other. I had to use the Web Part Maintenance Page to fix the problem. However, there is no way to get to this page from any easily…

Read more

SharePoint 2003 to SharePoint 2007 Migration using Database Attach Method: Step by Step

In this article, I’ll be walking through the complete step-by-step procedures on migrating from SharePoint 2003 to MOSS 2007 using the database attach method. Overview How to migrate SharePoint 2003 to SharePoint 2007? Migrating from SPS2003 to SharePoint 2007 on the Database attachment method involves four tasks below. Run PreScan.exe in SPS…

Read more

How to Adjust Column Width in SharePoint List View?

Requirement: Adjust SharePoint column width in list view. To change column width in SharePoint, There are two options: Set column width using SharePoint Designer Change SharePoint column width using jQuery, as below: To set width of column in SharePoint 2007, place the below code in CEWP, place it below list view web…

Read more