<div dir="ltr"><div><div dir="ltr"><span style="color:rgb(102,102,102);font-family:verdana,sans-serif"><font color="#000000">Mariusz Krzaczkowski,</font></span></div><div dir="ltr"><span style="color:rgb(102,102,102);font-family:verdana,sans-serif"><font color="#000000"><br>
</font></span></div><div dir="ltr"><span style="color:rgb(102,102,102);font-family:verdana,sans-serif"><font color="#000000">Thanks for reporting the issue, I filed this issue in trac.</font></span></div><div dir="ltr"><span style="color:rgb(102,102,102);font-family:verdana,sans-serif"><font color="#000000"><br>
</font></span></div><div dir="ltr"><a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7713">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7713</a><span style="color:rgb(102,102,102);font-family:verdana,sans-serif"><font color="#000000"><br>
<br>I have escalated this issue into our QA team. I will update you the status soon.<br><br><br></font><span style="font-family:verdana,sans-serif">Thanks,</span></span><br style="font-family:verdana,sans-serif"><font style="background-color:rgb(255,255,255);color:rgb(0,0,0)"><span style="font-family:verdana,sans-serif">Apparao G</span></font><br>
<br style="font-family:verdana,sans-serif"><b style="color:rgb(51,51,51);background-color:rgb(255,255,255)"><font style="font-family:verdana,sans-serif;color:rgb(102,102,102)"><img src="https://gpmb7.vtiger.com/test/logo/vt1.PNG" height="24" width="96"><font size="1">TEAM</font></font></b><br>
<br><b style="font-family:verdana,sans-serif">Connect with us on: </b><a style="font-family:verdana,sans-serif" href="http://vtiger.com/" target="_blank">Website</a><b style="font-family:verdana,sans-serif"> </b><b style="font-family:verdana,sans-serif">I</b><span style="font-family:verdana,sans-serif"> </span><a style="font-family:verdana,sans-serif" href="http://twitter.com/#%21/vtigercrm" target="_blank">Twitter</a><span style="font-family:verdana,sans-serif"> </span><b style="font-family:verdana,sans-serif">I</b><span style="font-family:verdana,sans-serif"> </span><a style="font-family:verdana,sans-serif" href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" target="_blank">Facebook</a><span style="font-family:verdana,sans-serif"> </span><b style="font-family:verdana,sans-serif">I</b><span style="font-family:verdana,sans-serif"> </span><a style="font-family:verdana,sans-serif" href="http://blog.vtiger.com/" target="_blank">Blog</a><b style="font-family:verdana,sans-serif"> I</b><span style="font-family:verdana,sans-serif"> </span><a style="font-family:verdana,sans-serif" href="http://wiki.vtiger.com/index.php/Main_Page" target="_blank">Wiki</a><span style="font-family:verdana,sans-serif"> </span><b style="font-family:verdana,sans-serif">I </b><a style="font-family:verdana,sans-serif" href="http://forums.vtiger.com/" target="_blank">Forums </a><span style="font-family:verdana,sans-serif"> </span><br>
<span style="color:rgb(102,102,102)"><span></span><b><span></span></b></span></div></div>
<br><br><div class="gmail_quote">On Tue, Jul 23, 2013 at 6:13 PM, Mariusz Krzaczkowski <span dir="ltr"><<a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="display:inline!important"><div>Hi</div><div><br></div><div>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:</div>
</div></div><div><b><div style="display:inline!important"><b><br></b></div></b></div><div><span style="color:rgb(51,51,51);font-family:'Lucida Grande',Tahoma,sans-serif;line-height:16px;background-color:rgb(251,253,255)"><font size="1">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=<a href="http://vtiger_users.id" target="_blank">vtiger_users.id</a> 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=<a href="http://vtiger_users.id" target="_blank">vtiger_users.id</a> WHERE vtiger_troubletickets.ticketid > 0 AND vtiger_crmentity.deleted=0 LIMIT 0, 1000::->Unknown column 'vtiger_limitynadaneRelHelpDesk703.wartosc' in 'field list'</font></span></div>
<div><span style="color:rgb(51,51,51);font-family:'Lucida Grande',Tahoma,sans-serif;font-size:12px;line-height:16px;background-color:rgb(251,253,255)"><br></span></div><div><span style="background-color:rgb(251,253,255);font-size:12px;line-height:16px"><font color="#333333" face="Lucida Grande, Tahoma, sans-serif">To view the error must be set var $ dieOnError = true;</font></span></div>
<div><font color="#333333" face="Lucida Grande, Tahoma, sans-serif"><span style="font-size:12px;line-height:16px">Issue exists only with new fields of uitype 10, does anyone know how to fix this error?</span></font></div>
<div><br></div><div><b><div style="display:inline!important"><b>Z poważaniem / <span style="font-size:10pt">Best regards</span></b></div></b></div><span class="HOEnZb"><font color="#888888"><div><div><b>Mariusz Krzaczkowski</b> <b><br>
</b></div><div><b><a href="mailto:m.krzaczkowski@opensaas.pl" target="_blank">m.krzaczkowski@opensaas.pl</a><br>
<br></b></div></div>
</font></span><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>