Dolibarr ERP & CRM » Bugs » bug #1037 CONSUMPTION> SUPPLIER INVOICES RELATEDAnonymous user
2013-10-05 14:16
Answer now
Snapshot Details |
Last Modified On: | 2013-08-21 12:12 | | Submitted by: | Andriolo Hubert (hubz) |
Submitted on: | 2013-08-13 16:55 | |
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- michael kors handbags 2013-10-05 14:16
- <a href="" href="http://outlettoms.net">where" target="_blank" target="_new">http://outlettoms.net">where is toms shoe outlet real</a><a href="" href="http://www.tomsoutletstore.biz">toms" target="_blank" target="_new">http://www.tomsoutletstore.biz">toms outlet shoe store</a><a href="" href="http://www.ralphlaurenpoloaustralia2013.com/">Ralph" target="_blank" target="_new">http://www.ralphlaurenpoloaustralia2013.com/">Ralph Lauren Hats</a><a href="" href="http://tomsoutletstore.sensapedicmattresses.com">toms" target="_blank" target="_new">http://tomsoutletstore.sensapedicmattresses.com">toms outlet online</a><a href="" href="http://www.cirnos.net/arak/">hogan" target="_blank" target="_new">http://www.cirnos.net/arak/">hogan outlet</a><a href="" href="http://www.longchampsale2014.net"><em>nike" target="_blank" target="_new">http://www.longchampsale2014.net"><em>nike id</em></a>
- 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 |
|