Anonymous | Login | Signup for a new account | 2024-03-29 09:24 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update | ||
0001010 | [In-Portal CMS] Database | bug report | always | 2011-03-07 12:03 | 2011-09-19 16:08 | ||
Reporter | Dmitry | View Status | public | Project Name | In-Commerce | ||
Assigned To | alex | Developer | |||||
Priority | normal | Resolution | fixed | Fixed in Version | 5.1.3-B1 | ||
Status | closed | Product Version | 5.1.2-B2 | Target Version | 5.1.3 | ||
Time Estimate | No estimate | ||||||
Summary | 0001010: Check all DECIMAL Database Fields for Correct Definitions | ||||||
Description |
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. |
||||||
Additional Information | |||||||
Tags | No tags attached. | ||||||
Reference | https://groups.google.com/d/topic/in-portal-bugs/Rd7vvR6vM7E/discussion | ||||||
Change Log Message | Corrected definitions of Decimal fields database | ||||||
Estimate Points | 0 | ||||||
Attached Files | issue-with-decimals.patch [^] (1,128 bytes) 2011-05-19 17:24 [Show Content] | ||||||
|
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0003426) Dmitry (manager) 2011-05-19 17:24 |
Please test |
(0003452) alex (manager) 2011-05-20 05:34 |
ok |
(0003453) alex (manager) 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 (manager) 2011-09-19 16:08 |
Closing, since 5.1.3 release has been released. |
Related Changesets | |||
Modules :: In-Commerce: 5.1.x r14335 Timestamp: 2011-05-20 05:36:07 Author: alex [ Details ] [ Diff ] |
Fixes 0001010: Check all DECIMAL Database Fields for Correct Definitions Commit on behalf of Dmitry |
||
mod - /w/in-commerce/branches/5.1.x/install/install_schema.sql | [ Diff ] [ File ] | ||
mod - /w/in-commerce/branches/5.1.x/install/upgrades.sql | [ Diff ] [ File ] | ||
Issue History | |||
Date Modified | Username | Field | Change |
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 |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |