Bug 4160

Summary: Currency Conversion dosn't handle rates other than 100
Product: Koha Reporter: Colin Campbell <colin.campbell>
Component: AcquisitionsAssignee: Katrin Fischer <katrin.fischer>
Status: CLOSED FIXED QA Contact: Bugs List <koha-bugs>
Severity: normal    
Priority: PATCH-Sent (DO NOT USE) CC: chris, katrin.fischer, mark
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Proposed patch

Description Chris Cormack 2010-05-21 01:23:50 UTC


---- Reported by colin.campbell@ptfs-europe.com 2010-02-11 13:49:38 ----

Current conversion rate from UK pounds to Yen

1.00 GBP = 140.363 JPY

Koha amended that to 99.99999

Given the inherent "stability" of the world economic order we cannot assume values will be less than 100



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:23 UTC  ---

This bug was previously known as _bug_ 4160 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4160

Actual time not defined. Setting to 0.0
Setting qa contact to the default for this product.
   This bug either had no qa contact or an invalid one.

Comment 1 Mark Kastoun 2010-10-28 07:29:34 UTC
to Chris Cormack:

To enable rates exceeding 100, execute the SQL beneath on your database.
 
ALTER TABLE  `currency` CHANGE  `rate`  `rate` FLOAT( 15, 5 ) NULL DEFAULT NULL;


Have a good day.

Thanks goes to <owen> on #koha IRC channel.
Comment 2 Katrin Fischer 2010-12-10 07:04:58 UTC
Created attachment 2827 [details] [review]
Proposed patch

I created a patch changing the data type of rate as suggested above. Please test and sign-off.
Comment 3 MJ Ray (software.coop) 2011-01-10 10:48:47 UTC
This bug is mentioned in:
Bug 4160: Currency conversion doesn't handle	rates other than 100 http://lists.koha-community.org/pipermail/koha-patches/2010-December/013224.html
Comment 4 Chris Cormack 2011-02-01 06:40:11 UTC
Patch pushed, please test
Comment 5 MJ Ray (software.coop) 2011-02-05 19:01:13 UTC
This bug is mentioned in:
Bug 4160: Currency conversion	doesn't handle rates other than 100 http://lists.koha-community.org/pipermail/koha-patches/2011-January/013728.html