I have pushed a fix into 3.5 branch today. Test is however required... Le 10/03/2014 22:30, Marcos García a écrit : > Hi all, > > A dolibarr.es <http://dolibarr.es> forum user is complaining about a > SQL error that appeared once migrated to 3.5.0 from 3.4.2. > > The error is the following one: > > Dolibarr ha detectado un error técnico. > He aquí la información que podrá ayudar al diagnóstico: > Fecha: 20140306003055 > Dolibarr: 3.5.0 > Nivel de funciones: 0 > PHP: 5.3.0 > Server: Apache/2.2.11 (Win32) PHP/5.3.0 > > URL solicitada: /dolibarr/margin/productMargins.php > Referer: localhost:8080/dolibarr/margin/customerMargins.php > <http://localhost:8080/dolibarr/margin/customerMargins.php> > Gestor de menú: eldy_menu.php > > Tipo de gestor de base de datos: mysqli > Petición último acceso a la base de datos erróneo: SELECT p.label, > p.rowid, p.fk_product_type, p.ref, d.fk_product, f.rowid as facid, > f.facnumber, f.total as total_ht, f.datef, f.paye, f.fk_statut as > statut, sum(d.total_ht) as selling_price, sum(IF(d.total_ht <=0,d.qty > * d.buy_price_ht * -1,d.qty * d.buy_price_ht)) as buying_price, > sum(IF(d.total_ht <=0,-1 * (abs(d.total_ht) - (d.buy_price_ht * > d.qty)),d.total_ht - (d.buy_price_ht * d.qty))) as marge FROM > llx_societe as s, llx_product as p, llx_facture as f, llx_facturedet > as d WHERE f.entity = 1 AND f.fk_soc = s.rowid AND d.fk_product = > p.rowid AND f.fk_statut > 0 AND d.fk_facture = f.rowid AND > d.buy_price_ht IS NOT NULL AND d.buy_price_ht <> 0 ORDER BY p.ref ASC > Código devuelto último acceso a la base de datos erróneo: DB_ERROR_1140 > Información sobre el último acceso a la base de datos erróneo: Mixing > of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is > illegal if there is no GROUP BY clause > > Do you guys have got any clue to debug this problem? > > Regards, > > > *Marcos García* > > marcos...@gmail.com <mailto:marcos...@gmail.com> > > > > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
-- Eldy (Laurent Destailleur). EMail: e...@destailleur.fr Web: http://www.destailleur.fr Dolibarr (Project leader): http://www.dolibarr.org To make a donation for Dolibarr project via Paypal: cont...@destailleur.fr AWStats (Author) : http://awstats.sourceforge.net To make a donation for AWStats project via Paypal: cont...@destailleur.fr AWBot (Author) : http://awbot.sourceforge.net CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
