View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005995 | OXID eShop (all versions) | 1.06. Search, Tags | public | 2014-12-11 17:55 | 2015-12-03 10:21 |
| Reporter | Adrian.Kirchner | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.9.2 / 5.2.2 | ||||
| Fixed in Version | 4.9.3 / 5.2.3 | ||||
| Summary | 0005995: search with spaces only causes MySQL exception | ||||
| Description | When searching for a space (" ") without further characters, OXIDs internal MySQL select statement builder causes a MySQL exception: ------------- SELECT `oxv_oxarticles_1_de`.`oxid`, oxv_oxarticles_1_de.oxtimestamp FROM oxv_oxarticles_1_de WHERE ( oxv_oxarticles_1_de.oxactive = 1 AND ( oxv_oxarticles_1_de.oxstockflag != 2 OR ( oxv_oxarticles_1_de.oxstock + oxv_oxarticles_1_de.oxvarstock ) > 0 ) AND ( ( ( SELECT oxobjectrights.oxobjectid FROM oxobjectrights WHERE oxobjectrights.oxobjectid = oxv_oxarticles_1_de.oxid AND oxobjectrights.oxaction = 1 LIMIT 1 ) IS NULL ) ) ) AND oxv_oxarticles_1_de.oxparentid = '' AND oxv_oxarticles_1_de.oxissearch = 1 AND ( ) <---- This is the problematic part LIMIT 0, 20 | ||||
| Steps To Reproduce | 1) Visit http://demoshop.oxid-esales.com/professional-edition/ 2) Enter a space in the search input 3) Press enter 4) -> Shop offline | ||||
| Additional Information | I created a pull request: https://github.com/OXID-eSales/oxideshop_ce/pull/193 | ||||
| Tags | No tags attached. | ||||
| Theme | Azure | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | 5.5 | ||||
