mausmaki Posted September 20, 2019 Share Posted September 20, 2019 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? Link to comment Share on other sites More sharing options...
Heatherbell Posted September 20, 2019 Share Posted September 20, 2019 Try changing it to 20? Link to comment Share on other sites More sharing options...
♥peterpil19 Posted September 21, 2019 Share Posted September 21, 2019 @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 CE PHOENIX SUPPORTER 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 More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.