DB update from trial version to 6.2.0.0

[glycerin]

Hi everybody.
Me and another italian developer we are trying to restart the working process for the italian translation of the program and also the necessary adaptation for this country to let this program usable.

Now we are encountering some problem while we try to convert the DB from the old version (the one provided with the trial version) to the new release ...the 6.2.0.0.

I've tryied with the advice that I saw in this post...
http://70.90.133.65/forum/viewtopic.php ... rade#p4923
but without success.
I've changed the my.ini configuration file to the instructions provided by Jordan but the result is the same.
Here you are some about the exception...

Code: Select all

MySql.Data.MySqlClient.MySqlException: BLOB/TEXT column 'Comments' can't have a default value
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery
   at OpenDentBusiness.DataConnection.NonQ in e:\project_personal\opendental\head\OpenDentBusiness\DataConnection.cs:line 379
   at OpenDentBusiness.DataCore.NonQ in e:\project_personal\opendental\head\OpenDentBusiness\DataCore.cs:line 32
   at OpenDentBusiness.General.NonQ in e:\project_personal\opendental\head\OpenDentBusiness\Data Interface\General.cs:line 75
   at OpenDentBusiness.General.NonQ in e:\project_personal\opendental\head\OpenDentBusiness\Data Interface\General.cs:line 80
   at OpenDental.ClassConvertDatabase.To5_8_1 in e:\project_personal\opendental\head\OpenDental\Misc\ClassConvertDatabase.cs:line 7646
   at OpenDental.ClassConvertDatabase.To5_7_15 in

Any advice on how to solve this problem?
Thank you in advance.
Gabriele Cicala

[jordansparks]

It's the my.ini file. Even though you said you tried to fix it, I think you didn't. Use the installer from our trial version, but ONLY pick the my.ini from the options along the left. Then, install. Also, is it a 64 bit computer?

[glycerin]

Hi Jordan..yesterday I've tryied once again but this time using only your trial installer.
After this step I've launched the building of the 6.2 release and now the conversion process was successfull.
Now the new release is visible and operative.
Thank you.
Best regards.
Gabriele Cicala