View Issue Details

IDProjectCategoryView StatusLast Update
0000988OXID eShop (all versions)4. ------ eShop Core -------public2012-12-10 13:42
Reporteroxy_uttendorfsky Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionno change required 
Product Version4.1.2 revision 18998 
Fixed in Version4.1.6 revision 22740 
Summary0000988: Characters which are replaced in SEO URLs - wrong storing in database
Descriptionwhen I edit array of replacing characters in SEO URLs, they are stored in database incorrectly:

I put into textarea this (czech characters with diacritics):

ě => e
š => s
č => c
ř => r
ž => z
ý => y
á => a
í => i
é => e
ŕ => r
ť => t
ú => u
ů => u
ó => o
ď => d
ĺ => l
ľ => l
ň => n
Ě => E
Š => S
Č => C
Ř => R
Ž => Z
Ý => Y
Á => A
Í => I
É => E
Ŕ => R
Ť => T
Ú => U
Ů => U
Ó => O
Ď => D
Ĺ => L
Ľ => L
Ň => N

after saving form, I see in textarea:

ì => e
š => s
è => c
ø => r
ž => z
ý => y
á => a
í => i
é => e
à => r
ť => t
ú => u
ù => u
ó => o
ï => d
å => l
Ÿ => l
ò => n
Ì => E
Š => S
È => C
Ø => R
Ž => Z
Ý => Y
Á => A
Í => I
É => E
À => R
Ť => T
Ú => U
Ù => U
Ó => O
Ï => D
Å => L
Œ => L
Ò => N
TagsNo tags attached.
Attached Files
seourl-characters.png (3,485 bytes)   
seourl-characters.png (3,485 bytes)   
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

oxy_uttendorfsky

2009-06-08 16:22

reporter   ~0001029

I see that characters was transfered after sendin this post, so I attached picture...

rimvydas_paskevicius

2009-06-15 09:58

reporter   ~0001060

It would be nice to have more info about your e-shop. Is it utf-8 mode shop and if not - what encoding do you use in admin? The best practice for non english/german shop would be use utf-8 mode.

dainius.bigelis

2009-06-15 10:36

reporter   ~0001063

Reminder sent to: oxy_uttendorfsky

Hi,

Could you please give us mode details about your shop (is it utf8 or not, what encoding is in Admin) or you have some special settings defined?
Also - maybe you can check your case with the UTF8 shop and check if it solves the problem or not?

Best regards,

oxy_uttendorfsky

2009-07-10 10:05

reporter   ~0001174

Last edited: 2009-07-10 10:05

Hi, e-shop runs in win-1250 (CP1250) encoding

oxy_uttendorfsky

2009-07-10 15:39

reporter   ~0001179

the solution is in file admin/shop_config.php do not use function htmlentities()
so, I modified this file:

row 109,
replace
$aConfStrs[$sVarName] = $oStr->htmlentities( $aConfStrs[$sVarName] );
to
$aConfStrs[$sVarName] = $aConfStrs[$sVarName];

row 116,
replace
$aConfArrs[$sVarName] = $oStr->htmlentities( $this->_arrayToMultiline( unserialize( $sVarVal ) ) );
to
$aConfArrs[$sVarName] = $this->_arrayToMultiline( unserialize( $sVarVal ) );

row 123,
replace
$aConfAarrs[$sVarName] = $oStr->htmlentities( $this->_aarrayToMultiline( unserialize( $sVarVal ) ) );
to
$aConfAarrs[$sVarName] = $this->_aarrayToMultiline( unserialize( $sVarVal ) );

rimvydas_paskevicius

2009-09-23 14:22

reporter   ~0001807

The solution to remove function htmlentities() from admin/shop_config.php is not good. Html code in config params values are not parsed before output in backend then and you can srew up <input> fields. I.e. if you save " (double quote) in one of the config param, html error will apier in admin config input field.

The best solution for this is usage of UTF-8 mode.

rimvydas_paskevicius

2009-09-23 14:23

reporter   ~0001810

Reminder sent to: oxy_uttendorfsky

Added notice for bug 0000988