To the vtiger 4.2.4 mainteneers

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

To the vtiger 4.2.4 mainteneers

Abos
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
_______________________________________________
This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt