View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007204 | OXID eShop (all versions) | 2.1. Master Settings | public | 2020-12-31 17:23 | 2022-01-26 13:36 |
| Reporter | mf | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 6.2.3 | ||||
| Fixed in Version | 6.4.1 | ||||
| Summary | 0007204: selection window to add an item to a discount is empty | ||||
| Description | It is not possible to use discount "itm" because no items are displayed in the selection window. A 500 error is thrown. In the log you can find: Unknown column 'oxv_oxarticles_2_en.oxvarselect_1' in 'field list' ["[object] (OxidEsales\\Eshop\Core\Exception\\DatabaseErrorException(code: 1054): Unknown column 'oxv_oxarticles_2_en. oxvarselect_1' in 'field list' at /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938 | ||||
| Steps To Reproduce | - Activate: Core Settings > System > Variants > Display Variants in Assignment Lists in eShop admin - choose another shop default language (Master Settings > Languages) Try to add an item-discount to an article. | ||||
| Additional Information | In the "DiscountItemAjax" controller in the "_getQueryCols" method, the following code leads to the error: $sVarSelect = "$sViewTable.oxvarselect" . $sLangTag; The $sLangTag variable is appended in case the store is operated without views, i.e. blSkipViewUsage is set to true in the config. For view tables, however, the $sLangTag is not needed and for the default language it is also not appended as its 0. As a workaround I would like to suggest the following by replacing the line "$sVarSelect = "$sViewTable.oxvarselect" . $sLangTag;" as follows: if ($oConfig->getConfigParam('blSkipViewUsage')) { $sVarSelect = "$sViewTable.oxvarselect" . $sLangTag; } else { $sVarSelect = "$sViewTable.oxvarselect"; } Thus, both cases, i.e. using and not using views are covered and the query is created as expected. | ||||
| Tags | No tags attached. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
