Server Error in '/' Application.

Column 'YEAR' in where clause is ambiguous

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: MySql.Data.MySqlClient.MySqlException: Column 'YEAR' in where clause is ambiguous

Source Error:


Line 30:             cmd2.SelectCommand.CommandTimeout = 360;
Line 31:                  
Line 32:             cmd2.Fill(testDataSet);
Line 33:             DataView source = new DataView(testDataSet.Tables[0]);
Line 34:             MyConn.Close();

Source File: g:\pleskvhosts\thefantasyadvisors.com\httpdocs\App_Code\Library.cs    Line: 32

Stack Trace:


[MySqlException (0x80004005): Column 'YEAR' in where clause is ambiguous]
   MySql.Data.MySqlClient.MySqlStream.OpenPacket() +239
   MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +62
   MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +48
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +524
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +815
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   TFA.LB.GetSource(String sqltext) in g:\pleskvhosts\thefantasyadvisors.com\httpdocs\App_Code\Library.cs:32
   vip_Players_RZRushing.FillGrid() in g:\pleskvhosts\thefantasyadvisors.com\httpdocs\vip\Players\RZRushing.aspx.cs:35
   vip_Players_RZRushing.Page_Load(Object sender, EventArgs e) in g:\pleskvhosts\thefantasyadvisors.com\httpdocs\vip\Players\RZRushing.aspx.cs:25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0