Error Message: System.Data.SqlClient.SqlException Invalid column name

  • Updated

One may experience issues receiving errors similar to the one below in the Event Viewer or while navigating around the CMS. These errors can also occur when using the Ektron APIs.

 Message: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Name'

Typically the cause of the error message is that the CMS site root files do not match the version of the Ektron database.

Here are steps to avoid this behavior

  • When running the SiteSetup Utility to apply a Service Pack or CU on an Ektron site, make sure that the installer runs on the database as well.
  • When creating a new site based off of an existing site (i.e. copying production site to make a development site), if using a copy of the database, verify that the database version matches the CMS site file version.
  • If an Ektron Technical Support Engineer makes a request to replace the Workarea and Bin Folder for troubleshooting purposes, make sure to reapply the CU (as stated in the KB article) after replacing those files.

 

For more information on how to check for the CMS and database version click here.