[Koha-bugs] [Bug 19259] Overdue rules do not save
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Sep 7 17:45:51 CEST 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19259
Jonathan Druart <jonathan.druart at 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 at 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.
More information about the Koha-bugs
mailing list