Dolibarr/dolibarr — pull request #327 by marcosgdf (2012-08-18 16:47:52+00:00)
Title: Fixed a SQL error when listing lines of an invoice

facture Error sql=SELECT l.rowid, l.description, l.fk_product, l.product_type, l.qty, l.tva_tx, l.fk_remise_except, localtax1_tx, localtax2_tx, l.remise_percent, l.subprice, l.info_bits, l.rang, l.special_code, l.fk_parent_line, l.total_ht, l.total_tva, l.total_ttc, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.date_start, l.date_end, p.ref as product_ref, p.fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product p ON l.fk_product=p.rowid WHERE l.fk_facture = 9 ORDER BY l.rang ASC, l.rowid, error=Column 'localtax1_tx' in field list is ambiguous