Salut à tous,
La requête de la méthode nb_expéditions() de
commande/class/commande.class.php provoque une erreur SQL "query SQL
error: SELECT count(*) FROM llx_expedition as e WHERE e.fk_commande = 30
DB_ERROR_NOSUCHFIELD"
Correction:
remplacer la requête
$sql = 'SELECT count(*) FROM '.MAIN_DB_PREFIX.'expedition as e';
$sql .=" WHERE e.fk_commande = ".$this->id;
par
$sql = 'SELECT count(*) FROM '.MAIN_DB_PREFIX.'expedition as e';
$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."element_element as el ON
el.fk_target = e.rowid AND el.targettype = 'shipping' ";
$sql .=" WHERE el.fk_source = ".$this->id;
@+
Jean
_______________________________________________
Dolibarr-dev mailing list
[email protected]
http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
