https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34428 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |23995 CC| |jonathan.druart+koha@gmail. | |com --- Comment #1 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Bug 23995 removed it from kohastructure.sql but still exists in updatedatabase.pl Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23995 [Bug 23995] Check constraints are supported differently by MySQL and MariaDB so we should remove them for now. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34428 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Jonathan Druart from comment #1)

Bug 23995 removed it from kohastructure.sql but still exists in updatedatabase.pl

That's not great... right? It's this update here, still in updatedatabase: $DBversion = "3.09.00.037"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('UseTransportCostMatrix',0,'Use Transport Cost Matrix when filling holds','','YesNo')"); $dbh->do("CREATE TABLE `transport_cost` ( `frombranch` varchar(10) NOT NULL, `tobranch` varchar(10) NOT NULL, `cost` decimal(6,2) NOT NULL, `disable_transfer` tinyint(1) NOT NULL DEFAULT 0, CHECK ( `frombranch` <> `tobranch` ), -- a dud check, mysql does not support that PRIMARY KEY (`frombranch`, `tobranch`), CONSTRAINT `transport_cost_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `transport_cost_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8"); print "Upgrade to $DBversion done (creating `transport_cost` table; adding UseTransportCostMatrix systempref, in circulation)\n"; SetVersion($DBversion); } Should we fix and try to drop the CHECK in a database update? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34428 Indranil Das Gupta <indradg@l2c2.co.in> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |indradg@l2c2.co.in -- You are receiving this mail because: You are watching all bug changes.