6.4 (beta) - Exception Error while entering payment - Bug ?

[opensource]

Hello Dr. Jordan / Team,

I recently upgraded to 6.4 (beta) and one of the problems I have encountered is that we get an exception error while entering payment. It is related to the column called 'InsEst' (looks like this column is in the Patient & TempFamBal table (temp table). The issue is that the column 'InsEst' in "TempFamBal" table which is created at run-time(?)...has the 'InsEst' column with no default value but open-dental does not like this when entering the payment. Not sure if I missed a step during the upgrade process...here is the error text..

------------
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: Field 'InsEst' doesn't have a default value
at MySql.Data.MySqlClient.PacketReader.CheckForError()
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.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:\Godiwala\SmileWorld\Applications\OpenDental\OpenDental64\OpenDentBusiness\DataConnection.cs:line 296
at OpenDentBusiness.General.GetTable(String command) in C:\Godiwala\SmileWorld\Applications\OpenDental\OpenDental64\OpenDentBusiness\Data Interface\General.cs:line 18
at OpenDentBusiness.Patients.GetPaymentStartingBalances(Int32 guarNum, Int32 excludePayNum) in C:\Godiwala\SmileWorld\Applications\OpenDental\OpenDental64\OpenDentBusiness\Data Interface\Patients.cs:line 955
at OpenDental.FormPayment.FormPayment_Load(Object sender, EventArgs e) in C:\Godiwala\SmileWorld\Applications\OpenDental\OpenDental64\OpenDental\Forms\FormPayment.cs:line 654
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.ContainerControl.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)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 6.4.12.0
Win32 Version: 6.4.12.0
CodeBase: file:///C:/Applications/OpenDental/OpenDental.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Assembly Version: 6.4.0.0
Win32 Version: 6.4.0.0
CodeBase: file:///C:/Applications/OpenDental/CodeBase.DLL
----------------------------------------
OpenDentBusiness
Assembly Version: 6.4.1.0
Win32 Version: 6.4.1.0
CodeBase: file:///C:/Applications/OpenDental/OpenDentBusiness.DLL
----------------------------------------
SparksToothChart
Assembly Version: 4.7.1.0
Win32 Version: 4.7.1.0
CodeBase: file:///C:/Applications/OpenDental/SparksToothChart.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
xImageDeviceManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Applications/OpenDental/xImageDeviceManager.DLL
----------------------------------------
SigPlusNET
Assembly Version: 1.0.2245.36238
Win32 Version:
CodeBase: file:///C:/Applications/OpenDental/SigPlusNET.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
CDT
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Applications/OpenDental/CDT.DLL
----------------------------------------
MySql.Data
Assembly Version: 1.0.9.0
Win32 Version: 1.0.9.0
CodeBase: file:///C:/Applications/OpenDental/MySql.Data.DLL
----------------------------------------
Oracle.DataAccess
Assembly Version: 10.2.0.100
Win32 Version: 10.2.0.100
CodeBase: file:///C:/Applications/OpenDental/Oracle.DataAccess.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Tao.OpenGl
Assembly Version: 2.1.0.4
Win32 Version: 2.1.0.4
CodeBase: file:///C:/Applications/OpenDental/Tao.OpenGl.DLL
----------------------------------------
Tao.Platform.Windows
Assembly Version: 1.0.0.4
Win32 Version: 1.0.0.4
CodeBase: file:///C:/Applications/OpenDental/Tao.Platform.Windows.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.
-----

Thanks in advance for all your help...

Cheers,

OpenSource

[jordansparks]

http://www.open-dent.com/manual/mysqlse ... ables.html

[opensource]

Hello Dr. Jordan,

Sorry, I had forgotten about this one. One of these days, I will do my research to figure out why the standard my.ini does not work with open-dental directly

But for now, this did fix the problem..Thanks again.

Cheers,

Opensource

[ronbob]

hello
can you elaborate again on this error "field 'InsEst' doesn't have a default value" when pressing the payment button. I know there was a fix which I used years ago but the problem came back again and I don't remember what I should be doing. any ideas? much appreciated...

[jsalmon]

hello
can you elaborate again on this error "field 'InsEst' doesn't have a default value" when pressing the payment button. I know there was a fix which I used years ago but the problem came back again and I don't remember what I should be doing. any ideas? much appreciated...

Its been seven years since v6.4 was beta, are you using that version? What exact version are you using?
Providing your exception details would be very helpful (like opensource did above) so that we can see where your failure is occurring.

[ronbob]

hi
the version i'm using is 6.3.4... i will be doing updates shortly but in the meantime i need to resolve this again.. detail of the problem included. i tried using a different computer as trial server and there i have no problems. which is kind of strange.
thanks

field 'InsEst' doesn't have a default value

