Error continue or quit

For users or potential users.
Post Reply
alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Error continue or quit

Post by alhalwachi » Thu Sep 15, 2011 12:36 pm

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

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Error continue or quit

Post by jordansparks » Thu Sep 15, 2011 3:35 pm

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.
Jordan Sparks, DMD
http://www.opendental.com

alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Re: Error continue or quit

Post by alhalwachi » Sat Sep 17, 2011 10:01 am

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

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Error continue or quit

Post by jordansparks » Sat Sep 17, 2011 7:05 pm

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.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply