<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><h2 class="issue-title" style="box-sizing: border-box; line-height: 1.1; margin-top: 0px; margin-bottom: 10px; font-variant-ligatures: normal; orphans: 2; widows: 2; background-color: rgb(255, 255, 255);"><font color="#222222" face="Helvetica Neue, Helvetica, Arial, sans-serif" class=""><span style="font-size: 15px; font-weight: normal;" class="">Hello all. </span></font></h2><h2 class="issue-title" style="box-sizing: border-box; line-height: 1.1; margin-top: 0px; margin-bottom: 10px; font-variant-ligatures: normal; orphans: 2; widows: 2; background-color: rgb(255, 255, 255);"><font color="#222222" face="Helvetica Neue, Helvetica, Arial, sans-serif" class=""><span style="font-size: 15px; font-weight: normal;" class="">I</span><span style="caret-color: rgb(34, 34, 34); font-size: 15px; font-weight: normal;" class="">’</span><span style="font-size: 15px; font-weight: normal;" class="">m trying some luck here because I don’t think in track will get any review of the bug</span></font></h2><h2 class="issue-title" style="box-sizing: border-box; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(34, 34, 34); margin-top: 0px; margin-bottom: 10px; font-size: 30px; font-variant-ligatures: normal; orphans: 2; widows: 2; background-color: rgb(255, 255, 255);">Bad Relation products if to helpdesk vt 6.5</h2><div style="box-sizing: border-box; color: rgb(34, 34, 34); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; font-variant-ligatures: normal; orphans: 2; widows: 2; background-color: rgb(255, 255, 255);" class=""><div class="js-task-list-container is-task-list-enabled description" style="box-sizing: border-box;"><div class="wiki" style="box-sizing: border-box; font-size: 15px; line-height: 1.5; overflow-wrap: break-word;"><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">Steps to reproduce:</p><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">1- Manual relate Products to Tickets</p><pre class="code highlight white plaintext" style="box-sizing: border-box; overflow: auto; font-family: Menlo, "Liberation Mono", Consolas, "DejaVu Sans Mono", "Ubuntu Mono", "Courier New", "andale mono", "lucida console", monospace; font-size: 13px; padding: 9.5px; margin-top: 0px; margin-bottom: 9px; line-height: 1.42857; word-break: break-all; overflow-wrap: break-word; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204); border-top-left-radius: 4px; border-top-right-radius: 4px; border-bottom-right-radius: 4px; border-bottom-left-radius: 4px; text-shadow: none;"><code style="box-sizing: border-box; font-family: Menlo, "Liberation Mono", Consolas, "DejaVu Sans Mono", "Ubuntu Mono", "Courier New", "andale mono", "lucida console", monospace; font-size: inherit; padding: 0px; color: inherit; background-color: transparent; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; overflow-wrap: normal; margin-top: 0px;" class=""><?php
ini_set('display_errors','on'); error_reporting(E_ALL); // STRICT DEVELOPMENT
// Turn on debugging level
$Vtiger_Utils_Log = true;
// Include necessary classes
include_once 'vtlib/Vtiger/Module.php';
$moduleInstance = Vtiger_Module::getInstance('HelpDesk');
if ($moduleInstance) {
$productsModule = Vtiger_Module::getInstance('Products');
$relationLabel = 'Products';
$moduleInstance->setRelatedList($productsModule, $relationLabel, Array('ADD', 'SELECT'), 'get_related_list');
}
</code></pre><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">2 - Create new product and go to Tickets and select that product, all ok without customizations.</p><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">3 - Go to Products Edit Fields and add new custom field - set that field to Summary View.</p><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">4 - Go to Ticket and related products and you will see an empty related products list with this error: Unknown column 'vtiger_productcf.cf_772' in 'field list'</p><p style="box-sizing: border-box; margin: 0px 0px 10px;" class="">(in order to get this info must set PearDatabase.php $dieOnError = true;)</p><pre class="code highlight white plaintext" style="box-sizing: border-box; overflow: auto; font-family: Menlo, "Liberation Mono", Consolas, "DejaVu Sans Mono", "Ubuntu Mono", "Courier New", "andale mono", "lucida console", monospace; font-size: 13px; padding: 9.5px; margin-top: 0px; margin-bottom: 9px; line-height: 1.42857; word-break: break-all; overflow-wrap: break-word; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204); border-top-left-radius: 4px; border-top-right-radius: 4px; border-bottom-right-radius: 4px; border-bottom-left-radius: 4px; text-shadow: none;"><code style="box-sizing: border-box; font-family: Menlo, "Liberation Mono", Consolas, "DejaVu Sans Mono", "Ubuntu Mono", "Courier New", "andale mono", "lucida console", monospace; font-size: inherit; padding: 0px; color: inherit; background-color: transparent; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; overflow-wrap: normal; margin-top: 0px;" class="">Query Failed:SELECT DISTINCT vtiger_crmentity.crmid,vtiger_products.productname, vtiger_products.productcode, vtiger_productcf.cf_772, vtiger_products.unit_price, vtiger_products.commissionrate, vtiger_products.qty_per_unit FROM vtiger_products INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_products.productid INNER JOIN vtiger_crmentityrel ON (vtiger_crmentityrel.relcrmid = vtiger_crmentity.crmid OR vtiger_crmentityrel.crmid = vtiger_crmentity.crmid) LEFT JOIN vtiger_users ON <a href="http://vtiger_users.id" class="">vtiger_users.id</a> = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND (vtiger_crmentityrel.crmid = 5 OR vtiger_crmentityrel.relcrmid = 5) LIMIT 0,20::ADODB error Query Failed:SELECT DISTINCT vtiger_crmentity.crmid,vtiger_products.productname, vtiger_products.productcode, vtiger_productcf.cf_772, vtiger_products.unit_price, vtiger_products.commissionrate, vtiger_products.qty_per_unit FROM vtiger_products INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_products.productid INNER JOIN vtiger_crmentityrel ON (vtiger_crmentityrel.relcrmid = vtiger_crmentity.crmid OR vtiger_crmentityrel.crmid = vtiger_crmentity.crmid) LEFT JOIN vtiger_users ON <a href="http://vtiger_users.id" class="">vtiger_users.id</a> = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND (vtiger_crmentityrel.crmid = 5 OR vtiger_crmentityrel.relcrmid = 5) LIMIT 0,20::->Unknown column 'vtiger_productcf.cf_772' in 'field list'</code></pre></div></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Best Regards.</div><div class=""><br class=""></div><div class="">Manuel</div></body></html>