Beta Errors

[drtech]

using V 7.7.6

Going to the main tab in our task list, causes the program to crash everytime.

When adding lots of procedures and or editing planned appts, I got some kind of my.sql error about being "out of memory in mysql" or something that I have never seen before and had to restart the program. Can't seem to duplicate it now, will report back tomorrow when I have the exact error message.

[jordansparks]

Well, keep in mind that your situation is not the same as everyone else's. You compiled it, you are running a plug-in, and we won't analyze your database for inconsistencies. So it's up to you to find out why your database is different and why it crashes on the main task list. Our database works fine in that area. Should be pretty easy to spot in debug, I would think.

[drtech]

i am not getting the my.sql error anymore after updating to the latest version and rebuilding.

I can't figure out the task list problem. When I run under debug mode, I don't get a debug error, the program just hangs as soon as I click on the "Main" tab in the task list. (windows wait circle) Any suggestions on where to look here? I can't get to my task lists since updating to 7.7!

Other lists work fine, so must be something messed up in a certain task list? how do I debug for database errors in the task list?

[drtech]

AHHGG... 2 minutes after saying I didn't have the mysql error It happened again! (This time, I was trying to print a saved and unprinted statement when the error occurred) I see a hook for my plugin is involved in this one, however when it occurred before, it was with planned appts and my plugin does nothing with planned appts)


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: Out of resources when opening file '/tmp/#sql44c_1fde_1.MYD' (Errcode: 24)
at OpenDentBusiness.DataConnection.NonQ(String commands, Boolean getInsertID, OdSqlParameter[] parameters) in C:\SVN\Beta\OpenDentBusiness\Db\DataConnection.cs:line 471
at OpenDentBusiness.DataCore.NonQ(String command, Boolean getInsertID, OdSqlParameter[] parameters) in C:\SVN\Beta\OpenDentBusiness\Db\DataCore.cs:line 34
at OpenDentBusiness.Db.NonQ(String command, Boolean getInsertID, OdSqlParameter[] parameters) in C:\SVN\Beta\OpenDentBusiness\Db\Db.cs:line 52
at OpenDentBusiness.Db.NonQ(String command, OdSqlParameter[] parameters) in C:\SVN\Beta\OpenDentBusiness\Db\Db.cs:line 62
at OpenDentBusiness.Ledgers.ComputeAging(Int64 guarantor, DateTime AsOfDate, Boolean historic) in C:\SVN\Beta\OpenDentBusiness\Db Multi Table\Ledgers.cs:line 354
at OpenDentBusiness.AccountModules.GetAccount(Int64 patNum, DateTime fromDate, DateTime toDate, Boolean intermingled, Boolean singlePatient, Boolean isForStatement, Boolean showProcBreakdown, Boolean showNotes) in C:\SVN\Beta\OpenDentBusiness\Db Multi Table\AccountModules.cs:line 472
at OpenDentBusiness.AccountModules.GetAll(Int64 patNum, Boolean viewingInRecall, DateTime fromDate, DateTime toDate, Boolean intermingled, Boolean showProcBreakdown, Boolean showNotes) in C:\SVN\Beta\OpenDentBusiness\Db Multi Table\AccountModules.cs:line 41
at PluginDrTECH.FormRpStatementP.CreateDocument(FormRpStatement sender, Document doc, PrintDocument pd, Family fam, Patient pat, DataSet dataSet, Statement Stmt)
at PluginDrTECH.Plugin.HookMethod(Object sender, String hookName, Object[] parameters)
at OpenDentBusiness.Plugins.HookMethod(Object sender, String hookName, Object[] parameters) in C:\SVN\Beta\OpenDentBusiness\Plugins\Plugins.cs:line 64
at OpenDental.FormRpStatement.CreateDocument(PrintDocument pd, Family fam, Patient pat, DataSet dataSet) in C:\SVN\Beta\OpenDental\Forms Reports\FormRpStatement.cs:line 365
at OpenDental.FormRpStatement.CreateStatementPdf(Statement stmt, Patient pat, Family fam, DataSet dataSet) in C:\SVN\Beta\OpenDental\Forms Reports\FormRpStatement.cs:line 279
at OpenDental.FormStatementOptions.butPrint_Click(Object sender, EventArgs e) in C:\SVN\Beta\OpenDental\Forms\FormStatementOptions.cs:line 826
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at OpenDental.UI.Button.OnClick(EventArgs ea) in C:\SVN\Beta\OpenDental\UI\Button.cs:line 153
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.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.4952 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 7.7.8.0
Win32 Version: 7.7.8.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDental.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Assembly Version: 7.1.0.0
Win32 Version: 7.1.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CodeBase.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
OpenDentBusiness
Assembly Version: 7.7.8.0
Win32 Version: 7.7.8.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDentBusiness.DLL
----------------------------------------
SparksToothChart
Assembly Version: 4.7.1.0
Win32 Version: 4.7.1.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/SparksToothChart.DLL
----------------------------------------
Microsoft.DirectX.Direct3D
Assembly Version: 1.0.2902.0
Win32 Version: 9.05.132.0000
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.DirectX.Direct3D/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.Direct3D.dll
----------------------------------------
xImageDeviceManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/xImageDeviceManager.DLL
----------------------------------------
SigPlusNET
Assembly Version: 1.0.2245.36238
Win32 Version:
CodeBase: file:///C:/Program%20Files/Open%20Dental/SigPlusNET.DLL
----------------------------------------
AxInterop.AcroPDFLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/AxInterop.AcroPDFLib.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
MySql.Data
Assembly Version: 6.2.4.0
Win32 Version: 6.2.4.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MySql.Data.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Oracle.DataAccess
Assembly Version: 2.112.2.0
Win32 Version: 2.112.2.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/Oracle.DataAccess.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
CDT
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CDT.DLL
----------------------------------------
PluginDrTECH
Assembly Version: 1.1.2.2
Win32 Version: 1.1.2.2
CodeBase: file:///C:/Program%20Files/Open%20Dental/PluginDrTECH.DLL
----------------------------------------
Microsoft.DirectX
Assembly Version: 1.0.2902.0
Win32 Version: 5.04.00.2904
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.DirectX/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.dll
----------------------------------------
Microsoft.DirectX.Direct3DX
Assembly Version: 1.0.2911.0
Win32 Version: 9.12.589.0000
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.DirectX.Direct3DX/1.0.2911.0__31bf3856ad364e35/Microsoft.DirectX.Direct3DX.dll
----------------------------------------
Microsoft.VisualC
Assembly Version: 8.0.0.0
Win32 Version: 8.00.50727.4927
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualC/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualC.dll
----------------------------------------
VBbridges
Assembly Version: 4.4.11.0
Win32 Version: 4.4.11.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/VBbridges.DLL
----------------------------------------
MigraDoc.DocumentObjectModel
Assembly Version: 1.2.2546.0
Win32 Version: 1.2.2546.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MigraDoc.DocumentObjectModel.DLL
----------------------------------------
MigraDoc.Rendering
Assembly Version: 1.2.2546.0
Win32 Version: 1.2.2546.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MigraDoc.Rendering.DLL
----------------------------------------
PdfSharp
Assembly Version: 1.2.1269.0
Win32 Version: 1.2.1269.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/PdfSharp.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[jordansparks]

