View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001692 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2010-03-11 16:15 | 2010-05-21 15:32 |
| Reporter | Moehlis | Assigned To | |||
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2.0 revision 23610 | ||||
| Fixed in Version | 4.3.2 revision 27884 | ||||
| Summary | 0001692: search for special chars in articlelist works incorrectly | ||||
| Description | when searching for article name with specialchars we have a strange effect: - searching for "<word with special char> <normal word>" will result in an OR search - searching for "<normal word> <word with special char>" will result in an AND search problem source seems to be oxadminlist.php:_prepareWhereQuery():540-545 $sUml = $myUtilsString->prepareStrForSearch( $sVal ); if ( $sUml ) { $sqlFull .= " or {$sFieldName} "; $sqlFull .= $this->_buildFilter( $sUml, $blIsSearchValue ); } it will create a query like: oxv_oxarticles_1.OXTITLE like '%wandühr%' or oxv_oxarticles_1.OXTITLE like '%wandühr%' and oxv_oxarticles_1.OXTITLE like '%digital% as a simple workaround, i added brackets: ... foreach ( $aVal as $sVal) { $sFieldName = oxDb::getInstance()->escapeString( $sFieldName ); $sqlFull .= " {$sSqlBoolAction} ({$sFieldName} "; // added bracket ... $sqlFull .= ')'; // added line } ... | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
