View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003475 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2012-01-03 09:48 | 2012-02-07 15:18 |
Reporter | wanis | Assigned To | |||
Priority | high | Severity | major | Reproducibility | always |
Status | resolved | Resolution | no change required | ||
Summary | 0003475: wrong SQL formation in oxadminlist::init() | ||||
Description | in article_list::_changeselect() there are appending where condition, but in oxadminlist::init orderby clause is already set in sql, this causes SQL error. oxadminlist::init() line 191: .. $sSql = $this->_prepareOrderByQuery( $sSql ); $sSql = $this->_changeselect( $sSql ); .. article_list::_changeselect() line 211: .. switch ($sType) { .. case 'mnf': $sSql.= " and $sTable.oxmanufacturerid = ".oxDb::getDb()->quote($sValue); break; .. return $sSql; | ||||
Steps To Reproduce | go to administer products in list select one of manufacturer select custom column (let say oxartnum) after enter(or click search button) article list shows all articles. | ||||
Additional Information | for quick fix, change the order in oxadminlist::init() to this: $sSql = $this->_changeselect( $sSql ); $sSql = $this->_prepareOrderByQuery( $sSql ); | ||||
Tags | No tags attached. | ||||
Theme | Both | ||||
Browser | All | ||||
PHP Version | any | ||||
Database Version | any | ||||