[Vtigercrm-developers] To the vtiger 4.2.4 mainteneers

Abos webmaster at vtigercrmfrance.org
Mon Apr 3 04:23:56 PDT 2006


Hi team,
in 4.x branches (the 5.x branches work correctly), when we create a 
customview with customfields, we obtain an peardatabase error this is a 
beginning of fix posted by raccoon on french forum :

on utils.php search for :
function getListQuery($module,$where='')

replace the query :
$query = "select crmentity.*, quotes.*, quotesbillads.*, 
quotesshipads.*,potential.potentialname,account.accountname from quotes 
inner join crmentity on crmentity.crmid=quotes.quoteid inner join 
quotesbillads on quotes.quoteid=quotesbillads.quotebilladdressid inner 
join quotesshipads on quotes.quoteid=quotesshipads.quoteshipaddressid 
left outer join account on account.accountid=quotes.accountid left outer 
join potential on potential.potentialid=quotes.potentialid where 
crmentity.deleted=0".$where;

by this one :
( left join quotescf on quotes.quoteid = quotescf.quoteid added for 
module quotes)

$query = "select crmentity.*, quotes.*, quotesbillads.*, 
quotesshipads.*,potential.potentialname,account.accountname from quotes 
inner join crmentity on crmentity.crmid=quotes.quoteid inner join 
quotesbillads on quotes.quoteid=quotesbillads.quotebilladdressid inner 
join quotesshipads on quotes.quoteid=quotesshipads.quoteshipaddressid 
left outer join account on account.accountid=quotes.accountid left outer 
join potential on potential.potentialid=quotes.potentialid left join 
quotescf on quotes.quoteid = quotescf.quoteid where crmentity.deleted=0 
".$where;


in v5, you can find the query in /includes/utils/ListViewUtils.php.
Thanks



More information about the vtigercrm-developers mailing list