Open Dental Forum

Hi everyone

I'm facing an annoying error, looks as if it's to do with the database. The system asks me to either quit or continue! The system will work if I stop and start mySQL service but the error keeps showing again!

I am on version 7.9, MySQL v5.0,so plzzz help!

the content of the error is as follows:

rameter[] parameters) in D:\TEMP_khcb\OD\Version 7.9_20100519\OpenDentBusiness\Db\Db.cs:line 62
  at OpenDentBusiness.Ledgers.ComputeAging(Int64 guarantor, DateTime AsOfDate, Boolean historic) in D:\TEMP_khcb\OD\Version 7.9_20100519\OpenDentBusiness\Db Multi Table\Ledgers.cs:line 354
  at OpenDentBusiness.AccountModules.GetAccount(Int64 patNum, DateTime fromDate, DateTime toDate, Boolean intermingled, Boolean singlePatient, Int64 statementNum, Boolean showProcBreakdown, Boolean showNotes) in D:\TEMP_khcb\OD\Version 7.9_20100519\OpenDentBusiness\Db Multi Table\AccountModules.cs:line 460
  at OpenDentBusiness.AccountModules.GetAll(Int64 patNum, Boolean viewingInRecall, DateTime fromDate, DateTime toDate, Boolean intermingled, Boolean showProcBreakdown, Boolean showNotes) in D:\TEMP_khcb\OD\Version 7.9_20100519\OpenDentBusiness\Db Multi Table\AccountModules.cs:line 41
  at OpenDental.ContrAccount.RefreshModuleData(Int64 patNum, Boolean isSelectingFamily) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\ContrAccount.cs:line 1860
  at OpenDental.ContrAccount.ModuleSelected(Int64 patNum, Boolean isSelectingFamily) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\ContrAccount.cs:line 1785
  at OpenDental.ContrAccount.ModuleSelected(Int64 patNum) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\ContrAccount.cs:line 1780
  at OpenDental.FormOpenDental.SetModuleSelected() in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\FormOpenDental.cs:line 2993
  at OpenDental.FormOpenDental.myOutlookBar_ButtonClicked(Object sender, ButtonClicked_EventArgs e) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\FormOpenDental.cs:line 2963
  at OpenDental.OutlookBar.OnButtonClicked(OutlookButton myButton, Boolean myCancel) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\User Controls\OutlookBar.cs:line 321
  at OpenDental.OutlookBar.OnMouseUp(MouseEventArgs e) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\User Controls\OutlookBar.cs:line 313
  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)
 
 
************** Loaded Assemblies **************
mscorlib
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5446 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
IDMS
   Assembly Version: 7.9.8.0
   Win32 Version: 7.9.8.0
   CodeBase: file:///C:/Program%20Files/Open%20Dental/IDMS.exe

Looks like the very first part of the error was omitted. That first line is critical. Also, if you are on MySQL v5.0, are you getting the reminders to upgrade? What's stopping you? We probably won't bother to investigate until you do that update.

Hi

Thanks for your reply. I have upgraded mySQL to 5.5 however the error keeps coming up. I used the "Tools>Database Maintainance" munu to check the DB and no issues were detected.

The contents of error is as follows:

System.NullReferenceException: Object reference not set to an instance of an object.
  at OpenDental.ContrAppt.ContrApptSheet2_MouseDown(Object sender, MouseEventArgs e) in K:\TEMP_khcb\OD\Versions\Version 7.9_20100519_Dr_Rashad\OpenDental\Main Modules\ContrAppt.cs:line 2659
  at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.UserControl.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
  at System.Windows.Forms.ContainerControl.WndProc(Message& m)
  at System.Windows.Forms.UserControl.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)
 
 
************** Loaded Assemblies **************
mscorlib
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5446 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
IDMS
   Assembly Version: 7.9.8.0
   Win32 Version: 7.9.8.0
   CodeBase: file:///C:/Program%20Files/Open%20Dental/IDMS.exe

But you're only on 7.9.8. As it clearly shows on the bug tracking page:
http://opendentalsoft.com:1942/ODBugTra ... sions.aspx
that was a beta version. It should have been updated months ago. Upgrade to 7.9.28.