[Vtigercrm-developers] Reports still broken in 6.3.0 with UItype 10s

[PlaymaN Tepes]

patches are welcome...

2015-07-14 14:23 GMT+02:00 Alan Lord <alanslists at gmail.com>:

> I have given up on this for now having ran out of time...
>
> Perhaps someone else fancies having a go ;-)
>
> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8601
>
> Cheers
>
> Al
>
>
> On 14/07/15 10:35, Alan Lord wrote:
>
>> Tue Jul 14 09:22:14 2015,802 [16492] INFO VT - PearDatabase ->ADODB
>> error  Query Failed:
>> select
>> sum(libertus_lstourdetailscf.cf_964) 'LSTourDetails_Sales_Volume_SUM',
>> sum(libertus_lstourdetails.giftvalue)
>> 'LSTourDetails_LSTOURDETAILS_GIFT_VALUE_SUM',
>> sum(libertus_lstourdetails.depositamnt)
>> 'LSTourDetails_LSTOURDETAILS_DEPOSIT_AMOUNT_SUM'
>> from libertus_lstourfamilies
>> inner join vtiger_crmentity
>>      on vtiger_crmentity.crmid=libertus_lstourfamilies.lstourfamiliesid
>> left join vtiger_groups
>>      on vtiger_groups.groupid = vtiger_crmentity.smownerid
>> left join vtiger_users
>>      on vtiger_users.id = vtiger_crmentity.smownerid
>> left join vtiger_reptmptbl_155a4d4c10fe3d6686545900 as
>> libertus_lstourdetails
>>      on
>>
>> libertus_lstourdetails.lstourfamiliesid=libertus_lstourfamilies.lstourfamiliesid
>>
>> left join vtiger_crmentity as vtiger_crmentityLSTourDetails
>>      on vtiger_crmentityLSTourDetails.crmid =
>> libertus_lstourdetails.lstourdetailsid AND
>> vtiger_crmentityLSTourDetails.deleted=0
>> left join libertus_lstourdetailscf as libertus_lstourdetailscf
>>      on
>>
>> libertus_lstourdetailscf.lstourdetailsid=libertus_lstourdetails.lstourdetailsid
>>
>> left join vtiger_crmentity as vtiger_crmentityRelLSTourDetails1103
>>      on vtiger_crmentityRelLSTourDetails1103.crmid =
>> libertus_lstourdetails.resortid and
>> vtiger_crmentityRelLSTourDetails1103.deleted=0
>> left join *vtiger_account* as
>> vtiger_accountRelLSTourDetails                         <<<<<< 1st Alias
>> here
>>      on vtiger_accountRelLSTourDetails.accountid =
>> vtiger_crmentityRelLSTourDetails1103.crmid
>> left join vtiger_crmentity as vtiger_crmentityRelLSTourDetails1105
>>      on vtiger_crmentityRelLSTourDetails1105.crmid =
>> libertus_lstourdetails.contactid and
>> vtiger_crmentityRelLSTourDetails1105.deleted=0
>> left join vtiger_contactdetails as vtiger_contactdetailsRelLSTourDetails
>>      on vtiger_contactdetailsRelLSTourDetails.contactid =
>> vtiger_crmentityRelLSTourDetails1105.crmid
>> left join *vtiger_account* as
>> vtiger_accountRelLSTourDetails                         <<<<< 2nd Alias
>> here
>>      on vtiger_accountRelLSTourDetails.accountid =
>> vtiger_crmentityRelLSTourDetails1117.crmid
>> WHERE libertus_lstourfamilies.lstourfamiliesid > 0  AND
>> vtiger_crmentity.deleted=0 and (( libertus_lstourdetails.tourdate
>> BETWEEN '2015-07-06' AND '2015-07-12' ) )  ::->[1066]Not unique
>> table/alias: 'vtiger_accountRelLSTourDetails'
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150715/c561a952/attachment-0001.html>