Products price dot change into comma

[timdebuurman]

Hi,

After upgrade Products from 2.24.1 to 2.24.2 (I upgraded all other modules and core to 1.12.1) the price changes from dot decimal to comma.

So after revisit the product I see in the price field 14,95 instead of 14.95 (ofcourse I filled in the price with dot)

So after saving again, the comma is ignored and it becomes 14

Here's my system info:
----------


----------------------------------------------

Cms Version: 1.12.1

Installed Modules:

CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.7
FormBuilder: 0.8.1.1
ModuleManager: 1.5.8
News: 2.15.2
Search: 1.7.13
ThemeManager: 1.1.8
TinyMCE: 2.9.12
MicroTiny: 1.2.9
CGExtensions: 1.49.9
CGSmartImage: 1.20.3
CGSimpleSmarty: 1.9.1
CGEcommerceBase: 1.5.2
CGPaymentGatewayBase: 1.3.1
Cart2: 1.1.3
FrontEndUsers: 1.29
CustomContent: 1.10
JQueryTools: 1.3.7
Products: 2.24.2
Orders: 1.16.5
FRShipping: 1.2.3
SelfRegistration: 1.9.2
SisowGateway: 0.5.6
DestinationBasedShippingWeight: 1.1.2
MleCMS: 1.11.4
CGContentUtils: 1.5.1
Promotions: 1.2
Cart: 1.10.1
ListIt2: 1.4.1
ListIt2uitschuif: 1.4.1
Guestbook: 1.4_RC2
SEOTools2: 1.2.1
DestinationBasedShipping: 1.1.2
TemplateExternalizer: 2.1.6
Gallery: 2.0.2
Cartlog: 0.0.1
CGBlog: 1.13.1


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 32000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale: nl_NL.UTF-8
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.4.36
md5_function: Aan (Waar)
gd_version: 2
tempnam_function: Aan (Waar)
magic_quotes_runtime: Uit (Onwaar)
E_STRICT: 2048
E_DEPRECATED: 8192
memory_limit: 256M
max_execution_time: 90
output_buffering: 4096
safe_mode: Uit (Onwaar)
file_uploads: Aan (Waar)
post_max_size: 64M
upload_max_filesize: 32M
session_save_path: Geen controle omdat 'open_basedir' actief is
session_use_cookies: Aan (Waar)
xml_function: Aan (Waar)
xmlreader_class: Aan (Waar)


Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysqli)
Server Db Version: 5.6.12
Server Db Grants: Er is een "GRAND ALL" permissie gevonden, alles lijkt in orde.
Server Time Diff: Geen tijdverschil aangetroffen


----------------------------------------------

[velden]

From my little experience with some ecomm products I know it could be relevant what language is chosen in Admin. So you could change your admin language to English (assuming it's Dutch now) and try to reproduce the problem.

That could be a work around (per user) and useful information when submitting a bug report.

[timdebuurman]

Hi velden,

Thx for your reaction.
Changing the admin language did not help.
I submitted a bug report in the forge for this.

Meanwhile I made a dirty workaround bij putting a smarty replace in the module template.

[timdebuurman]

In the forge the reaction from Calguy was that it's working fine with his copy.

Now I upgraded another website and the same problem happens.

I checked the database, but there the price is correct, with a dot.
So once I want to edit a product, the price is there with a comma..

Anyone any idea where too look, so I can give Calguy the correct information about this problem?

[Rolf]

I have tried this on my website with Products module, but it works for me.
Filled in 1.25 and edit/save the product. It stays 1.25 with a point.
CMSMS 1.12.1 and latest Products (for 1.12.1)

You tried another webbrowser?

Do you use module_custom Admin templates?

Rolf

[velden]

I can reproduce the problem when using Dutch admin language.

My Preferences -> My Account -> User Preferences -> Language:Nederlands (Dutch)
Mijn instellingen -> Mijn Account -> Gebruikersinstellingen -> Taal: Nederlands (Dutch)

I posted this before but it didn't seem to matter in your case.

[Rolf]

Indeed, velden! I reproduced it too.

Value set to 1.25
Change Admin language to Dutch
Open product and the value is 1,25... Even before submitting.



----------------------------------------------

Cms Version: 1.12.1

Installed Modules:

CMSMailer: 5.2.2
FileManager: 1.4.5
MenuManager: 1.8.7
MicroTiny: 1.2.9
ModuleManager: 1.5.8
Search: 1.7.13
ThemeManager: 1.1.8
CGSimpleSmarty: 1.9.1
CGExtensions: 1.49.9
CGBlog: 1.13.1
MysqlDump: 1.3.1
Gallery: 2.0.3
LinkMgr: 2.0
JQueryTools: 1.3.7
CompanyDirectory: 1.22.11
CGFeedMaker: 1.0.20
CGSmartImage: 1.20.3
AceEditor: 1.0
FormBuilder: 0.8.1.2
Captcha: 0.5.2
CGGoogleMaps: 2.4.7
Products: 2.24.2
AdminIPLock: 1.0
CMSPrinting: 1.0.5
News: 2.15.2


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 32000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.4.41-1~dotdeb+6.1
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 30
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 32M
upload_max_filesize: 32M
session_save_path: /public/tmp (0755)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysql)
Server Db Version: 5.5.38
Server Db Grants: Could not find a suitable "GRANT ALL" permission. This may mean you could have problems installing or removing modules. Or even adding and deleting items, including pages
Server Time Diff: No filesystem time difference found


----------------------------------------------

[timdebuurman]

thx for your help with this and for updating the bug-report in the forge.

Now there is another report, concerning the URL Slug not working, but I shall make a new topic for that.