MailManager package in VT7.1 - vtiger_mailmanager_mailrecord field mfolder is missing in schema.xml
If you install VT71 vtiger_mailmanager_mailrecord field mfolder is missing. In the migration path it will be created in 660_to_700.php About line 1882 $columns = $db->getColumnNames('vtiger_mailmanager_mailrecord'); if (!in_array('mfolder', $columns)) { $db->pquery('ALTER TABLE vtiger_mailmanager_mailrecord ADD COLUMN mfolder VARCHAR(250)', array()); $duplicateResult = $db->pquery('SELECT muid FROM vtiger_mailmanager_mailrecord GROUP BY muid HAVING COUNT(muid) > ?', array('1')); $noOfDuplicate =
db->num_rows(
duplicateResult);
if ($noOfDuplicate) {
duplicateMuid = array(); for (
i=0; i<
noOfDuplicate; $i++) {
$duplicateMuid[] = db->query_result(
duplicateResult, $i, 'muid');
}
db->pquery('DELETE FROM vtiger_mailmanager_mailrecord WHERE muid IN ('.generateQuestionMarks(
duplicateMuid).')', $duplicateMuid);
db->pquery('DELETE FROM vtiger_mailmanager_mailattachments WHERE muid IN ('.generateQuestionMarks(
duplicateMuid).')', $duplicateMuid);
}
}