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

[Matteo Baranzoni]

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



> Message: 2
> Date: Thu, 16 Aug 2012 11:02:55 -0400
> From: Adam Heinz <amh at metricwise.net>
> Subject: Re: [Vtigercrm-developers] Edit invoice: page blank!
> To: vtigercrm-developers at lists.vtigercrm.com
> Message-ID:
>         <
> CAKBdvM_gwkk6dd3ytTCpWUrTdN-qSz7NPBfFA0VqfBmP9-BYDA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Notice the dot before conversion_rate?  It's expecting table.column,
> but table is missing.  Can you give a stack trace and vtiger version?
>
> On Thu, Aug 16, 2012 at 10:57 AM, Matteo Baranzoni
> <barra at greenbitweb.com> wrote:
> > Query Failed:select currency_id, .conversion_rate as conv_rate,
>
>
> ------------------------------
>
> _______________________________________________
> vtigercrm-developers mailing list
> vtigercrm-developers at lists.vtigercrm.com
> http://lists.vtigercrm.com/mailman/listinfo/vtigercrm-developers
>
>
> End of vtigercrm-developers Digest, Vol 79, Issue 21
> ****************************************************
>



-- 
Matteo Baranzoni - Greenbit WEB

*:: Avvertenze Legali ::*
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).
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20120816/87640cca/attachment.html