“The formula contains a syntax error or is not supported” when creating a site from your custom site definition

If you get this message, it is related to one or more custom calculated fields in custom content type that you are binding to, say Page library.

<ContentTypeBinding ContentTypeId=0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF3900934580F187BC9D41A93CD80922ACB14D0020A6F4BF761A71479762484F9359D4CBListUrl=Pages/>

Check your field schema, it may be broken. Unfortunately, ULS logs will not give you details what field is broken, only this stacktrace

System.Runtime.InteropServices.COMException: The formula contains a syntax error or is not supported.    at Microsoft.SharePoint.Library.SPRequestInternalClass.UpdateField(String bstrUrl, String bstrListName, String bstrXML)     at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)     — End of inner exception stack trace —     at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)     at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)    

Leave a Reply