Vtiger version 5.4.0<br>This from mysql debug:<br><br><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">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<br>
<pre align="left"> <font face="Courier New,Courier">ADOConnection._Execute(select currency_id, .conversion_rate as conv_rate, vtiger_currency_info.* from
inner join vtiger_currency_info on .curren...)</font><font color="#808080" size="-1"> % line 842, file: <a>adodb.inc.php</a></font>
<font face="Courier New,Courier">ADOConnection.Execute(select currency_id, .conversion_rate as conv_rate, vtiger_currency_info.* from
inner join vtiger_currency_info on .curren..., Array[1])</font><font color="#808080" size="-1"> % line 468, file: <a>PearDatabase.php</a></font>
<font face="Courier New,Courier">PearDatabase.pquery(select currency_id, .conversion_rate as conv_rate, vtiger_currency_info.* from
inner join vtiger_currency_info on .curren..., Array[1])</font><font color="#808080" size="-1"> % line 774, file: <a>InventoryUtils.php</a></font>
<font face="Courier New,Courier">getInventoryCurrencyInfo(null, 560)</font><font color="#808080" size="-1"> % line 1045, file: <a>EditViewUtils.php</a></font>
<font face="Courier New,Courier">getOutputHtml(72, cf_792, Ritenuta acconto al 20%, 100, Array[38], 2, Invoice, edit, V~O~LE~10)</font><font color="#808080" size="-1"> % line 1957, file: <a>EditViewUtils.php</a></font>
</pre></blockquote><span id="result_box" class="" lang="en"><span class="hps"><br><br><br></span></span><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Message: 2<br>
Date: Thu, 16 Aug 2012 11:02:55 -0400<br>
From: Adam Heinz <<a href="mailto:amh@metricwise.net">amh@metricwise.net</a>><br>
Subject: Re: [Vtigercrm-developers] Edit invoice: page blank!<br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
Message-ID:<br>
<<a href="mailto:CAKBdvM_gwkk6dd3ytTCpWUrTdN-qSz7NPBfFA0VqfBmP9-BYDA@mail.gmail.com">CAKBdvM_gwkk6dd3ytTCpWUrTdN-qSz7NPBfFA0VqfBmP9-BYDA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1<br>
<br>
Notice the dot before conversion_rate? It's expecting table.column,<br>
but table is missing. Can you give a stack trace and vtiger version?<br>
<br>
On Thu, Aug 16, 2012 at 10:57 AM, Matteo Baranzoni<br>
<<a href="mailto:barra@greenbitweb.com">barra@greenbitweb.com</a>> wrote:<br>
> Query Failed:select currency_id, .conversion_rate as conv_rate,<br>
<br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
vtigercrm-developers mailing list<br>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
<a href="http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers" target="_blank">http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers</a><br>
<br>
<br>
End of vtigercrm-developers Digest, Vol 79, Issue 21<br>
****************************************************<br>
</blockquote></div><br><br clear="all"><br>-- <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>