[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Dolibarr-dev] correction requête sql expéditi on Dolibarr 3.0
From: |
address@hidden |
Subject: |
[Dolibarr-dev] correction requête sql expéditi on Dolibarr 3.0 |
Date: |
Mon, 18 Apr 2011 19:21:10 +0200 |
User-agent: |
Mozilla-Thunderbird 2.0.0.24 (X11/20100328) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Dolibarr-dev] correction requête sql expéditi on Dolibarr 3.0,
address@hidden <=