https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19259 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=13624 --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Marc, % git checkout 0aa6ba1599bb0de923619a365f529119dc5c67a6 # DBrev 3.23.00.006 % reset_all
SHOW CREATE TABLE overduerules_transport_types; | overduerules_transport_types | CREATE TABLE `overduerules_transport_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `branchcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `categorycode` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `letternumber` int(1) NOT NULL DEFAULT '1', `message_transport_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'email', PRIMARY KEY (`id`), KEY `overduerules_fk` (`branchcode`,`categorycode`), KEY `mtt_fk` (`message_transport_type`), CONSTRAINT `mtt_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `overduerules_fk` FOREIGN KEY (`branchcode`, `categorycode`) REFERENCES `overduerules` (`branchcode`, `categorycode`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
% git checkout master % restart_all % sudo koha-shell kohadev % perl installer/data/mysql/updatedatabase.pl
SHOW CREATE TABLE overduerules_transport_types; | overduerules_transport_types | CREATE TABLE `overduerules_transport_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `letternumber` int(1) NOT NULL DEFAULT '1', `message_transport_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'email', `overduerules_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `mtt_fk` (`message_transport_type`), KEY `overduerules_transport_types_fk` (`overduerules_id`), CONSTRAINT `mtt_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `overduerules_transport_types_fk` FOREIGN KEY (`overduerules_id`) REFERENCES `overduerules` (`overduerules_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
Without data it seems that the update works fine. Maybe you got some errors during the upgrade? Is it a DB in production? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.