[Vtigercrm-developers] Ticket #6716: Fatal errors on migration from 5.1.0 to 5.2.0 VB1

[Holbok István]

Hi Pratim,

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

There was a missing line and a missing command from the
/modules/Migration/DBChanges/510_to_520.php

Line: 470
ExecuteQuery("CREATE TABLE *IF NOT EXISTS* `vtiger_customerportal_prefs` 
( `tabid` int(11) NOT NULL, `prefkey`
     varchar(100) default NULL, `prefvalue` int(20) default NULL, INDEX 
tabid_idx(tabid)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8");
Here is the missing command *IF NOT EXISTS*

Line: 474-475
*$blockquery = "select blockid from vtiger_blocks where blocklabel = ?";*
$blockres = $adb->pquery($blockquery,array('LBL_EMAIL_INFORMATION'));

Here was missing $blockquery identification.

How I can change or correct in the source it?

After correction the migration process is running well without any errors.

Best regards:

István Holbok
telefon: +3670-342-0900
e-mail: holbok at gmail.com <mailto:holbok at gmail.com>
(Hungary)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20100531/171ed76d/attachment-0002.html