View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005631 | OXID eShop (all versions) | 4.02. Session handling | public | 2014-01-29 19:57 | 2015-10-26 14:26 |
Reporter | Adrian.Kirchner | Assigned To | |||
Priority | urgent | Severity | crash | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 4.8.1 / 5.1.1 | ||||
Target Version | 4.8.6 / 5.1.6 | Fixed in Version | 4.8.6 / 5.1.6 | ||
Summary | 0005631: Category default sorting leads to empty category lists when switching languages | ||||
Description | Due to the fact, that the category default sorting column (including lang dependent oxarticle-Viewname) is stored in the users session (if one is present) the generated oxArticleList select statement references an unknown column, therefore leads to an sql error which results in an empty category list. | ||||
Steps To Reproduce | 1) Setup a fresh EE 5.1.1 with demo data 2) set default sorting for category "Kiteboarding > Kiteboards" to eg. oxprice and descending 3) Visit shop frontend 4) Login 5) Visit category "Kiteboarding > Kiteboards" 6) click at the first product (Kiteboard Flyboards Flywave 2010) 7) switch the frontend language (eg. from german to english) 8) go back to the category "Kiteboarding > Kiteboards" via category navigator on the left => category list is empty because sessions stores the following order column: oxv_oxarticles_1_de.oxprice which is not present when selecting against oxview oxv_oxarticles_1_en | ||||
Tags | Category, Sorting | ||||
Attached Files | |||||
Theme | Azure | ||||
Browser | FireFox, Google Chrome, Opera | ||||
PHP Version | 5.3 | ||||
Database Version | 5.5 | ||||
|
removed views name from sorting sql snippet |
|
https://github.com/OXID-eSales/oxideshop_ce/commit/b896b1c491b8c94039be5a588ceec417041b65f0 |