Upgrades and Database Maintenance
Posted: Mon Mar 10, 2014 3:54 pm
In order to make some reporting tools we're using faster, we've implement various views in our database. Whenever we upgrade or run database maintenance from OpenDental it thinks the views are tables and are corrupt or don't belong so it stops upgrades from happening and won't fix regular database issues in the maintenance window. I haven't looked at the code to see how you're checking for tables but I suspect the code is using a SHOW TABLES query to get table names which also returns VIEWS. If you change this query to
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
this would only look at the real table structure instead of looking at our views. Hopefully its an easy fix and something you're willing to implement.
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
this would only look at the real table structure instead of looking at our views. Hopefully its an easy fix and something you're willing to implement.