Menu

#2 (0.9) MySql5: Out of range value for column 'percent'

open
nobody
bugs (2)
5
2006-05-22
2006-05-22
No

Loading db\gal.sql or db\gal_it.sql into a MySQL
version 5 database causes a "Out of range value for
column 'percent'"

To fix, edit db\gal.sql (or db\gal_it.sql), find the
"CREATE TABLE `tax_rates` " code and change the column
percent from decimal(2,1) to decimal(3,1).

CREATE TABLE `tax_rates` (
`id` int(11) NOT NULL auto_increment,
`percent` decimal(3,1) default NULL,
`description` varchar(50) default NULL,
`code` int(11) default NULL,
`percent_no_ded` decimal(3,1) default '0.0',
PRIMARY KEY (`id`)
) TYPE=InnoDB;

Discussion


Log in to post a comment.