[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534

--- Comment #9 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
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.