Server Error in '/' Application.

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zmagazine_cestwin.opinion.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zmagazine_cestwin.opinion.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Source Error:


Line 255:        Dim ad As New MySqlDataAdapter(strSQL, conexaoMySQL)
Line 256:        Dim ds As New DataSet()
Line 257:        ad.Fill(ds)
Line 258:        Return ds
Line 259:

Source File: C:\Inetpub\vhosts\zbynetmagazine.com\httpdocs\opinion.aspx.vb    Line: 257

Stack Trace:


[MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zmagazine_cestwin.opinion.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
   MySql.Data.MySqlClient.MySqlStream.OpenPacket() +280
   MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +59
   MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +62
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1008
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1658
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +9
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +19
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +221
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +573
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +166
   opinion.GetData() in C:\Inetpub\vhosts\zbynetmagazine.com\httpdocs\opinion.aspx.vb:257
   opinion.Calendar1_DayRender(Object sender, DayRenderEventArgs e) in C:\Inetpub\vhosts\zbynetmagazine.com\httpdocs\opinion.aspx.vb:263
   System.Web.UI.WebControls.Calendar.OnDayRender(TableCell cell, CalendarDay day) +406
   System.Web.UI.WebControls.Calendar.RenderDays(HtmlTextWriter writer, DateTime firstDay, DateTime visibleDate, CalendarSelectionMode selectionMode, Boolean buttonsActive, Boolean useAccessibleHeader) +2890
   System.Web.UI.WebControls.Calendar.Render(HtmlTextWriter writer) +1827
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +240
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +253
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +87
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +53
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +240
   System.Web.UI.Page.Render(HtmlTextWriter writer) +38
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240


Version Information: Microsoft .NET Framework Version:2.0.50727.8974; ASP.NET Version:2.0.50727.8975