MySql.Data.MySqlClient.MySqlException: Field 'InsEst' doesn't have a default value
à MySql.Data.MySqlClient.PacketReader.CheckForError()
à MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
à MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
à MySql.Data.MySqlClient.CommandResult..ctor(Driver d, Boolean isBinary)
à MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
à MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
à MySql.Data.MySqlClient.MySqlDataReader.NextResult()
à MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
à MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
à System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
à OpenDentBusiness.DataConnection.GetTable(String command) dans G:\opendental\opendental6.3\OpenDentBusiness\DataConnection.cs:ligne 297
à OpenDentBusiness.DataCore.GetTable(String command) dans G:\opendental\opendental6.3\OpenDentBusiness\DataCore.cs:ligne 12
à OpenDentBusiness.General.GetTable(String command) dans G:\opendental\opendental6.3\OpenDentBusiness\Data Interface\General.cs:ligne 18
à OpenDentBusiness.Patients.GetPaymentStartingBalances(Int32 guarNum, Int32 excludePayNum) dans G:\opendental\opendental6.3\OpenDentBusiness\Data Interface\Patients.cs:ligne 955
à OpenDental.FormPayment.FormPayment_Load(Object sender, EventArgs e) dans G:\opendental\opendental6.3\OpenDental\Forms\FormPayment.cs:ligne 654
à System.Windows.Forms.Form.OnLoad(EventArgs e)
à System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
à System.Windows.Forms.Control.CreateControl()
à System.Windows.Forms.Control.WmShowWindow(Message& m)
à System.Windows.Forms.Control.WndProc(Message& m)
à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Assemblys chargés **************
mscorlib
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4253 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Version de l'assembly : 6.3.4.0
Version Win32 : 6.3.4.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/OpenDental.exe
----------------------------------------
System.Windows.Forms
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4257 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4253 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4261 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Version de l'assembly : 4.7.0.0
Version Win32 : 4.7.0.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/CodeBase.DLL
----------------------------------------
OpenDentBusiness
Version de l'assembly : 6.3.1.0
Version Win32 : 6.3.1.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/OpenDentBusiness.DLL
----------------------------------------
System.Xml
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4260 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
SparksToothChart
Version de l'assembly : 4.7.1.0
Version Win32 : 4.7.1.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/SparksToothChart.DLL
----------------------------------------
xImageDeviceManager
Version de l'assembly : 1.0.0.0
Version Win32 : 1.0.0.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/xImageDeviceManager.DLL
----------------------------------------
System.Data
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4252 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Windows.Forms.resources
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_fr_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
CDT
Version de l'assembly : 1.0.0.0
Version Win32 : 1.0.0.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/CDT.DLL
----------------------------------------
mscorlib.resources
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4253 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
System.Configuration
Version de l'assembly : 2.0.0.0
Version Win32 : 2.0.50727.4252 (VistaSP2GDR.050727-4200)
CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Oracle.DataAccess
Version de l'assembly : 10.2.0.100
Version Win32 : 10.2.0.100
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/Oracle.DataAccess.DLL
----------------------------------------
MySql.Data
Version de l'assembly : 1.0.9.0
Version Win32 : 1.0.9.0
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/MySql.Data.DLL
----------------------------------------
Tao.OpenGl
Version de l'assembly : 2.1.0.4
Version Win32 : 2.1.0.4
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/Tao.OpenGl.DLL
----------------------------------------
Tao.Platform.Windows
Version de l'assembly : 1.0.0.4
Version Win32 : 1.0.0.4
CodeBase : file:///C:/Program%20Files%20(x86)/Open%20Dental/Tao.Platform.Windows.DLL
----------------------------------------

************** Débogage JIT **************
Pour activer le débogage juste-à-temps (JIT), le fichier de configuration pour cette
application ou cet ordinateur (machine.config) doit avoir la valeur
jitDebugging définie dans la section system.windows.forms.
L'application doit également être compilée avec le débogage
activé.

Par exemple :

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

Lorsque le débogage juste-à-temps est activé, les exceptions non gérées
seront envoyées au débogueur JIT inscrit sur l'ordinateur
plutôt que d'être gérées par cette boîte de dialogue.

[jsalmon]

That's not all that strange. It looks like your MySQL instance (the non-trial MySQL) is running in STRICT mode and will complain at you if you try to insert data into the database without first specifying "NOT NULL" columns. I think you simply need to run the following query:

Code: Select all

SET sql_mode = '';

[ronbob]

hi
I have resolved the issue by changing the my.ini in the MySQL folder... the problem simply went away.
here is the new ini incase someone else is interested. just make sure the folders links are correct.
thanks for your help.

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

port=3306

[mysql]

default-character-set=latin1


# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=latin1

default-storage-engine=MyISAM
skip-innodb
max_allowed_packet=40M
key_buffer = 384M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
tmp_table_size = 32M
join_buffer_size = 128M