[Vtigercrm-developers] vtigercrm-developers Digest, Vol 79, Issue 21

[Adam Heinz]

http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/utils/EditViewUtils.php#L1045

$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);

You can see from the stack trace that $module is NULL... because that
variable is wrong, it should be $module_name.  So just change that one
line and I think that will fix it for you.  Would you please open a
bug for this?

On Thu, Aug 16, 2012 at 3:32 PM, Matteo Baranzoni <barra at greenbitweb.com> wrote:
> Vtiger version 5.4.0
> This from mysql debug:
>
>> 1064: You have an error in your SQL syntax; check the manual that
>> corresponds to your MySQL server version for the right syntax to use near
>> 'as conv_rate, vtiger_currency_info.* from inner join vtiger_currency_info'
>> at line 1
>>
>>                   ADOConnection._Execute(select currency_id,
>> .conversion_rate as conv_rate, vtiger_currency_info.* from
>> 						inner join vtiger_currency_info on .curren...) % line  842, file:
>> adodb.inc.php
>>                ADOConnection.Execute(select currency_id, .conversion_rate
>> as conv_rate, vtiger_currency_info.* from
>> 						inner join vtiger_currency_info on .curren..., Array[1]) % line
>> 468, file: PearDatabase.php
>>             PearDatabase.pquery(select currency_id, .conversion_rate as
>> conv_rate, vtiger_currency_info.* from
>> 						inner join vtiger_currency_info on .curren..., Array[1]) % line
>> 774, file: InventoryUtils.php
>>          getInventoryCurrencyInfo(null, 560) % line 1045, file:
>> EditViewUtils.php
>>       getOutputHtml(72, cf_792, Ritenuta acconto al 20%, 100, Array[38],
>> 2, Invoice, edit, V~O~LE~10) % line 1957, file: EditViewUtils.php