Imported From: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/cf1569e8ea5b92a5#
Nikita recently fixed this in a project. Here is the original bug report:
- I added an Affiliate Plan via Affiliates -> Affiliate Plan (ID: 1)
On the Brackets tab, I setup the following:
From Amount / To Amount / Percent ------------------------------------------------- 1 / 100 / 10 100 / 500 / 20 500 / infinity / 30
- I saved the Affiliate plan.
- I edited the Affiliate plan, opened the Brackets tab and saw that all of the Percents reset to 9.99.
Nikita can explain more exactly what was fixed, but as far as I understood, it had to do with how MySQL now stores DECIMAL(3,2) fields. This was also fixed in a couple other tables with the same problem.
Original bug report was for version 5.1.0. Also tested on 5.1.2-beta2.