View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000990 | OXID eShop (all versions) | 4.09. SEO, SEO URL | public | 2009-06-08 17:11 | 2012-12-10 13:35 |
| Reporter | philipp_grashoff | Assigned To | |||
| Priority | low | Severity | trivial | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.2 revision 18998 | ||||
| Fixed in Version | 4.1.4 revision 21266 | ||||
| Summary | 0000990: SEO URLs for products should be sorted by OXTIME | ||||
| Description | in Products -> SEO tab, u can select different category SEO URLs for a product. These categories arent sorted and are loaded as the category assignments (oxobject2category) are stored in the database. It would make sense to have these URLs sorted by OXTIME entry: 1) newly assigned categories are always shown last (had the case that a new entry wasnt inserted at the end of the database but somewhere in between) 2) main category of product is always shown first. Solution: In core/oxseoencoderarticle.php, function getSeoCategories, ~ line 320: add order by to sql: $sQ = "select distinct catroots.oxrootid from oxobject2category as o2c left join {$sCatTable} as catroots on o2c.oxcatnid=catroots.oxid where o2c.oxobjectid = '$sArtId' order by o2c.oxtime"; | ||||
| Additional Information | For further info, u can ask sarunas. Discussed this case with him | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
