View Issue Details

IDProjectCategoryView StatusLast Update
0006025OXID eShop (all versions)2.6. Administer orderspublic2015-12-01 12:23
Reporterd3 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.9.2 / 5.2.2 
Target VersionFixed in Version 
Summary0006025: Add article to order, not article found
Description[Administer Orders] --> [Orders] --> [Tab: Products]
--> search product

The searchquery contains the fields (oxid, oxparentid) in lower case.
But the script expect the field in Upper Case(OXId, OXPARENTID).

In some cases(server, php-configuration, ..) this dosn't work.

So, please use lower case or capitals and not a mix.



Additional Information4.8.9 + 4.9.2
TagsNo tags attached.
ThemeAzure
BrowserAll
PHP Versionany
MySQL Versionany

Activities

jurate.baseviciene

2015-02-12 13:27

reporter   ~0010662

Hi,

 Could you please give us more details how to reproduce this case?

Best regards,
Jurate

vschmi

2015-02-23 10:59

reporter   ~0010690

Affects us as well.

Steps to reproduce:

1. Open any existing order
2. Switch to tab "Products"
3. Add an existing and active product in the field "Prod. No."
4. Click search

Oxid reports that no article was found. Oxid EE 5.2.1.

QA

2015-02-24 08:47

administrator   ~0010700

reproducable on demoshop

Steps to reproduce: Article Number e.g 1208A

1. Open any existing order
2. Switch to tab "Products"
3. Add an existing and active product in the field "Prod. No." 1208a
4. Click search -> no articles found in OXID EE 5.2.3

vschmi

2015-05-11 11:17

reporter   ~0010947

The bug can be very easily fixed. Change the SQL Query in getMainProduct() to this:

$sQ = "select OXID, OXPARENTID from $sTable where oxartnum = " . $oDb->quote($sArtNum) . " limit 1";

The reason this fails is because originally you search for "SELECT oxid, oxparentid" but check in the array for OXID and OXPARENTID. This is case-sensitive.