ContentManager.GetList(ContentCriteria) -SQL Exception Invalid column name 'nav_name'."

  • Updated

SQL Exception Invalid column name 'nav_name'." is an error in the API for ContentManager.GetList

It occurs commonly if customers use the ContentTypeManager  GetList(ContentCollectionCriteria criteria)

public List<ContentType<T>> GetList(ContentCriteria criteria)
{
        Initialize();
        List<ContentData> contentList = _contentManager.GetList(criteria);
        return MakeList(contentList);
}


When that is called with a ContentCollectionCriteria instead of ContentCriteria, it produces the error.

To work around the issue add another declaration to ContentTypes.cs which explicitly sets the type of the criteria.

public List<ContentType<T>> GetList(ContentCollectionCriteria criteria)
{
      Initialize();
      List<ContentData> contentList = _contentManager.GetList(criteria);
     return MakeList(contentList);
}

This is a known issues. It will corrected in a the update release 9.2.