<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Pratim,<br>
<br>
I have just reported ticket #6716 and after it resolved a fatal error
in the migration process from 5.1.0 to 5.2.0 VB1<br>
<br>
There was a missing line and a missing command from the<br>
/modules/Migration/DBChanges/510_to_520.php<br>
<br>
Line: 470<br>
ExecuteQuery("CREATE TABLE <font color="#990000"><b>IF NOT EXISTS</b></font>
`vtiger_customerportal_prefs` ( `tabid` int(11) NOT NULL, `prefkey` <br>
varchar(100) default NULL, `prefvalue` int(20) default NULL, INDEX
tabid_idx(tabid) <br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8");<br>
Here is the missing command <font color="#990000"><b>IF NOT EXISTS</b></font>
<br>
<br>
Line: 474-475<br>
<b><font color="#990000">$blockquery = "select blockid from
vtiger_blocks where blocklabel = ?";</font></b><br>
$blockres = $adb->pquery($blockquery,array('LBL_EMAIL_INFORMATION'));<br>
<br>
Here was missing $blockquery identification.<br>
<br>
How I can change or correct in the source it?<br>
<br>
After correction the migration process is running well without any
errors. <br>
<br>
Best regards:<br>
<br>
<div class="moz-signature">István Holbok<br>
telefon: +3670-342-0900<br>
e-mail: <a href="mailto:holbok@gmail.com">holbok@gmail.com</a><br>
(Hungary)<br>
</div>
<br>
</body>
</html>