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

[Alan Lord]

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'