[Vtigercrm-developers] vt61 - ModTracker Summary Widget: 44 Years!

[Alan Lord]

On 10/10/14 10:30, Alan Lord wrote:

>> Fri Oct 10 09:24:17 2014,598 [25528] DEBUG VT - Prepared sql query
>> being executed : SELECT libertus_lstourdetailscf.cf_962 AS

Did you notice that this query duplicates all the columnnames???

I just checked on another module (that records updated in modtracker 
correctly and the same query is generated. All columns are retrieved 
twice!!!

Why?

> SELECT
> libertus_lstourfamiliescf.cf_968 AS libertus_lstourfamiliescfcf_968,
> libertus_lstourfamiliescf.cf_970 AS libertus_lstourfamiliescfcf_970,
> libertus_lstourfamiliescf.cf_972 AS libertus_lstourfamiliescfcf_972,
> libertus_lstourfamilies.tourfamiliesno AS libertus_lstourfamiliestourfamiliesno,
> libertus_lstourfamilies.lstf_marstatus AS libertus_lstourfamilieslstf_marstatus,
> libertus_lstourfamilies.firstname AS libertus_lstourfamiliesfirstname,
> libertus_lstourfamilies.firstnamesp AS libertus_lstourfamiliesfirstnamesp,
> libertus_lstourfamilies.lastname AS libertus_lstourfamilieslastname,
> libertus_lstourfamilies.lastnamesp AS libertus_lstourfamilieslastnamesp,
> libertus_lstourfamilies.address AS libertus_lstourfamiliesaddress,
> libertus_lstourfamilies.addresssp AS libertus_lstourfamiliesaddresssp,
> libertus_lstourfamilies.city AS libertus_lstourfamiliescity,
> libertus_lstourfamilies.citysp AS libertus_lstourfamiliescitysp,
> libertus_lstourfamilies.state AS libertus_lstourfamiliesstate,
> libertus_lstourfamilies.statesp AS libertus_lstourfamiliesstatesp,
> libertus_lstourfamilies.zip AS libertus_lstourfamilieszip,
> libertus_lstourfamilies.zipsp AS libertus_lstourfamilieszipsp,
> libertus_lstourfamilies.cellphone AS libertus_lstourfamiliescellphone,
> libertus_lstourfamilies.cellphonesp AS libertus_lstourfamiliescellphonesp,
> libertus_lstourfamilies.homephone AS libertus_lstourfamilieshomephone,
> libertus_lstourfamilies.homephonesp AS libertus_lstourfamilieshomephonesp,
> libertus_lstourfamilies.email AS libertus_lstourfamiliesemail,
> libertus_lstourfamilies.emailsp AS libertus_lstourfamiliesemailsp,
> libertus_lstourfamilies.lslocationsid AS libertus_lstourfamilieslslocationsid,
> libertus_lstourfamilies.frstcondate AS libertus_lstourfamiliesfrstcondate,
> libertus_lstourfamilies.contactid AS libertus_lstourfamiliescontactid,
> libertus_lstourfamilies.foccode AS libertus_lstourfamiliesfoccode,
> vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,
> vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,
> vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,
> libertus_lstourfamiliescf.cf_970 AS libertus_lstourfamiliescfcf_970,
> libertus_lstourfamiliescf.cf_968 AS libertus_lstourfamiliescfcf_968,
> libertus_lstourfamiliescf.cf_972 AS libertus_lstourfamiliescfcf_972,
> libertus_lstourfamilies.tourfamiliesno AS libertus_lstourfamiliestourfamiliesno,
> libertus_lstourfamilies.lstf_marstatus AS libertus_lstourfamilieslstf_marstatus,
> libertus_lstourfamilies.firstname AS libertus_lstourfamiliesfirstname,
> libertus_lstourfamilies.firstnamesp AS libertus_lstourfamiliesfirstnamesp,
> libertus_lstourfamilies.lastname AS libertus_lstourfamilieslastname,
> libertus_lstourfamilies.lastnamesp AS libertus_lstourfamilieslastnamesp,
> libertus_lstourfamilies.address AS libertus_lstourfamiliesaddress,
> libertus_lstourfamilies.addresssp AS libertus_lstourfamiliesaddresssp,
> libertus_lstourfamilies.city AS libertus_lstourfamiliescity,
> libertus_lstourfamilies.citysp AS libertus_lstourfamiliescitysp,
> libertus_lstourfamilies.state AS libertus_lstourfamiliesstate,
> libertus_lstourfamilies.statesp AS libertus_lstourfamiliesstatesp,
> libertus_lstourfamilies.zip AS libertus_lstourfamilieszip,
> libertus_lstourfamilies.zipsp AS libertus_lstourfamilieszipsp,
> libertus_lstourfamilies.cellphone AS libertus_lstourfamiliescellphone,
> libertus_lstourfamilies.cellphonesp AS libertus_lstourfamiliescellphonesp,
> libertus_lstourfamilies.homephone AS libertus_lstourfamilieshomephone,
> libertus_lstourfamilies.homephonesp AS libertus_lstourfamilieshomephonesp,
> libertus_lstourfamilies.email AS libertus_lstourfamiliesemail,
> libertus_lstourfamilies.emailsp AS libertus_lstourfamiliesemailsp,
> vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,
> vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,
> vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,
> libertus_lstourfamilies.lslocationsid AS libertus_lstourfamilieslslocationsid,
> libertus_lstourfamilies.frstcondate AS libertus_lstourfamiliesfrstcondate,
> libertus_lstourfamilies.contactid AS libertus_lstourfamiliescontactid,
> libertus_lstourfamilies.foccode AS libertus_lstourfamiliesfoccode,
> vtiger_crmentity.deleted
> FROM  vtiger_crmentity
> LEFT JOIN libertus_lstourfamilies
> ON libertus_lstourfamilies.lstourfamiliesid=vtiger_crmentity.crmid
> LEFT JOIN libertus_lstourfamiliescf
> ON libertus_lstourfamiliescf.lstourfamiliesid=vtiger_crmentity.crmid
> WHERE  vtiger_crmentity.crmid=?  LIMIT 1