Guest Toby Wallis Posted June 21, 2006 Share Posted June 21, 2006 Why can't I enter a tax rate greater than 9.9999% (or more pertinent, how do I get it to accept a greater rate?) I need to use UK VAT rate of 17.5% but every time I try to enter it I get an error message. Unless I can resolve this issue I won't be able to use your (otherwise excellent) cart!!! Thanks ===Toby=== Quote Link to comment Share on other sites More sharing options...
roban Posted June 21, 2006 Share Posted June 21, 2006 having done a search for you using VAT as the search query, I come up with these threads. http://www.cubecart.com/site/forums/index....topic=17744&hl= http://www.cubecart.com/site/forums/index....topic=16462&hl= http://www.cubecart.com/site/forums/index....topic=18197&hl= http://www.cubecart.com/site/forums/index....990entry80990 I hope one of these will help. Quote Link to comment Share on other sites More sharing options...
Guest Toby Wallis Posted June 22, 2006 Share Posted June 22, 2006 having done a search for you using VAT as the search query, I come up with these threads. http://www.cubecart.com/site/forums/index....topic=17744&hl= http://www.cubecart.com/site/forums/index....topic=16462&hl= http://www.cubecart.com/site/forums/index....topic=18197&hl= http://www.cubecart.com/site/forums/index....990entry80990 I hope one of these will help. Thanks, but the only one that referred to the same problem was no.1 and thet refers to a file called schema.inc.php which I can't find on my installation and therefore no good at all. Given that the application developer is from UK (VAT 17.5%) you'd think they'd make it a bit more flexible... Quote Link to comment Share on other sites More sharing options...
convict Posted June 22, 2006 Share Posted June 22, 2006 You use MySQL version 5. You have to change the taxes table column specification like ... ALTER TABLE `CubeCart_taxes` CHANGE `percent` `percent` DECIMAL( 6, 4 ) NOT NULL DEFAULT '0.0000' Originale one is DECIMAL( 5, 4 ) Quote Link to comment Share on other sites More sharing options...
Guest neverest Posted July 6, 2006 Share Posted July 6, 2006 You use MySQL version 5. You have to change the taxes table column specification like ... ALTER TABLE `CubeCart_taxes` CHANGE `percent` `percent` DECIMAL( 6, 4 ) NOT NULL DEFAULT '0.0000' Originale one is DECIMAL( 5, 4 ) thank, first post, first problem, resolved in 4 minutes :) Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 26, 2006 Share Posted September 26, 2006 Ah convict once again a quick and easy solution My host upgrade their sql to ver 5 but it wasnt till a couple weeks later that i relized my tax had changed since it was set at 10% anyway thanks for the solution Quote Link to comment Share on other sites More sharing options...
Guest J. Villalobos Posted October 4, 2006 Share Posted October 4, 2006 Ah convict once again a quick and easy solution My host upgrade their sql to ver 5 but it wasnt till a couple weeks later that i relized my tax had changed since it was set at 10% anyway thanks for the solution I try this solution, but the table has a fiels percent with type decimal(7,4), I try decimal(8,4) and decimal(6,4), but nothing change. Quote Link to comment Share on other sites More sharing options...
Guest alby1 Posted May 2, 2007 Share Posted May 2, 2007 It worked for me thanks a lot for your time and help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.