View Issue Details

IDProjectCategoryView StatusLast Update
0003776OXID eShop (all versions)4.09. SEO, SEO URLpublic2012-12-10 13:34
Reporterdainius.bigelis 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.9 revision 43186 
Target VersionFixed in Version4.5.10 revision 44222 
Summary0003776: SEO links for category returned not sorted (possible to get link to further page instead of first page)
DescriptionSee changes in method oxseoencoder::_loadFromDb()
In case when this method is called without $sParam and $blStrictParamsCheck = true (which is actually default value), the seourl will be selected from database without "order by" which leads to unpredictable result. e.g. www.your-shop.com/some-category/9/ (the url of 9th page of "some-category").
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Relationships

related to 0003722 resolvedLinas Kukulskis in seoencoder queries used order by param = ... , its bad for performance 

Activities

Linas Kukulskis

2012-03-28 14:40

reporter   ~0006109

fixed query generation