View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001187 | OXID eShop (all versions) | 4.09. SEO, SEO URL | public | 2009-08-10 17:54 | 2012-12-10 13:35 |
| Reporter | rimvydas_paskevicius | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.1.5 revision 21618 | ||||
| Summary | 0001187: Expired seo links are not updated correctly | ||||
| Description | When updating expired seo links if there is same url and just "oxexpired" db field needs to be reseted, sql update script does not check category root id. If there is more than one root category id for this article with expired links, only first from the list is updated. | ||||
| Additional Information | A little example how this bug restes oxfixed db field. F.e. if we loading article in details page and it has expired seo link, oxseoencoderarticle checks that link is expired, and cheks if article is in more than one root category. If yes, loads categories list and changes seo link for all categories. Class regenerates seo link and updates db (where oxfixed field by default = 0). The problem is that update sql does not checks in sql WHERE statement root category id so it updates only first getted record from db (which may be not that record that should be updated) and resets oxfixed field to 0 and updates seo link. If there are only one root category id, there is no problem, but if there are more than one, we have a problem. | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
