View Issue Details

IDProjectCategoryView StatusLast Update
0001219OXID eShop (all versions)4.09. SEO, SEO URLpublic2012-12-10 13:35
Reporterrgruber Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.1.5 revision 21618 
Fixed in Version4.1.6 revision 22740 
Summary0001219: Saving of seo url not possible
DescriptionSaving of changes of the seo url is in some cases not possible.

If I change a letter within the seo url from upper case to lower case and press the save button, the changed letter will change again to upper case.

If I activate the checkbox "URL fixieren" and change a letter from upper case to lower case and press the save button, the changed letter will be saved correctly and is still lower case. But if I change the letter again to upper case and press the save button, the leter will change automaticly to lower case.

Tested this in the demo shop and had the same problem.
TagsNo tags attached.
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

dainius.bigelis

2009-08-19 15:40

reporter   ~0001458

I guess, this is because Upper and Lower cases are interpreted as the same. So system does not find the change - thus not saves the url with changed letter cases.

arvydas_vapsva

2009-08-20 14:41

reporter   ~0001469

You can fix this problem by executing this query:

ALTER TABLE `oxseo` CHANGE `OXSEOURL` `OXSEOURL` TEXT CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;

this will be included in next release update sql.