Database Maintenance  

In the Main Menu, click Tools, Misc Tools, Database Maintenance.

If it tells you that you have a corrupted table, see the Corruption page. If it tells you that a patient has an insurance plan with no carrier assigned, go to the Family module for that patient. You might have to use the dropdown list by the Add Insurance button to view all plans for the family, because the plan in question might not be visible on the main screen of the Family module if it's no longer in use.

Ins Pay Fix:  Creates checks for insurance payments that are not attached to a check.  This is used when users have not been attaching their Insurance Payments to checks, and it would now take too long to clean it up manually.

Optimize:  Runs the Repair and Optimize SQL commands on each individual table. This does not normally need to be run.  It can be used if corruption is suspected or for extremely large databases.

Appt Procs: Used if the procedure descriptions on appointments are not showing tooth numbers for some reason. 

Spec Char: The "Spec Char" button is used only if you are having trouble synching your appointments to the Mobile App. This button permanently removes unsupported Unicode characters from appointment notes and procedure description fields. This will also remove characters from non-English languages. If you wish to continue, the password is "fix" without quotes.

InnoDb:  Converts all tables in the database to the selected storage engine (MyISAM or InnoDb).  All users are initially set up as MyISAM.  Users only switch to InnoDb if they have special needs, such as increased performance.  User must have done research on MySQL website.

Tokens:  Checks the database for any tokens that are attached to the wrong credit card number. A second window will come up listing all credit cards and letting you decide which ones to check.

Print: Prints the report currently displayed in the log.

Check: Allows you to preview errors found in the database before you fix them.

Fix: Attempts to fix errors found in the database. Some errors require user intervention in order to be fixed.