Thanks for help.<div>Actually I dont't have access to trac <span id="result_box" class="short_text" lang="en"><span class="hps">but I</span> <span class="hps alt-edited">just requested an</span> <span class="hps">access</span></span>.<br>
<span id="result_box" class="short_text" lang="en"><span class="hps">I </span><span class="hps">report the bug</span> <span class="hps">as soon as possible</span><span class="">.</span></span><br><br><div class="gmail_quote">
2012/8/17 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<a href="http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/utils/EditViewUtils.php#L1045" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/utils/EditViewUtils.php#L1045</a><br>
<br>
$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);<br>
<br>
You can see from the stack trace that $module is NULL... because that<br>
variable is wrong, it should be $module_name. So just change that one<br>
line and I think that will fix it for you. Would you please open a<br>
bug for this?<br>
<div><br>
On Thu, Aug 16, 2012 at 3:32 PM, Matteo Baranzoni <<a href="mailto:barra@greenbitweb.com" target="_blank">barra@greenbitweb.com</a>> wrote:<br>
> Vtiger version 5.4.0<br>
> This from mysql debug:<br>
><br>
>> 1064: You have an error in your SQL syntax; check the manual that<br>
>> corresponds to your MySQL server version for the right syntax to use near<br>
>> 'as conv_rate, vtiger_currency_info.* from inner join vtiger_currency_info'<br>
>> at line 1<br>
>><br>
>> ADOConnection._Execute(select currency_id,<br>
>> .conversion_rate as conv_rate, vtiger_currency_info.* from<br>
>> inner join vtiger_currency_info on .curren...) % line 842, file:<br>
>> adodb.inc.php<br>
>> ADOConnection.Execute(select currency_id, .conversion_rate<br>
>> as conv_rate, vtiger_currency_info.* from<br>
>> inner join vtiger_currency_info on .curren..., Array[1]) % line<br>
>> 468, file: PearDatabase.php<br>
>> PearDatabase.pquery(select currency_id, .conversion_rate as<br>
>> conv_rate, vtiger_currency_info.* from<br>
>> inner join vtiger_currency_info on .curren..., Array[1]) % line<br>
>> 774, file: InventoryUtils.php<br>
>> getInventoryCurrencyInfo(null, 560) % line 1045, file:<br>
>> EditViewUtils.php<br>
>> getOutputHtml(72, cf_792, Ritenuta acconto al 20%, 100, Array[38],<br>
>> 2, Invoice, edit, V~O~LE~10) % line 1957, file: EditViewUtils.php<br>
</div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Matteo Baranzoni - Greenbit WEB<br><br><font style="color:rgb(153,153,153)" size="1"><b>:: Avvertenze Legali ::</b><br>Questa email, e ogni eventuale allegato, è a uso esclusivo della Persona o della Società/Ente a cui è indirizzato e potrebbe contenere informazioni riservate. Se avete ricevuto questa email per errore, ci scusiamo per l'accaduto e Vi preghiamo cortesemente di darcene sollecita comunicazione e a cancellare l'email e ogni eventuale allegato. Vi ricordiamo che l'utilizzo, la conservazione, la distribuzione e/o la diffusione dei dati ricevuti per errore costituiscono violazioni alle disposizioni del D.Lgs. 196/03 (Codice della Privacy).<br>
This e-mail, and any attachment, is for the intended recipient only and is confidential. If this e-mail has been misdirected, please let the sender know and delete it with any attachment, thanks. Any disclosure, copying, distribution is prohibited</font><br>
<br><br>
</div>