Exception while double clicking a group note. v 17.1.13.0

For users or potential users.
Post Reply
ForrestGumpDDS
Posts: 177
Joined: Fri Oct 14, 2011 3:31 pm

Exception while double clicking a group note. v 17.1.13.0

Post by ForrestGumpDDS » Tue May 16, 2017 7:01 pm

Just noticed. Could be the issue related th capital/lower case in the code due to the fact I run mysql on Linux.
I'm not seeing any bad things, just the dialogue window. Clicking "Continue", pasting the text in there, e-signing, OK - all works.

Code: Select all

MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') WHERE GroupNum = 46731' at line 1
   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__DisplayClass76_0.<GetTable>b__1()
   at OpenDentBusiness.DataConnection.RunDbAction(Action actionDb, DbConnection connection)
   at OpenDentBusiness.DataConnection.GetTable(String command, Boolean hasConnLost)
   at OpenDentBusiness.DataCore.GetTable(String command)
   at OpenDentBusiness.Db.GetCount(String command)
   at OpenDentBusiness.ProcGroupItems.GetCountCompletedProcsForGroup(Int64 groupNum)
   at OpenDental.FormProcGroup.FormProcGroup_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.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)

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Exception while double clicking a group note. v 17.1.13.

Post by cmcgehee » Wed May 17, 2017 8:02 am

According to our bug tracker (http://opendentalsoft.com:1942/ODBugTra ... sions.aspx), we just fixed an unhandled exception with group notes in 17.1.14.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: Exception while double clicking a group note. v 17.1.13.

Post by dgraffeo » Wed May 17, 2017 8:25 am

Yep, the issue you are having is related to what was fixed.
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

ForrestGumpDDS
Posts: 177
Joined: Fri Oct 14, 2011 3:31 pm

Re: Exception while double clicking a group note. v 17.1.13.

Post by ForrestGumpDDS » Wed May 17, 2017 1:37 pm

Thanks.
I am planning to upgrade it end of this week.

Post Reply