Out of resources? Is your hard drive/partition full?

[jordansparks]

> When I run under debug mode, I don't get a debug error, the program just hangs as soon as I click on the "Main" tab in the task list.
In a situation like that, you step through one line at a time until it mysteriously jumps out. Then, at least you know what line it's happening on.

[drtech]

Hum...not out of space on my server, but that does seem like a message that makes since with that....

[drtech]

mysqldump: Got error: 1016: Can't open file: './opendental/plannedappt.frm' (errno: 24) when using LOCK TABLES


anyone know what my problem might be when I am getting this kind of error?

[drtech]

I am going to try to migrate everything to a different server and see if that solves these strange errors...

[jordansparks]

A Windows server, right?

[drtech]

linux

are you saying i should go to a windows server or just wondering?

[jordansparks]

Well, a Windows server makes a lot more sense to me. But it's up to you.

[drtech]

Once you learn it, there is nothing like the power and simplicity of linux...networking and backup in my opinion, there is nothing comparable to rsync in windows.

I have my files backing up between three locations with secure SSH everyday automatically and it is so simple and fast. All other backup solutions for windows are clunky that I have found.

Is there something similar to rsync with secure remote backup in windows? (without running cygwin which seems to slow down windows to a crawl after a while)

[drtech]

new server...similar issue today. When going to the pt's chart (I think i clicked on planned appt, but not 100% sure)
"Out of resources when opening file '/tmp/#sql_46a_0.MDY' (Errcode:24)

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: Out of resources when opening file '/tmp/#sql_46a_0.MYD' (Errcode: 24)
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
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.GetTable(String command) in C:\SVN\Beta\OpenDentBusiness\Db\DataConnection.cs:line 352
at OpenDentBusiness.ChartModules.GetProgNotes(Int64 patNum, Boolean isAuditMode) in C:\SVN\Beta\OpenDentBusiness\Db Multi Table\ChartModules.cs:line 655
at OpenDentBusiness.ChartModules.GetAll(Int64 patNum, Boolean isAuditMode) in C:\SVN\Beta\OpenDentBusiness\Db Multi Table\ChartModules.cs:line 17
at OpenDental.ContrChart.FillProgNotes(Boolean retainSelection) in C:\SVN\Beta\OpenDental\Main Modules\ContrChart.cs:line 4166
at OpenDental.ContrChart.RefreshModuleScreen() in C:\SVN\Beta\OpenDental\Main Modules\ContrChart.cs:line 3322
at OpenDental.ContrChart.ModuleSelected(Int64 patNum) in C:\SVN\Beta\OpenDental\Main Modules\ContrChart.cs:line 3204
at OpenDental.FormOpenDental.SetModuleSelected() in C:\SVN\Beta\OpenDental\Main Modules\FormOpenDental.cs:line 2952
at OpenDental.FormOpenDental.myOutlookBar_ButtonClicked(Object sender, ButtonClicked_EventArgs e) in C:\SVN\Beta\OpenDental\Main Modules\FormOpenDental.cs:line 2918
at OpenDental.OutlookBar.OnButtonClicked(OutlookButton myButton, Boolean myCancel) in C:\SVN\Beta\OpenDental\User Controls\OutlookBar.cs:line 321
at OpenDental.OutlookBar.OnMouseUp(MouseEventArgs e) in C:\SVN\Beta\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.4952 (win7RTMGDR.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 7.7.10.0
Win32 Version: 7.7.10.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDental.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Assembly Version: 7.1.0.0
Win32 Version: 7.1.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CodeBase.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
OpenDentBusiness
Assembly Version: 7.7.10.0
Win32 Version: 7.7.10.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDentBusiness.DLL
----------------------------------------
SparksToothChart
Assembly Version: 4.7.1.0
Win32 Version: 4.7.1.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/SparksToothChart.DLL
----------------------------------------
Microsoft.DirectX.Direct3D
Assembly Version: 1.0.2902.0
Win32 Version: 9.05.132.0000
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.DirectX.Direct3D/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.Direct3D.dll
----------------------------------------
xImageDeviceManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/xImageDeviceManager.DLL
----------------------------------------
SigPlusNET
Assembly Version: 1.0.2245.36238
Win32 Version:
CodeBase: file:///C:/Program%20Files/Open%20Dental/SigPlusNET.DLL
----------------------------------------
AxInterop.AcroPDFLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/AxInterop.AcroPDFLib.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
MySql.Data
Assembly Version: 6.2.4.0
Win32 Version: 6.2.4.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MySql.Data.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Oracle.DataAccess
Assembly Version: 2.112.2.0
Win32 Version: 2.112.2.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/Oracle.DataAccess.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
CDT
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CDT.DLL
----------------------------------------
PluginDrTECH
Assembly Version: 1.1.2.2
Win32 Version: 1.1.2.2
CodeBase: file:///C:/Program%20Files/Open%20Dental/PluginDrTECH.DLL
----------------------------------------
Microsoft.DirectX
Assembly Version: 1.0.2902.0
Win32 Version: 5.04.00.2904
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.DirectX/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.dll
----------------------------------------
Tao.OpenGl
Assembly Version: 2.1.0.4
Win32 Version: 2.1.0.4
CodeBase: file:///C:/Program%20Files/Open%20Dental/Tao.OpenGl.DLL
----------------------------------------
Tao.Platform.Windows
Assembly Version: 1.0.0.4
Win32 Version: 1.0.0.4
CodeBase: file:///C:/Program%20Files/Open%20Dental/Tao.Platform.Windows.DLL
----------------------------------------
VBbridges
Assembly Version: 4.4.11.0
Win32 Version: 4.4.11.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/VBbridges.DLL
----------------------------------------
MigraDoc.DocumentObjectModel
Assembly Version: 1.2.2546.0
Win32 Version: 1.2.2546.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MigraDoc.DocumentObjectModel.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[jordansparks]

What version of MySQL are you using? I'm sure it's not the same as everyone else.

[drtech]

MySQL 5.1.49 on Ubuntu 10.10

I am beginning to think that might be the problem....what version is everyone running on windows?

[jordansparks]

One reason why I suggested Windows. Not so much because Windows is superior, but just to guarantee that your installation is the same as everyone else's. 5.0.22.

[drtech]

I will try to downgrade mySQL and see what happens

[drtech]

tried my database on a 5.0 windows mySQL host and I still have the freezing task list. Does not mean 5.1 is still not a problem for the other error, but I was hoping for an easy solution to that issue that I can't trace at all. It just hangs when at line 352 in DataConnection.cs when trying to load the table....it does nothing when I try to step into it....how do I solve this issue? I can't figure out HOW to debug it and I can't see most of my tasks!!!

[jordansparks]

"line 352 in DataConnection.cs" doesn't help at all. Go back a few steps. What class/method/line is calling DataConnection? Take the query and run it in another tool. Find out what's wrong with that query and why it is causing your system to hang. Revise the query until it works.

[drtech]

When I run the offending query in SQLyog I get this result: (Both with windows mySQL 5.0 and linux mySQL 5.1)

SELECT tasklist.*,(SELECT COUNT(*) FROM taskancestor,task WHERE taskancestor.TaskListNum=tasklist.TaskListNum AND task.TaskNum=taskancestor.TaskNum AND EXISTS(SELECT * FROM taskunread WHERE taskunread.TaskNum=task.TaskNum AND (CASE WHEN EXISTS(SELECT * FROM userod WHERE userod.TaskListInBox=tasklist.TaskListNum) THEN (taskunread.UserNum=(SELECT UserNum FROM userod WHERE userod.TaskListInBox=tasklist.TaskListNum)) ELSE taskunread.UserNum=7 END)) AND task.TaskStatus !=2 ) FROM tasklist WHERE Parent=0 AND DateTL < '1880-01-01' AND IsRepeating=0 ORDER BY Descript


Error Code : 1242
Subquery returns more than 1 row

Execution Time : 00:00:00:016
Transfer Time : 00:00:00:000
Total Time : 00:00:00:016

[drtech]

i am parsing down each individual query and getting valid results from each subquery that I try, so still not sure what the problem is...obviously a combination is causing it to hang, but how to find....

[drtech]

Ok, I decided to try something wild on a backup test database. I erased all the data in the taskunread table and now it works!

If I do that on my main database, of course I would loose the status off all my existing tasks, but allows me to see the list. Is there something you could write for database maint to try to reindex these or something? Or am I best off just truncating the entire table in my real database and moving on?

I the problem must be that we have two rows for the same thing? can you write a query to find that and I can delete the row?

[jordansparks]

tasklists.cs? what line?

[drtech]

Tasks.cs line118

[jordansparks]

That doesn't match your posted query. Your query starts with "SELECT tasklist.*", while the line you referred me to starts with "SELECT task.*". I suppose you had better give me the name of the method, too.

[drtech]

hum...maybe when I looked back later on I got the wrong location....let me double check...

[drtech]

sorry, I don't know how I got that last location

I think it comes from here

TasksLists.cs line 68

[jordansparks]

Make line 54 look like this:
THEN (taskunread.UserNum=(SELECT UserNum FROM userod WHERE userod.TaskListInBox=tasklist.TaskListNum LIMIT 1)) ";
by adding the LIMIT 1. Let me know if that fixes it for your db.

[drtech]

Yes, it works!!!

Thanks!

[jordansparks]

Change backported and committed.