View Issue Details

IDProjectCategoryView StatusLast Update
0001187OXID eShop (all versions)4.09. SEO, SEO URLpublic2012-12-10 13:35
Reporterrimvydas_paskevicius Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version4.1.5 revision 21618 
Summary0001187: Expired seo links are not updated correctly
DescriptionWhen 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 InformationA 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.
TagsNo tags attached.
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

rimvydas_paskevicius

2009-08-14 18:12

reporter   ~0001411

Added additional checking of root caegory id to sql when updating expired seo link