In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

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 EstimateNo 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 patch file icon issue-with-decimals.patch [^] (1,128 bytes) 2011-05-19 17:24 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0003426)
Dmitry (manager)
2011-05-19 17:24

Please test
User avatar (0003452)
alex (manager)
2011-05-20 05:34

ok
User avatar (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
User avatar (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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker