<div dir="ltr">Hi Alan,<div><br></div><div>I have reported this issue here in <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8233">trac</a>. We will be fixing it soon.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Sep 14, 2014 at 6:58 PM, Alan Lord (News) <span dir="ltr"><<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 12/09/14 07:43, Prasad wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
You can download the migration patch for validating from 600 to 610 here<br></span>
<<a href="https://www.dropbox.com/s/ai2riazvnvwi6nu/vtigercrm-600-610-betatesting-patch.zip?dl=1" target="_blank">https://www.dropbox.com/s/<u></u>ai2riazvnvwi6nu/vtigercrm-600-<u></u>610-betatesting-patch.zip?dl=1</a><u></u>>.<br>
</blockquote>
<br>
I've been running this on a 6.0.0 database that was upgraded from a 5.4.0 database with approximately 500,000 crmentity records.<br>
<br>
Considering this customer never used PBXManager and has no call records, the 600-610 update has spent the last couple of hours running queries like<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
INSERT INTO vtiger_pbxmanager_phonelookup(<u></u>crmid, setype, fnumber, rnumber, fieldname)<br>
                    VALUES('59901','Contacts','<u></u>Hernan','nanreH','firstname')<br>
                    ON DUPLICATE KEY<br>
                    UPDATE fnumber=VALUES(fnumber), rnumber=VALUES(rnumber);<br>
</blockquote>
<br>
2 questions:<br>
<br>
1. What are these records for?<br>
2. Why is it writing the first and lastnames into columns called fnumber and rnumber? Shouldn't these be phone numbers?<br>
<br>
Cheers<div class="HOEnZb"><div class="h5"><br>
<br>
Al<br>
<br>
<br>
-- <br>
Libertus Solutions<br>
<a href="http://www.libertus.co.uk" target="_blank">http://www.libertus.co.uk</a><br>
<br>
______________________________<u></u>_________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">With<br>Best Regards<br>Uma.S<br><div>Vtiger Team</div></div>
</div>