Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Tax rates problem


Recommended Posts



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?

Link to comment
Share on other sites


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.



Support the Project, go PRO and get access to certified add ons

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

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...