Currencies and Exchange Rates
Hi All, I have a slight problem with Currencies and Exchange rates. The problem is: I would like to enter a new currency into the system, which is the US currency and the exchange rate which for us (Guyana) is $200. The problem that I'm facing is: koha only allows a maximum exchange rate of 99.99999. How can the maximum exchange rate from 99.99999 to 200 or even to a much higher digit. Regards, Sheldon -- View this message in context: http://koha.1045719.n5.nabble.com/Currencies-and-Exchange-Rates-tp3294265p32... Sent from the Koha - Discuss mailing list archive at Nabble.com.
The problem that I'm facing is: koha only allows a maximum exchange rate of 99.99999.
This is a known but unfixed bug: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4160 You can fix it for your installation by altering the structure of the currency table in your Koha database: ALTER TABLE `currency` CHANGE `rate` `rate` FLOAT( 15, 5 ) NULL DEFAULT NULL; -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Thanks for the fix Sheldon Date: Mon, 6 Dec 2010 08:26:28 -0800 From: ml-node+3294282-251419808-135934@n5.nabble.com To: thecarterii@hotmail.com Subject: Re: Currencies and Exchange Rates > The problem
that I'm facing is: koha only allows a maximum exchange rate of 99.99999.
This is a known but unfixed bug: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4160 You can fix it for your installation by altering the structure of the currency table in your Koha database: ALTER TABLE `currency` CHANGE `rate` `rate` FLOAT( 15, 5 ) NULL DEFAULT NULL; -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha View message @ http://koha.1045719.n5.nabble.com/Currencies-and-Exchange-Rates-tp3294265p32... To unsubscribe from Currencies and Exchange Rates, click here. -- View this message in context: http://koha.1045719.n5.nabble.com/Currencies-and-Exchange-Rates-tp3294265p32... Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (2)
-
Owen Leonard -
sheldon_tappin