Error in commit - Printable Version

+- CoreBOSBB (
+-- Forum: Development (
+--- Forum: coreBOS Development (
+---- Forum: coreBOS (
+---- Thread: Error in commit (/showthread.php?tid=23)

Error in commit - playman - 06-10-2014

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

Re: Error in commit - omarllorens - 06-11-2014

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 -->