[ic] SQL Price Rounding Problem
Cameron B. Prince
cplists at princeservices.com
Sat Feb 18 17:03:08 EST 2006
I recently moved a customer over and shortly after was informed of a problem
where all the product prices had the cents stripped off. A price in the
products.txt of 17.99 was showing up in MySQL as 17.00.
This is IC v4.8.5, MySQL v4.1.16, perl v5.6.2 and the latest DBI and
I reimported the table several times and verified this was happening each
time. I did a describe on the table and found that the price column had not
been modified from the default foundation catalog:
| price | decimal(12,2) | | MUL | 0.00 | |
To further test, I setup a standard catalog using IC v5.4.0 and copied the
products.txt file over and imported it. I had the same problem.
So I begin troubleshooting by dropping the product rows from 29,000+ to
1,000. I still had the same problem. I edited the
dbconf/mysql/products.mysql file and removed:
Database products NUMERIC price
Once I imported again, the prices were correct. Just as a sanity check, I
put the line back in the dbconf file and imported again. The problem
reoccurred. There appears to be a bug in the import function.
I recall seeing code in the admin pages or source in the past that used the
NUMERIC directive to control sorting I believe. Are there any other
ramifications I should be aware of by removing it from the dbconf file?
More information about the interchange-users