From f355788b340b19912891fd41c3168bac9c951aff Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 27 Feb 2019 16:05:20 -0300 Subject: [PATCH] Bug 21747: Insert fine_increase and fine_decrease for new installs This fixes Circulation.t koha_1 | DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_kohadev`.`account_offsets`, CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "INSERT INTO `account_offsets` ( `amount`, `debit_id`, `type`) VALUES ( ?, ?, ? )" with ParamValues: 0=1, 1='22', 2='fine_increase'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. Signed-off-by: Jonathan Druart Signed-off-by: Nick Clemens --- installer/data/mysql/account_offset_types.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/account_offset_types.sql b/installer/data/mysql/account_offset_types.sql index 083e56ca21..ad79879327 100644 --- a/installer/data/mysql/account_offset_types.sql +++ b/installer/data/mysql/account_offset_types.sql @@ -9,7 +9,8 @@ INSERT INTO account_offset_types ( type ) VALUES ('Forgiven'), ('Dropbox'), ('Rental Fee'), -('Fine Update'), +('fine_increase'), +('fine_decrease'), ('Fine'), ('Void Payment'), ('Credit Applied'); -- 2.39.5