NConnect($migrationInfo['db_hostname'], $migrationInfo['db_username'], $migrationInfo['db_password'], $migrationInfo['new_dbname']); require_once('include/utils/DBHealthCheck.php'); $dbHealthCheck = new DBHealthCheck($db); $dbHostName = $dbHealthCheck->dbHostName; $dbName = $dbHealthCheck->dbName; if(!empty($_REQUEST['forceDbCheck']) || $_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] != true) { if($_REQUEST['updateTableEngine'] == true) { if(!empty($_REQUEST['updateEngineForTable'])) { $dbHealthCheck->updateTableEngineType(htmlentities($_REQUEST['updateEngineForTable'])); } elseif($_REQUEST['updateEngineForAllTables'] == true) { $dbHealthCheck->updateAllTablesEngineType(); } } $unHealthyTablesList = $dbHealthCheck->getUnhealthyTablesList(); $noOfTables = count($unHealthyTablesList); if ($noOfTables <= 0) { $_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] = true; if($_REQUEST['ajax'] == true) { echo "TABLE_TYPE_FIXED"; } } else { $_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] = false; } } if ($_REQUEST['viewDBReport'] == true) { if($_SESSION['authentication_key'] != $_REQUEST['auth_key']) { die("Not Authorized to perform this operation"); } $auth_key = $_REQUEST['auth_key']; ?> vtiger CRM 5 - Database Check
 Database Check vtiger CRM 5
Required tables were detected to be in proper Engine type (InnoDB)
You can close this window and proceed further with migration.
For proper functionality of vtiger CRM, we recommend the following:
  • Tables to have InnoDB engine type. ( What is InnoDB?).
  • To get complete UTF-8 support, tables should have default charset UTF8.
Table Character Set Type
  (Fix Now)