In-Portal Issue Tracker - In-Commerce
Viewing Issue Advanced Details
1010 [In-Portal CMS] Database bug report always 2011-03-07 12:03 2011-09-19 16:08
Dmitry  
alex  
normal  
closed 5.1.2-B2  
fixed  
 
none 5.1.3-B1  
https://groups.google.com/d/topic/in-portal-bugs/Rd7vvR6vM7E/discussion
Corrected definitions of Decimal fields database
0
0001010: Check all DECIMAL Database Fields for Correct Definitions
Check all DECIMAL database fields for correct definitions and make corrections.

Recently we have come across the table AffiliatePlansBrackets, field Percent uses DECIMAL(3,2) which would allow to save only numbers below 10 (9.99 etc), sa far as 10.00 is out of range already.
patch issue-with-decimals.patch (1,128) 2011-05-19 17:24
http://tracker.in-portal.org/file_download.php?file_id=1007&type=bug
Issue History
2011-09-19 16:08 alex Note Added: 0003856
2011-09-19 16:08 alex Status resolved => closed
2011-05-20 05:36 alex Note Added: 0003453
2011-05-20 05:36 alex Status reviewed and tested => resolved
2011-05-20 05:36 alex Fixed in Version => 5.1.3-B1
2011-05-20 05:36 alex Resolution open => fixed
2011-05-20 05:36 alex Assigned To !COMMUNITY => alex
2011-05-20 05:36 alex Changeset attached 5.1.x r14335
2011-05-20 05:35 alex Project In-Portal CMS => In-Commerce
2011-05-20 05:34 alex Note Added: 0003452
2011-05-20 05:34 alex Assigned To alex => !COMMUNITY
2011-05-20 05:34 alex Status needs testing => reviewed and tested
2011-05-19 17:24 Dmitry Time Estimate Removed 1 =>
2011-05-19 17:24 Dmitry Note Added: 0003426
2011-05-19 17:24 Dmitry Assigned To Dmitry => alex
2011-05-19 17:24 Dmitry Developer => Dmitry
2011-05-19 17:24 Dmitry Status needs work => needs testing
2011-05-19 17:24 Dmitry File Added: issue-with-decimals.patch
2011-05-18 13:23 Dmitry Time Estimate Added 1
2011-04-04 11:53 Dmitry Assigned To => Dmitry
2011-04-04 11:53 Dmitry Status active => needs work
2011-04-04 11:53 Dmitry Target Version Icebox => 5.1.3
2011-03-07 12:03 Dmitry New Issue
2011-03-07 12:03 Dmitry Reference => https://groups.google.com/d/topic/in-portal-bugs/Rd7vvR6vM7E/discussion
2011-03-07 12:03 Dmitry Change Log Message => Corrected definitions of Decimal fields database

Notes
(0003426)
Dmitry   
2011-05-19 17:24   
Please test
(0003452)
alex   
2011-05-20 05:34   
ok
(0003453)
alex   
2011-05-20 05:36   
Fix committed to 5.1.x branch. Commit Message:

Fixes 0001010: Check all DECIMAL Database Fields for Correct Definitions
Commit on behalf of Dmitry
(0003856)
alex   
2011-09-19 16:08   
Closing, since 5.1.3 release has been released.