telemekano Posted September 28, 2009 Posted September 28, 2009 Till a few days ago I had my tax rate set to 25% (for Swedish moms) and last week all my prices looked weard. The tax rate was all of a sudden set to 9.9999. When I try to set it to 25 again it automatically goes back to 9.9999. The only other number it sets to is 0... Tried to go directly in to the database but it's the same result... What to do??? Please, help!
telemekano Posted September 28, 2009 Author Posted September 28, 2009 Me again... Please, somebody! Could it be something in the database that controls this numbers? When I tried to change it in phpMyAdmin it sais: ALTER TABLE `tax_rates` CHANGE `tax_rate` `tax_rate` DECIMAL( 5, 4 ) NOT NULL DEFAULT '25' but it still says 9.9999 in the box!!! Getting crazy! Please, HELP ME!
♥ecartz Posted October 1, 2009 Posted October 1, 2009 ALTER TABLE `tax_rates` CHANGE `tax_rate` `tax_rate` DECIMAL( 5, 4 ) NOT NULL DEFAULT '25'Instead of that, try ALTER TABLE `tax_rates` CHANGE `tax_rate` `tax_rate` DECIMAL( 7, 4 ) NOT NULL and then change the value in admin. The 5,4 says that the number has five digits and four of them are after the decimal point. The largest number that you can express that way is 9.9999 (which is obviously less than 25). Changing to 7,4 will allow tax rates up to 999.9999% which should be more than sufficient for your needs. Always back up before making changes.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.