Database Maintenance  

The database maintenance tool checks the entire database for improper settings, inconsistencies, or corruption, and fixes or gives instructions on how to repair problems that are found. 

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

Check: Check the database for errors and preview them in the log before fixing them.

Fix: Attempt to fix errors found in the database. The log will show details of what is fixed.  Some errors must be fixed manually.

Print: Print the report currently displayed in the log.

Log Results:
Use the resources below to fix issues indicated in log results when you Check or Fix.

• If the log indicates you have a corrupted table, see Corruption.
• If the log indicates 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.
• "Transactions found attached to an invalid account: X.  All invalid transactions have been attached to the account called UNKNOWN. They need to be fixed manually." See Accounting, Troubleshooting.

Database Tools

Ins Pay Fix:  Create 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:  Run 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: Used only if you are having trouble synching your appointments to the Mobile App or if you receive an invalid character error while trying to use the Middle Tier.  This button permanently removes unsupported Unicode characters from appointment notes, procedure descriptions, patient address notes, patient address fields, adjustment notes, payment notes, and definition names. This will also remove characters from non-English languages. If you wish to continue, the password is "fix" without quotes.

InnoDb:  Convert 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:  Check 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.

Remove Nulls:  Remove extra, hidden characters that may be causing errors or problems.  This tool will replace extra spaces with empty strings.