mariovaldez.net

I get a problem when switching unavailable product to available, product weight is changing too !
e.g
before: products weight= 0,2
after: products weight=2

same if we try to change the products weight !

Actually, product weight is changing whatever you do when editing product , changing manufacturer, prices, weight, status, .....

Pipo:

> I get a problem when switching unavailable
> product to available, product weight is
> changing too ! e.g
> before: products weight= 0,2
> after: products weight=2
> same if we try to change the products
> weight !Actually, product weight is changing
> whatever you do when editing product ,
> changing manufacturer, prices, weight,
> status, .....

Hi. What version of osCommerce are you using?
Does it happen if you enter "," as decimal separator only or if you enter "." as decimal separator too?

Regards,

Mario A. Valdez-Ramirez.

Hi,
I'm using a MS2.
Actually you can't enter "." its result an error message , you can only enter "," as a decimal separator.

Pipo:

> Hi, I'm using a MS2. Actually you can't
> enter "." its result an error message ,
> you can only enter "," as a decimal
> separator.

Hello again. I cannot replicate your problem. I need more information. May you give me please the following data:

What operative system are you using?
What language is your operative system configured?
What database version are you using?
Have you tested in other computer with different operative system or regional settings?

I have no idea what could be the problem. A thought I've written the application the more locale-independent possible, but maybe there is a problem with the way I'm processing the numbers.

I hope I can fix this problem but first I need to know what is the problem. And I hope you are not too frustrated so you can help me hunting this bug.


Regards,

Mario A. Valdez-Ramirez.

Hi again !
well here are the information:
Win XP Pro french
PhpMyadmin-MySQL 4.0.15-max-debug
Yes I've tryed on 2 computers but still the same problem !

I think I could be a problem with country decimal because product price is changing aswell when I change the product weight.
e.g:
If I try to change the product weight from 0,3 to 0,5 it saves 5 and the product change from 15,50 to 1550 !
I hope you will find an issue to that problem !

Pipo:

I found the problem.

> ...Win XP Pro french...
> I think I could be a problem with
> country decimal because product
> price is changing aswell when I
> change the product weight.

I replicated the problem changing the regional settings of Windows to French (it will also fail with any other country with different decimal separator).


> If I try to change the product weight
> from 0,3 to 0,5 it saves 5 and the
> product change from 15,50 to 1550 !

Yes. My cleaning routines try to strip non-numerical characters, deleting the ",".


I thought I was programming globally enough...

Thanks for the bug report! I'm fixing this right now.


Regards,

Mario A. Valdez-Ramirez.

Pipo:

Hi. I've uploaded a new version (0.1.0.330) with several changes.

After reviewing my code, I've found the source of the problem. The cause is much more extensive than what I thought before. A definitive solution is to support any regional setting for any country. However, to accomplish that I will need to rewrite a lot of code, so I'm delaying this final solution.

In the mean time, I've set a partial workaround, which is to force a "." (period) as decimal separation and a "," (comma) as thousands separator. This may seems ugly for people used to the opposite, but it will allow them to use the application without destroying their data. At least until I write a definitive fix.

More technical details are described in the Bugs #80 and #77 at the bugtracker pages.

So, Pipo, what do you think? May you please try it out?


Regards,

Mario A. Valdez-Ramirez.