[Dolibarr-bugtrack] [bug #32794] Problèmeà l'encodage des paiements avec PostgreSQL

[anonymous]

URL:
  <http://savannah.nongnu.org/bugs/?32794>

                 Summary: Problème à l'encodage des paiements avec
PostgreSQL
                 Project: Dolibarr
            Submitted by: None
            Submitted on: mar. 15 mars 2011 19:16:46 UTC
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: CVS-DEV
        Operating System: GNU/Linux

    _______________________________________________________

Details:

Sur la 3.0.0-rc1 (23/2), avec PostgreSQL, lors de l'une ligne à une commande
ou facture, on reçoit un msg d'erreur et le log suivant :

2011-03-11 19:22:08 UTC STATEMENT:  UPDATE llx_commandedet SET
description='*****',price='100000',subprice='100000',remise='0',remise_percent='0',tva_tx='0',localtax1_tx='',localtax2_tx='',qty='3',product_type='1',info_bits='0',total_ht='300000',total_tva='0',total_localtax1='0',total_localtax2='0',total_ttc='300000',date_start='2011-03-16
00:00:00',date_end='2011-03-18 00:00:00' WHERE rowid = 1
2011-03-11 19:33:24 UTC ERROR:  invalid input syntax for type real: "" at
character ***


Le patch ci-après résout le problème.

--- dolibarr-3.0.0-rc1/htdocs/lib//functions.lib.php    2011-02-26
05:11:12.000000000 +0000
+++ dolibarr-sa/htdocs/lib/functions.lib.php    2011-03-15 19:00:47.000000000
+0000
@@ -2626,6 +2626,8 @@
 {
        global $langs,$conf;
 
+       // Clean parameters
+       if (empty($amount)) $amount=0;  // To have a numeric value if amount not
defined or = ''
        // Round PHP function does not allow number like '1,234.56' nor 
'1.234,56'
nor '1 234,56'
        // Numbers must be '1234.56'
        // Decimal delimiter for PHP and database SQL requests must be '.'





    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?32794>

_______________________________________________
  Message posté via/par Savannah
  http://savannah.nongnu.org/