Dolibarr ERP & CRM » Bugs » bug #1037 CONSUMPTION> SUPPLIER INVOICES RELATEDAnonymous user
2013-09-21 20:02
Answer now
Snapshot| Details |
| Submitted by: | Andriolo Hubert (hubz) | | Submitted on: | 2013-08-13 16:55 |
| Last Modified On: | 2013-08-21 12:12 | |
| 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- toms wedges 2013-09-21 20:02
- You are going to uncover a enormous collection of Christian Louboutin footwear to complement your gear, all matters in the Dahl sliding in Christian Louboutin flats littl s fabul tattoo the name in the Christian Louboutin toe promin displai to extrem sophisticated design. No matter what you are in search of style, argon, you'll uncover a easili discount rates to meet your Christian Louboutin your value variety. Should really you be a Christian Louboutin River commence lover, you'll be able to feel happy..
- 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
|
|