http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10490
--- Comment #1 from Galen Charlton <[email protected]> --- Nice catch. Also, oops. Also, we really ought to be counting everything in pennies and not use decimal data types for currencies. Regardless, I think altering the column type to decimal(28,6) should do the trick and preserve existing values: MariaDB [koha]> create table tmp (overduefinescap decimal null); Query OK, 0 rows affected (0.05 sec) MariaDB [koha]> insert into tmp values (1.25); Query OK, 1 row affected, 1 warning (0.00 sec) MariaDB [koha]> select * from tmp; +-----------------+ | overduefinescap | +-----------------+ | 1 | +-----------------+ 1 row in set (0.00 sec) MariaDB [koha]> alter table tmp modify column overduefinescap decimal(28,6) null; Query OK, 1 row affected (0.06 sec) Records: 1 Duplicates: 0 Warnings: 0 MariaDB [koha]> select * from tmp; +-----------------+ | overduefinescap | +-----------------+ | 1.000000 | +-----------------+ 1 row in set (0.00 sec) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
