MySQL Server Variables  

The issues below were fixed with version 6.9.10, so they only apply to versions earlier than that.

Some users do not use the Open Dental Installer (Trial Version) to install MySQL.  The problem with that is that they may end up with extra server variables.  MySQL server variables are stored in the my.ini file that is part of the installation process.  If you do not use our installer, you will tend to get a variety of errors.  Errors will also tend to happen during a conversion process, corrupting the conversion.  Some examples are listed below, and we will add to this list as we run across more of them.

"the field ***** doesn't have a default value"
or
"MySqlException: Duplicate entry '11134' for key 1"

If you are not sure if MySQL server variables are the problem, look at this file:
C:\Program Files\MySQL\MySQL Server 5.0\my.ini

It should look similar to this:
[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/mysql/data/"
skip-innodb

If you see extra lines beyond the 4 shown above, then you did not use our installer.

The way to fix such errors is to run our installer from the trial version page.  But ONLY have the box along the left checked for the my.ini file.  You must also make sure, before you click Install, that the path to the MySQL Server and the path to opendental Database are both correct.  Both of those paths will be used when creating the new my.ini file.

If you are a power user, and you want to edit the my.ini file yourself, then you must restart the mysql service after editing.