[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #19 from Andrew Fuerste-Henry --- (or, rather, missing dependencies) -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Andrew Fuerste-Henry changed: What|Removed |Added CC||and...@bywatersolutions.com Resolution|--- |FIXED Status|Pushed to stable|RESOLVED --- Comment #18 from Andrew Fuerste-Henry --- enhancement, not backported to 20.05 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Fridolin Somers changed: What|Removed |Added Version(s)|21.05.00|21.05.00,20.11.04 released in|| CC||fridolin.som...@biblibre.co ||m Status|Pushed to master|Pushed to stable --- Comment #17 from Fridolin Somers --- Pushed to 20.11.x for 20.11.04 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #16 from Jonathan Druart --- Pushed to master for 21.05, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Jonathan Druart changed: What|Removed |Added Status|Passed QA |Pushed to master Version(s)||21.05.00 released in|| -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Martin Renvoize changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Martin Renvoize changed: What|Removed |Added CC||martin.renvoize@ptfs-europe ||.com Status|Needs Signoff |Signed Off --- Comment #15 from Martin Renvoize --- I've tested this with an old database that had the problem during upgrades. The patch reads well and works as expected on MySQL 5.5, MariaDB and MySQL 8 in my tests. Going for a straight QA here. Passed -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Martin Renvoize changed: What|Removed |Added Attachment #115848|0 |1 is obsolete|| --- Comment #14 from Martin Renvoize --- Created attachment 117176 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=117176=edit Bug 27534: Add missing ON UPDATE/DELETE clause to message_transport_type_fk Bug 9016 (3.15.00.039) added message_transport_type_fk but the ON DELETE CASCADE ON UPDATE CASCADE clause was missing from the updatedatabase entry. If we are upgrading from an old version, 20.06.00.058 will fail on updating the message_transport_type, with "Cannot delete or update a parent row: a foreign key constraint fails". Signed-off-by: Martin Renvoize -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #13 from Manos PETRIDIS --- I believe they may: ALTER TABLE letter DROP CONSTRAINT message_transport_type_fk ALTER TABLE letter ADD CONSTRAINT message_transport_type_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types(message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE Generally speaking, a foreign key can be used for improved preformance (hint for implicit joins) even if no rules (constraints) are defined for data referential integrity. Foreign keys may well be defined without corresponding constraints, as it was apparently the case in older koha DBs. Constraints howerver need to be supported by indexes and foreign key definitions in order to enforce data integrity rules in time. In any case, all's well that ends well :-) -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #12 from Jonathan Druart --- (In reply to Jonathan Druart from comment #11) > (In reply to Manos PETRIDIS from comment #10) > > If I read correctly the patch you supplied, you drop FOREIGN KEY > > message_transport_type_fk in letter table. As far as I know though, one > > doesn't need to drop the FOREIGN KEY altogether, just drop the CONSTRAINT > > and re-create it, including the missing CASCADE clause. > > It's exactly what the patch does :) It drops the FK and recreate it it with the correct CONSTRAINT. AFAIK it's not possible to do it without removing the FK. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #11 from Jonathan Druart --- (In reply to Manos PETRIDIS from comment #10) > If I read correctly the patch you supplied, you drop FOREIGN KEY > message_transport_type_fk in letter table. As far as I know though, one > doesn't need to drop the FOREIGN KEY altogether, just drop the CONSTRAINT > and re-create it, including the missing CASCADE clause. It's exactly what the patch does :) -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #10 from Manos PETRIDIS --- (In reply to Jonathan Druart from comment #9) > Manos, it means you already have it in the table. > > MariaDB [koha_kohadev]> select count(*) from letter where > message_transport_type="phone"; > +--+ > | count(*) | > +--+ > |1 | > +--+ > 1 row in set (0.000 sec) > > MariaDB [koha_kohadev]> UPDATE message_transport_types SET > message_transport_type = "xxx" WHERE message_transport_type = "phone"; > Query OK, 1 row affected (0.019 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > MariaDB [koha_kohadev]> select count(*) from letter where > message_transport_type="xxx"; > +--+ > | count(*) | > +--+ > |1 | > +--+ > 1 row in set (0.002 sec) > > > That seems to work for me. The error originally reported was DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha_usmarc`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone" "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23192. Upgrade to 20.06.00.058 done [00:14:07]: Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva" ... and Kyle HALL noted that it may be due to a missing "ON UPDATE CASCADE" on the `letter` table. I followed the test he suggested and verified that in my installation the update failed. If I read correctly the patch you supplied, you drop FOREIGN KEY message_transport_type_fk in letter table. As far as I know though, one doesn't need to drop the FOREIGN KEY altogether, just drop the CONSTRAINT and re-create it, including the missing CASCADE clause. I was then able to sucessufuly perform the test update UPDATE message_transport_types SET message_transport_type = "asdf" WHERE message_transport_type = "email" . I understand that I have to run UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone" so that the correction in Bug 25333 is performed, but apart from that, what is that I already have [some] table? -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #9 from Jonathan Druart --- Manos, it means you already have it in the table. MariaDB [koha_kohadev]> select count(*) from letter where message_transport_type="phone"; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.000 sec) MariaDB [koha_kohadev]> UPDATE message_transport_types SET message_transport_type = "xxx" WHERE message_transport_type = "phone"; Query OK, 1 row affected (0.019 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [koha_kohadev]> select count(*) from letter where message_transport_type="xxx"; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.002 sec) That seems to work for me. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #8 from Manos PETRIDIS --- I don't think that I can test the patch Jonathan, as I'm not running a git installation, but one based on koha packages. I can report though that the mere addition of "ON DELETE CASCADE ON UPDATE CASCADE" won't do he trick in an existing db, as it comes up with Kernel error: Error( 1005 ) HY000: "Can't create table `koha_usmarc`.`letter` (errno: 121 "Duplicate key on write or update")" What I have done is first ALTER TABLE letter drop CONSTRAINT message_transport_type_fk 01:12:50 Query time: 91 millisecond(s) 01:12:50 Query has been executed and then ALTER TABLE letter ADD CONSTRAINT message_transport_type_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types(message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE 01:13:21 Query time: 518 millisecond(s), Number of affected records: 62 01:13:21 Number of affected rows: 62 Having done that, the failing update now works fine UPDATE message_transport_types SET message_transport_type = "asdf" WHERE message_transport_type = "email" 01:13:51 Query time: 223 millisecond(s), Number of affected records: 1 01:13:51 Number of affected rows: 1 01:13:51 UPDATE message_transport_types SET message_transport_type = "asdf" WHERE message_transport_type = "email" -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #7 from Jonathan Druart --- Manos, could you test this patch? -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #6 from Manos PETRIDIS --- Indeed, my database begun its life in a 3.08 installation, if memory serves. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #5 from Jonathan Druart --- Manos, can you confirm you are upgrading from an old version (older than 3.15.00.039)? This patch should fix the problem, there was missing the ON DELETE CASCADE ON UPDATE CASCADE part on the FK. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #4 from Jonathan Druart --- Created attachment 115848 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=115848=edit Bug 27534: Add missing ON UPDATE/DELETE clause to message_transport_type_fk Bug 9016 (3.15.00.039) added message_transport_type_fk but the ON DELETE CASCADE ON UPDATE CASCADE clause was missing from the updatedatabase entry. If we are upgrading from an old version, 20.06.00.058 will fail on updating the message_transport_type, with "Cannot delete or update a parent row: a foreign key constraint fails". -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Jonathan Druart changed: What|Removed |Added Status|ASSIGNED|Needs Signoff -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Jonathan Druart changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |jonathan.dru...@bugs.koha-c |ity.org |ommunity.org Depends on||9016 Status|NEW |ASSIGNED Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9016 [Bug 9016] Multi transport types for notices -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #3 from Manos PETRIDIS --- I'm running mariadb 1:10.4.17+maria~stretch on Debian GNU/Linux 9.12 (stretch) with Linux 4.9.0-14-amd64 kernel. Pretty standard I understand. 'UPDATE message_transport_types SET message_transport_type = "asdf" WHERE message_transport_type = "email"' comes up with: 08:45:26 Kernel error: Error( 1451 ) 23000: "Cannot delete or update a parent row: a foreign key constraint fails (`koha_usmarc`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`))" ...while 'SHOW CREATE TABLE letter' produces: INSERT INTO ``( `Table`, `Create Table` ) VALUES ( 'letter', 'CREATE TABLE `letter` ( `module` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT , `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT , `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT , `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT , `is_html` tinyint(1) DEFAULT 0, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT , `content` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message_transport_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''email'', `lang` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''default'', `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`module`,`code`,`branchcode`,`message_transport_type`,`lang`), KEY `message_transport_type_fk` (`message_transport_type`), CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' ); When were these FK and CONSTRAINT introduced in the database? In my case, upgrade steps begun with 'Upgrade to 20.06.00.023', therefore I gather that they were not [both] present at 20.06.00.022. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #2 from Kyle M Hall --- This is, 'SHOW CREATE TABLE letter' should have this in it: CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #1 from Kyle M Hall --- It sounds like your database structure isn't quite right, unless it's a bug in your database software version. I did the following to test and it worked: UPDATE message_transport_types SET message_transport_type = "asdf" WHERE message_transport_type = "email" Maybe your FK on `letter` is missing it's "ON UPDATE CASCADE"? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Jonathan Druart changed: What|Removed |Added Depends on||25333 Severity|enhancement |major URL|https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=25333 | CC||jonathan.dru...@bugs.koha-c ||ommunity.org, ||k...@bywatersolutions.com Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25333 [Bug 25333] Change message transport type for Talking Tech from "phone" to "itiva" -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 Manos PETRIDIS changed: What|Removed |Added URL||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=25333 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/