View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006025 | OXID eShop (all versions) | 2.6. Administer orders | public | 2015-01-21 11:48 | 2024-01-19 09:08 |
| Reporter | d3 | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Product Version | 4.9.2 / 5.2.2 | ||||
| Summary | 0006025: 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 Information | 4.8.9 + 4.9.2 | ||||
| Tags | No tags attached. | ||||
| Theme | Azure | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
|
|
Hi, Could you please give us more details how to reproduce this case? Best regards, Jurate |
|
|
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. |
|
|
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 |
|
|
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. |
