[Vtigercrm-developers] Bug in reports

[Appu]

Mariusz Krzaczkowski,

Thanks for reporting the issue, I filed this issue in trac.

http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7713

I have escalated this issue into our QA team. I will update you the status
soon.


Thanks,
Apparao G

*TEAM*

*Connect with us on: *Website <http://vtiger.com/>* **I*
Twitter<http://twitter.com/#%21/vtigercrm>
*I* Facebook <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
*I* Blog <http://blog.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <http://forums.vtiger.com/>
**


On Tue, Jul 23, 2013 at 6:13 PM, Mariusz Krzaczkowski <
m.krzaczkowski at opensaas.pl> wrote:

> 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
>
> *
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130723/5e918d67/attachment.html>