Debugging mySQL Error

For complex topics that regular users would not be interested in. For power users and database administrators.

Debugging mySQL Error

Postby drtech » Mon Mar 18, 2019 2:43 pm

I am trying to figure out what this error is from. As the previous post, I setup a new lxc container running ubuntu 18.04 and mysql 5.7.25 instead of my longtime VM server running ubuntu 14.04 and mysql 5.5.62. Now I am getting this error: Any ideas how to help with this? Do I need to change sql_mode-only_full_group_by to something else? OD 18.2.18

Unhandled exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opendental.plannedappt.ItemOrder' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySql.Data.MySqlClient.MySqlException
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at OpenDentBusiness.DataConnection.<>c__DisplayClass86_0.<GetTable>b__0() in C:\SVN\beta\OpenDentBusiness\Db\DataConnection.cs:line 564
at OpenDentBusiness.DataConnection.RunDbAction(Action actionDb, DbConnection connection) in C:\SVN\beta\OpenDentBusiness\Db\DataConnection.cs:line 782
at OpenDentBusiness.DataConnection.GetTable(String command, Boolean hasConnLost) in C:\SVN\beta\OpenDentBusiness\Db\DataConnection.cs:line 564
at OpenDentBusiness.ChartModules.GetPlannedApt(Int64 patNum) in C:\SVN\beta\OpenDentBusiness\Db Multi Table\ChartModules.cs:line 1520
at OpenDentBusiness.ChartModules.<>c__DisplayClass2_0.<GetAll>b__1() in C:\SVN\beta\OpenDentBusiness\Db Multi Table\ChartModules.cs:line 158
at CodeBase.Logger.LogAction(String log, LogPath path, Action act, String optionalDesc) in C:\SVN\beta\CodeBase\Utilities\Logger.cs:line 219
at OpenDentBusiness.ChartModules.GetAll(Int64 patNum, Boolean isAuditMode, ChartModuleComponentsToLoad componentsToLoad, Boolean doMakeSecLog) in C:\SVN\beta\OpenDentBusiness\Db Multi Table\ChartModules.cs:line 158
at OpenDental.ContrChart.<>c__DisplayClass308_0.<RefreshModuleData>b__0() in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3758
at CodeBase.Logger.LogAction(String log, LogPath path, Action act, String optionalDesc) in C:\SVN\beta\CodeBase\Utilities\Logger.cs:line 219
at OpenDental.ContrChart.RefreshModuleData(Int64 patNum, Boolean isFullRefresh) in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3758
at OpenDental.ContrChart.<>c__DisplayClass305_0.<ModuleSelected>b__0() in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3684
at CodeBase.Logger.LogAction(String log, LogPath path, Action act, String optionalDesc) in C:\SVN\beta\CodeBase\Utilities\Logger.cs:line 219
at OpenDental.ContrChart.ModuleSelected(Int64 patNum, Boolean isFullRefresh, Boolean isClinicRefresh) in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3684
at OpenDental.ContrChart.ModuleSelected(Int64 patNum, Boolean isClinicRefresh) in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3678
at OpenDental.ContrChart.ModuleSelectedErx(Int64 patNum) in C:\SVN\beta\OpenDental\Main Modules\ContrChart.cs:line 3653
at OpenDental.FormOpenDental.SetModuleSelected(Boolean menuBarClicked) in C:\SVN\beta\OpenDental\Main Modules\FormOpenDental.cs:line 5994
at OpenDental.FormOpenDental.myOutlookBar_ButtonClicked(Object sender, ButtonClicked_EventArgs e) in C:\SVN\beta\OpenDental\Main Modules\FormOpenDental.cs:line 5915
at OpenDental.OutlookBar.OnButtonClicked(OutlookButton myButton, Boolean myCancel) in C:\SVN\beta\OpenDental\User Controls\OutlookBar.cs:line 325
at OpenDental.OutlookBar.OnMouseUp(MouseEventArgs e) in C:\SVN\beta\OpenDental\User Controls\OutlookBar.cs:line 317
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
User avatar
drtech
 
Posts: 1601
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO

Re: Debugging mySQL Error

Postby jsalmon » Mon Mar 18, 2019 2:55 pm

Modify the sql_mode parameter to either a blank string or NO_AUTO_CREATE_USER.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm


Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 3 guests