MySQL Server Variables

 

MySQL Server Variables  

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

Some users do not use the EZ2000 Plus Dental Installer 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 FilesMySQLMySQL Server 5.0my.ini

It needs to look like the examples in my.ini.

Caution! If you see extra lines that you didn't add, then you didn't use our installer.  One of the extra lines is causing the problem.

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.

3/16/2011
As an example, a user was getting a duplicate key error.  They didn't want to use our recommended my.ini file for some reason (maybe they were a power user or maybe they were running it on Linux).  Inspection of their my.ini file revealed the following problem line:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Removing that line or commenting it out fixed the problem.

 

  EZ2000 Plus Dental Software 800-273-5033