Full Version: Error in commit
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,

The following commit has an error, when you are trying to generate a Report, the query fails:

<!-- m --><a class="postlink" href=""> ... 3ec5ae761f</a><!-- m -->

the solution is add a space at start like this (between $query = and " left join...):

left join vtiger_currency_info as vtiger_currency_info$secmodule on vtiger_currency_info$ = vtiger_salesorder.currency_id";
if(($type !== 'COLUMNSTOTOTAL') || ($type == 'COLUMNSTOTOTAL' && $where_condition == 'add'))
       $query .=" left join vtiger_inventoryproductrel as vtiger_inventoryproductrelSalesOrder on vtiger_salesorder.salesorderid = left join vtiger_products as vtiger_productsSalesOrder on vtiger_productsSalesOrder.productid = vtiger_inventoryproductrelSalesOrder.productid left join vtiger_service as vtiger_serviceSalesOrder on vtiger_serviceSalesOrder.serviceid = vtiger_inventoryproductrelSalesOrder.productid";
$query .=" left join vtiger_groups as vtiger_groupsSalesOrder on vtiger_groupsSalesOrder.groupid = vtiger_crmentitySalesOrder.smownerid
Hi playman.

You have reason, we had this error in PurchaseOrder, SalesOrder and Quotes.

The commit was fixed and updated.

Thanks for find this bug. <!-- sBig Grin --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="Big Grin" title="Very Happy" /><!-- sBig Grin -->