[Vtigercrm-developers] Bug in reports

Mariusz Krzaczkowski m.krzaczkowski at opensaas.pl
Tue Jul 23 12:43:01 UTC 2013


Hi

I found bug in reports on vtiger version 6 (revision 13878) after adding of
a new field of uitype 10 in HelpDesk module and the field will try to show
in the report there is an error:
*

*
Query Failed:select DISTINCT vtiger_troubletickets.title AS
'HelpDesk_Title', vtiger_troubletickets.status AS 'HelpDesk_Status',
vtiger_troubletickets.priority AS 'HelpDesk_Priority', (CASE WHEN
vtiger_troubletickets.limitynadaneid2 NOT LIKE '' THEN (CASE WHEN
vtiger_limitynadaneRelHelpDesk703.wartosc NOT LIKE '' THEN
vtiger_limitynadaneRelHelpDesk703.wartosc ELSE '' END) ELSE '' END) AS
HelpDesk_LimityNadane2, vtiger_crmentity.crmid AS "HelpDesk_LBL_ACTION"
from vtiger_troubletickets inner join vtiger_crmentity on
vtiger_crmentity.crmid=vtiger_troubletickets.ticketid left join
vtiger_groups on vtiger_groups.groupid = vtiger_crmentity.smownerid left
join vtiger_users on vtiger_crmentity.smownerid=vtiger_users.id WHERE
vtiger_troubletickets.ticketid > 0 AND vtiger_crmentity.deleted=0 LIMIT 0,
1000::ADODB error Query Failed:select DISTINCT vtiger_troubletickets.title
AS 'HelpDesk_Title', vtiger_troubletickets.status AS 'HelpDesk_Status',
vtiger_troubletickets.priority AS 'HelpDesk_Priority', (CASE WHEN
vtiger_troubletickets.limitynadaneid2 NOT LIKE '' THEN (CASE WHEN
vtiger_limitynadaneRelHelpDesk703.wartosc NOT LIKE '' THEN
vtiger_limitynadaneRelHelpDesk703.wartosc ELSE '' END) ELSE '' END) AS
HelpDesk_LimityNadane2, vtiger_crmentity.crmid AS "HelpDesk_LBL_ACTION"
from vtiger_troubletickets inner join vtiger_crmentity on
vtiger_crmentity.crmid=vtiger_troubletickets.ticketid left join
vtiger_groups on vtiger_groups.groupid = vtiger_crmentity.smownerid left
join vtiger_users on vtiger_crmentity.smownerid=vtiger_users.id WHERE
vtiger_troubletickets.ticketid > 0 AND vtiger_crmentity.deleted=0 LIMIT 0,
1000::->Unknown column 'vtiger_limitynadaneRelHelpDesk703.wartosc' in
'field list'

To view the error must be set var $ dieOnError = true;
Issue exists only with new fields of uitype 10, does anyone know how to fix
this error?

*
Z poważaniem / Best regards
*
*Mariusz Krzaczkowski* *
*
*m.krzaczkowski at opensaas.pl

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130723/742086a2/attachment.html>


More information about the vtigercrm-developers mailing list