View Issue Details

IDProjectCategoryView StatusLast Update
0005995OXID eShop (all versions)1.06. Search, Tagspublic2015-12-03 10:21
ReporterAdrian.Kirchner 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.9.2 / 5.2.2 
Target VersionFixed in Version4.9.3 / 5.2.3 
Summary0005995: search with spaces only causes MySQL exception
DescriptionWhen 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 Reproduce1) Visit http://demoshop.oxid-esales.com/professional-edition/
2) Enter a space in the search input
3) Press enter
4) -> Shop offline
Additional InformationI created a pull request: https://github.com/OXID-eSales/oxideshop_ce/pull/193
TagsNo tags attached.
ThemeAzure
BrowserAll
PHP VersionNot defined
Database Version5.5

Activities

Linas Kukulskis

2014-12-12 16:30

reporter   ~0010441

fixed with pull request