Intermittant "currency_value" = 0.000000 problem.

[jschner]

I have been chasing a problem with some invoices coming up with $0 in all fields. The emailed invoices show $0 amounts and the ADMIN shows $0 amounts on those orders. It seems to about 1/3 the orders that have this problem.

 

I have deleted all other currencies using 2.2 MS1 with no mods.

 

In the database ORDERS table the bad invoices all have 'currency_value' ='0.000000'. All the correct invoices show '1.000000'

 

Under the ORDERS_TOTAL table the 'text' field is 0 instead of being populated with the price.

 

My CURRENCIES table is as follows:

INSERT INTO `currencies` (`currencies_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_point`, `thousands_point`, `decimal_places`, `value`, `last_updated`)  

VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', '1.00000000', '2003-05-30 01:10:02');

 

My LANGUAGES table is as follows:

INSERT INTO `languages` (`languages_id`, `name`, `code`, `image`, `directory`, `sort_order`)

VALUES (1, 'English', 'en', 'icon.gif', 'english', 1);[/quotes]

 

I also have "Switch to Default language Currency" set to' false'.

SSL = false

My host is running:

MySQL 4.0.13

PHP 4.3.1 Running in safemode.

 

I have searched these forums, bug reports and some php files searching for clues. Any ideas out there?

[jschner]

This is related to another problem found here:

 

http://www.oscommerce.com/forums/viewtopic.php...p=197711#197711