upgrade 6.2 to 6.6

[sunny]

Dr. Jordan. I am upgrading from 6.2 to 6.6. After the upgrade is complete I was getting error and noticed there are changes(New fields were added to Appointment Table). is there any process i should follow to add these fields and get the existing data from my Appointment table in to new version. I really appreciate your feed back.

thanks

[jordansparks]

There were many many changes, but there should be no errors. Are you a paying customer, or did you compile it yourself? There were no errors during the actual conversion? What is the error you are currently getting?

[sunny]

Dr. Jordan, I am not a paying customer. I compiled myself. in my previous post i made a mistake. The version I am using is 5.9.6.0. I noticed There are 3 new fields(DateTimeArrived, DateTimeSeated, DateTimeDismissed) added to Appointment Table. First I got the unknown field(DateTimeArrived) error. Then I physically added these 3 fields. when i recompile and re-run. I am not able to see any information on my appointment form. I am not sure what else is missing. or should I upgrade to previous version before I go to 6.6 version? Please help.

thanks

[jordansparks]

You would never ever ever ever add columns manually to the database. Something sounds very wrong. About all I can suggest is to try a smaller jump in versions. Are you still running it from within Visual Studio, or have you already copied the files to another location and running it from there? I would say run it directly from within VS untily you get this sorted out.

[sunny]

I am running from within visual studio. after upgrade I am restoring the backup copy of my data. I use my sql admin to backup and restore my existing data. while doing it is copying my previous tables. do you think i should get my data in different manner?

thanks

[jordansparks]

The way you should be moving your databases around is:
1. Stop mysql service.
2. Move/delete/rename folders (entire clean folders, not just files).
3. Restart mysql service.

Don't ever damage the original database. Leave multiple clean copies of the original at some other location.

[sunny]

i just want to let you know without making any modifications to my data i am getting the following error message:



MySql.Data.MySqlClient.MySqlException: Unknown column 'DateTimeArrived' in 'field list'
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.CommandResult..ctor(Driver d, Boolean isBinary)
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)
at OpenDentBusiness.Appointments.GetPeriodWaitingRoomTable(DateTime dateStart, DateTime dateEnd)
at OpenDentBusiness.Appointments.RefreshPeriod(DateTime dateStart, DateTime dateEnd)
at OpenDentBusiness.DataCore.GetDsByMethod(MethodNameDS methodName, Object[] parameters)
at OpenDentBusiness.Gen.GetDS(MethodNameDS methodName, Object[] parameters)
at OpenDental.AppointmentL.RefreshPeriod(DateTime dateStart, DateTime dateEnd)
at OpenDental.ContrAppt.RefreshPeriod()
at OpenDental.ContrAppt.InitializeOnStartup()
at OpenDental.FormOpenDental.FormOpenDental_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.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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 6.5.22.0
Win32 Version: 6.5.22.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDental.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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:/Program%20Files/Open%20Dental/CodeBase.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
OpenDentBusiness
Assembly Version: 6.5.22.0
Win32 Version: 6.5.22.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
----------------------------------------
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
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
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:/Program%20Files/Open%20Dental/CDT.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
MySql.Data
Assembly Version: 1.0.9.0
Win32 Version: 1.0.9.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MySql.Data.DLL
----------------------------------------
Oracle.DataAccess
Assembly Version: 10.2.0.100
Win32 Version: 10.2.0.100
CodeBase: file:///C:/Program%20Files/Open%20Dental/Oracle.DataAccess.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
----------------------------------------

************** 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.


Hope this will help.

thanks

[jordansparks]

OK, I'm convinced that it's a bug in 6.6 that only affect people about to convert. A fix to 6.6 will be posted soon and should not give you that problem.

[jordansparks]

I can't duplicate it. Was the conversion to 6.6 successful before this happened? Was MySQL installed using our installer? If not, then I suspect your MySQL permissions as being too restrictive.

[sunny]

Dr.Jordan,
thank you for your feed back and sorry for the delayed response. I got it worked. I was trying to upgrade from 5.7 to 6.6 directly. when i went sequestially it worked fine. thanks again for your help.

thanks
sunny