mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

probleme with availability switch
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=14&t=96
Page 1 of 1

Author:  Pipo [ 21 Aug 2004, 13:23 ]
Post subject:  probleme with availability switch

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 !

Author:  Pipo [ 21 Aug 2004, 13:27 ]
Post subject: 

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

Author:  mvaldez [ 21 Aug 2004, 16:47 ]
Post subject:  Weight and decimal separator.

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.

Author:  Pipo [ 22 Aug 2004, 00:55 ]
Post subject: 

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

Author:  mvaldez [ 22 Aug 2004, 01:23 ]
Post subject:  Weird problem, I need more info.

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.

Author:  pipo [ 22 Aug 2004, 02:17 ]
Post subject: 

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 !

Author:  mvaldez [ 22 Aug 2004, 03:29 ]
Post subject:  That's the 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... :roll:

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


Regards,

Mario A. Valdez-Ramirez.

Author:  mvaldez [ 22 Aug 2004, 07:45 ]
Post subject:  Partial fix with workaround...

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.

Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/