<div dir="ltr">patches are welcome...</div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-14 14:23 GMT+02:00 Alan Lord <span dir="ltr"><<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I have given up on this for now having ran out of time...<br>
<br>
Perhaps someone else fancies having a go ;-)<br>
<br>
<a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8601" rel="noreferrer" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8601</a><br>
<br>
Cheers<br>
<br>
Al<div><div class="h5"><br>
<br>
On 14/07/15 10:35, Alan Lord wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Tue Jul 14 09:22:14 2015,802 [16492] INFO VT - PearDatabase ->ADODB<br>
error  Query Failed:<br>
select<br>
sum(libertus_lstourdetailscf.cf_964) 'LSTourDetails_Sales_Volume_SUM',<br>
sum(libertus_lstourdetails.giftvalue)<br>
'LSTourDetails_LSTOURDETAILS_GIFT_VALUE_SUM',<br>
sum(libertus_lstourdetails.depositamnt)<br>
'LSTourDetails_LSTOURDETAILS_DEPOSIT_AMOUNT_SUM'<br>
from libertus_lstourfamilies<br>
inner join vtiger_crmentity<br>
     on vtiger_crmentity.crmid=libertus_lstourfamilies.lstourfamiliesid<br>
left join vtiger_groups<br>
     on vtiger_groups.groupid = vtiger_crmentity.smownerid<br>
left join vtiger_users<br>
     on <a href="http://vtiger_users.id" rel="noreferrer" target="_blank">vtiger_users.id</a> = vtiger_crmentity.smownerid<br>
left join vtiger_reptmptbl_155a4d4c10fe3d6686545900 as<br>
libertus_lstourdetails<br>
     on<br>
libertus_lstourdetails.lstourfamiliesid=libertus_lstourfamilies.lstourfamiliesid<br>
<br>
left join vtiger_crmentity as vtiger_crmentityLSTourDetails<br>
     on vtiger_crmentityLSTourDetails.crmid =<br>
libertus_lstourdetails.lstourdetailsid AND<br>
vtiger_crmentityLSTourDetails.deleted=0<br>
left join libertus_lstourdetailscf as libertus_lstourdetailscf<br>
     on<br>
libertus_lstourdetailscf.lstourdetailsid=libertus_lstourdetails.lstourdetailsid<br>
<br>
left join vtiger_crmentity as vtiger_crmentityRelLSTourDetails1103<br>
     on vtiger_crmentityRelLSTourDetails1103.crmid =<br>
libertus_lstourdetails.resortid and<br>
vtiger_crmentityRelLSTourDetails1103.deleted=0<br>
left join *vtiger_account* as<br>
vtiger_accountRelLSTourDetails                         <<<<<< 1st Alias<br>
here<br>
     on vtiger_accountRelLSTourDetails.accountid =<br>
vtiger_crmentityRelLSTourDetails1103.crmid<br>
left join vtiger_crmentity as vtiger_crmentityRelLSTourDetails1105<br>
     on vtiger_crmentityRelLSTourDetails1105.crmid =<br>
libertus_lstourdetails.contactid and<br>
vtiger_crmentityRelLSTourDetails1105.deleted=0<br>
left join vtiger_contactdetails as vtiger_contactdetailsRelLSTourDetails<br>
     on vtiger_contactdetailsRelLSTourDetails.contactid =<br>
vtiger_crmentityRelLSTourDetails1105.crmid<br>
left join *vtiger_account* as<br>
vtiger_accountRelLSTourDetails                         <<<<< 2nd Alias here<br>
     on vtiger_accountRelLSTourDetails.accountid =<br>
vtiger_crmentityRelLSTourDetails1117.crmid<br>
WHERE libertus_lstourfamilies.lstourfamiliesid > 0  AND<br>
vtiger_crmentity.deleted=0 and (( libertus_lstourdetails.tourdate<br>
BETWEEN '2015-07-06' AND '2015-07-12' ) )  ::->[1066]Not unique<br>
table/alias: 'vtiger_accountRelLSTourDetails'<br>
</blockquote>
<br>
<br></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>