WebEventCriteria GetList returns Invalid Column Name Error

  • Updated

Using the following sample will throw the error:

Server Error in '<site>' Application. Invalid column name 'Description'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'Description'.

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using Ektron.Cms.Framework.Calendar; 
using Ektron.Cms.Common;
public partial class Test1 : System.Web.UI.Page
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
string value = "cafe";

var webeventManager = new WebEventManager(); 
WebEventCriteria criteria = new WebEventCriteria(); 

criteria.AddFilter(EventProperty.Description , CriteriaFilterOperator.Contains,value); 

var WebEventDataList = webeventManager.GetList(criteria);

Response.Write("Number of Results = "+WebEventDataList.Count); 
} 
}

This was a known issue and a script fix can be downloaded here.  Please make a backup of the database before applying a fix.