View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000797 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2009-04-14 15:21 | 2012-12-07 14:13 |
| Reporter | hairpoint_de | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.0 revision 17976 | ||||
| Fixed in Version | 4.1.1 revision 18442 | ||||
| Summary | 0000797: SQL table access returns empty string | ||||
| Description | Since I applied the latest Update (UPDATE_OXID_ESHOP_PE_V.4.0.1.0_15990_TO_V.4.1.0_17976), some columns in SQL tables cannot be read anymore. The Problem occures (at least) on pages that show subcategories. "[{ $category->oxcategories__oxtitle->value }]" and "[{ $category->oxcategories__oxicon->value }]" in "list.tpl" are returning the CORRECT values, while, "[{ $category->oxcategories__oxdesc->value }]", "[{ $category->oxcategories__oxdesc_1->value }]", "[{ $category->oxcategories__oxthumb->value }]" and "[{ $category->oxcategories__oxtitle_1->value }]" do NOT. I don't tested the remaining ones. | ||||
| Tags | Category | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
|
|
Reminder sent to: hairpoint_de Hi, During build of category tree, some details (like long description, etc.) are not needed for categories. So the change was implemented - to not load the details, which are not necesarry. This change improves the performance of the shop a lot. Also the same reason for the multilangual fields: as category tree is displayed only in one language at a time, the values in other languages are not needed in our opinion. But maybe we are wrong and there are cases, when these details are needed. Please describe us the case when you use these details. Best regards, |
|
|
Well, this makes sense, but we need at least the short description of the categories to give our customers a hint about how the products in similar sounding categories differ. (As you can see in our version 3 shop. hairpoint.de) |
|
|
Reminder sent to: hairpoint_de Do you need this Short description of category in the Category tree, or only in the Category View page? @developers: please check if the separate category for templates is loaded not from the category tree array, to make sure that separate category object (i.e. in Category view) can be loaded with full details. |
|
|
The short descriptions for categories are needed in the Category view, when subcategories with the icons are displayed there. So short descriptions also should be displayed there. Fix it to load short descriptions for categories, when building category tree. |
|
|
loading additionally field oxdesc (like eg oxtitle) in oxcategoryList::_getSelectString() |
