Dolibarr ERP & CRM » Bugs » bug #1037 CONSUMPTION> SUPPLIER INVOICES RELATEDLatest modifications
Answer now
Snapshot| Details |
| Submitted on: | 2013-08-13 16:55 | | Last Modified On: | 2013-08-19 09:47 |
| Submitted by: | Andriolo Hubert (hubz) | |
| Summary: | CONSUMPTION> SUPPLIER INVOICES RELATED |
| Description: | On the "consumption" side of a product, there is an error when trying to access "related products invoiced from a customer"
/product/stats/facture_fournisseur.php
Unknown column 'f.facnumber' in 'field list' |
| Step to reproduce bug: | Go to a product fiche :
/product/fiche.php
then on product stats "consumption"
/product/stats/facture.php
and clic on Supplier invoices
You will get :
Requête dernier accès en base en erreur: SELECT distinct s.nom, s.rowid as socid, s.code_client, f.facnumber, f.total_ht as total_ht, f.datef, f.paye, f.fk_statut as statut, f.rowid as facid FROM llx_societe as s, llx_facture_fourn as f, llx_facture_fourn_det as d WHERE f.fk_soc = s.rowid AND f.entity = 1 AND d.fk_facture_fourn = f.rowid AND d.fk_product =2897 ORDER BY f.datef DESC LIMIT 51
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base en erreur: Unknown column 'f.facnumber' in 'field list'
|
| Version: | 3.4.0 | | Category: | Module: Supplier Invoice |
| Severity: | 6 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | Date: 20130813165334 Dolibarr: 3.4.0 Niveau de fonctionnalités: 0 PHP: 5.3.3-1ubuntu9.10 Server: Apache/2.2.16 (Ubuntu) |
| Status |
| Status: | Open | | Assigned to: | Juanjo Menent (simnandez) |
| Resolution: | Fixed | |
Comments- Juanjo Menent 2013-08-21 12:11
- Fixed for next minor release 3.4.1
- Andriolo Hubert 2013-08-19 09:47
- LINK TO THE DEMO SHOWING THE PROBLEM
http://demo.dolibarr.org/product/stats/facture_fournisseur.php?id=13
|
|
None→ Juanjo Menent (simnandez)None→ Fixed