[Vtigercrm-developers] 6.1.0 EA (early access) build for validation

[Prasad]

Alan,

Phone numbers are being captured in separate table to
speed up the lookup when a call comes in - the migration
is trying to populate the existing data using the same code.

fnumber and rnumber are being store to speed up DB look up
specifically when LIKE with % is used.

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* Facebook
<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I* Blog
<https://blogs.vtiger.com/>* I* Wiki
<http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
<https://discussions.vtiger.com>*I* Website <https://www.vtiger.com/>

On Sun, Sep 14, 2014 at 6:58 PM, Alan Lord (News) <alanslists at gmail.com>
wrote:

> On 12/09/14 07:43, Prasad wrote:
>
>> You can download the migration patch for validating from 600 to 610 here
>> <https://www.dropbox.com/s/ai2riazvnvwi6nu/vtigercrm-600-
>> 610-betatesting-patch.zip?dl=1>.
>>
>
> 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.
>
> 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
>
>  INSERT INTO vtiger_pbxmanager_phonelookup(crmid, setype, fnumber,
>> rnumber, fieldname)
>>                     VALUES('59901','Contacts','
>> Hernan','nanreH','firstname')
>>                     ON DUPLICATE KEY
>>                     UPDATE fnumber=VALUES(fnumber),
>> rnumber=VALUES(rnumber);
>>
>
> 2 questions:
>
> 1. What are these records for?
> 2. Why is it writing the first and lastnames into columns called fnumber
> and rnumber? Shouldn't these be phone numbers?
>
> Cheers
>
>
> Al
>
>
> --
> Libertus Solutions
> http://www.libertus.co.uk
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140915/f1563e86/attachment.html>