[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