Jump to content
Sign in to follow this  
mausmaki

Tax rates problem

Recommended Posts

Hi,

 

I got a big problem because an "expert" changed my OSC 2.2 database tables from MySQL 3.3 to MySQL 5 version.

In configuration at tax rates I can't change the VAT tax rate from 9.999999 to 19.999999, as it was formerly.
Direct change with phpMyAdmin is blocked by error code " Warning: #1264 Out of range value for column 'tax_rate' at row 1 "

What's wrong?

Share this post


Link to post
Share on other sites

@mausmaki

That is because you are entering more digits than allowable for the data type.

The tax rates table field is Decimal (7,4) which means, 4 digits to the right of the decimal place and 7 in total. See: https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html

You can change this, but I query why you need so many decimal places.

Peter


PROUDLY PASSIONATE PHOENIX SUPPORTER

Full-time I am a C-suite executive of a large retail company in Australia. In my spare time, I enjoying learning about web-design.

Download the latest version of CE Phoenix from gitHub here

Join the Phoenix Club. Become a Phoenix Supporter.  Gain access to special codes and modules and help the project thrive. Read here

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×