View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000988 | OXID eShop (all versions) | 4. ------ eShop Core ------- | public | 2009-06-08 16:16 | 2012-12-10 13:42 |
Reporter | oxy_uttendorfsky | Assigned To | |||
Priority | normal | Severity | major | Reproducibility | always |
Status | resolved | Resolution | no change required | ||
Product Version | 4.1.2 revision 18998 | ||||
Fixed in Version | 4.1.6 revision 22740 | ||||
Summary | 0000988: Characters which are replaced in SEO URLs - wrong storing in database | ||||
Description | when 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 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Theme | |||||
Browser | All | ||||
PHP Version | 5.2.6 | ||||
Database Version | 5.0.33 | ||||
|
I see that characters was transfered after sendin this post, so I attached picture... |
|
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. |
|
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, |
|
Hi, e-shop runs in win-1250 (CP1250) encoding |
|
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 ) ); |
|
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. |
|
Reminder sent to: oxy_uttendorfsky Added notice for bug 0000988 |