<![CDATA[FrontAccounting forum — Field crm_contacts.entity_id should be INT]]> https://frontaccounting.com/punbb/viewtopic.php?id=5231 Wed, 08 Oct 2014 19:06:49 +0000 PunBB <![CDATA[Re: Field crm_contacts.entity_id should be INT]]> https://frontaccounting.com/punbb/viewtopic.php?pid=21100#p21100 It should not cause any problems if we change it in v2.3 itself isn't it?

]]> Wed, 08 Oct 2014 19:06:49 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=21100#p21100 <![CDATA[Re: Field crm_contacts.entity_id should be INT]]> https://frontaccounting.com/punbb/viewtopic.php?pid=21099#p21099 Yes, seems this good candidate for change in 2.4.
Janusz

]]> Wed, 08 Oct 2014 19:03:32 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=21099#p21099 <![CDATA[Field crm_contacts.entity_id should be INT]]> https://frontaccounting.com/punbb/viewtopic.php?pid=21079#p21079 The field crm_contacts.entity_id is used to look up the cust_branch.branch_code in reporting/rep103.php and hence both must be of the same field type. The former is VARCHAR(11) whilst the latter is INT(11). Any reason why the former remains VARCHAR?

The file sales/includes/db/branches_db.inc too uses the entity_id field to lookup the branch_code in a similar way.

]]> Tue, 07 Oct 2014 14:50:22 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=21079#p21079