vt7 dev release - Issue with Migration script design 660_to_700.php
Around line 460 is this snippet of code:
$commentsResult = $db->pquery('SELECT vtiger_modcomments.modcommentsid FROM vtiger_modcomments LEFT JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_modcomments.related_to WHERE vtiger_crmentity.setype NOT IN ('.generateQuestionMarks($internalCommentModules).') OR vtiger_crmentity.setype IS NULL', $internalCommentModules, array());
$commentCount = $db->num_rows($commentsResult);
for ($i=0; $i<$commentCount; $i++) {
$commentIds[] = $db->query_result($commentsResult, $i, 'modcommentsid');
}
if (count($commentIds) > 0) {
$db->pquery('UPDATE vtiger_modcomments SET is_private = 0 WHERE modcommentsid IN ('.generateQuestionMarks($commentIds).')', $commentIds);
}
On this test database I am migrating there are 1,297,610 comments. Can you please imagine how many "?" this creates? (I have customers with bigger databases too)
The query failed as well (but that is a separate issue):
Unknown column 'is_private' in 'field list'