Bugzilla – Attachment 166218 Details for
Bug 36790
230600052.pl is failing
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36790: List table columns for 230600052 queries
Bug-36790-List-table-columns-for-230600052-queries.patch (text/plain), 3.40 KB, created by
Jonathan Druart
on 2024-05-06 12:19:12 UTC
(
hide
)
Description:
Bug 36790: List table columns for 230600052 queries
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2024-05-06 12:19:12 UTC
Size:
3.40 KB
patch
obsolete
>From 257ba2a4344ba6ea5a68d12437d498bf44a7c705 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 6 May 2024 12:58:33 +0200 >Subject: [PATCH] Bug 36790: List table columns for 230600052 queries > >We must list the columns, or the db rev will fail when a new column is >added. It happened here when 33478 added 'style' > >Also remove id and dates >--- > installer/data/mysql/db_revs/230600052.pl | 10 +++++++--- > 1 file changed, 7 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/db_revs/230600052.pl b/installer/data/mysql/db_revs/230600052.pl >index 416e30d42ec..5687d9040b4 100755 >--- a/installer/data/mysql/db_revs/230600052.pl >+++ b/installer/data/mysql/db_revs/230600052.pl >@@ -9,7 +9,8 @@ return { > > $dbh->do( > q{ >- INSERT IGNORE INTO `letter` VALUES (NULL,'reserves','HOLDDGST','','Hold available for pickup (digest)',0,'Hold(s) available for pickup','You have one or more holds available for pickup:\r\n\r\n----\r\nTitle: [% hold.biblio.title %]\r\nAuthor: [% hold.biblio.author %]\r\nCopy: [% hold.item.copynumber %]\r\nLocation: [% hold.branch.branchname %]\r\nWaiting since: [% hold.waitingdate %]\r\nWaiting at: [%hold.branch.branchname%]\r\n[% hold.branch.branchaddress1 %]\r\n[% hold.branch.branchaddress2 %]\r\n[% hold.branch.branchaddress3 %]\r\n[% hold.branch.branchcity %] [% hold.branch.branchzip %]\r\n----','email','default','2023-08-29 18:42:15'); >+ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) >+ VALUES ('reserves','HOLDDGST','','Hold available for pickup (digest)',0,'Hold(s) available for pickup','You have one or more holds available for pickup:\r\n\r\n----\r\nTitle: [% hold.biblio.title %]\r\nAuthor: [% hold.biblio.author %]\r\nCopy: [% hold.item.copynumber %]\r\nLocation: [% hold.branch.branchname %]\r\nWaiting since: [% hold.waitingdate %]\r\nWaiting at: [%hold.branch.branchname%]\r\n[% hold.branch.branchaddress1 %]\r\n[% hold.branch.branchaddress2 %]\r\n[% hold.branch.branchaddress3 %]\r\n[% hold.branch.branchcity %] [% hold.branch.branchzip %]\r\n----','email','default'); > } > ); > >@@ -17,7 +18,8 @@ return { > > $dbh->do( > q{ >- INSERT IGNORE INTO `letter` VALUES (NULL,'reserves','HOLDDGST','','Hold available for pickup (digest)',0,'Hold(s) available for pickup','You have one or more holds available for pickup:\r\n----\r\n[% hold.biblio.title %]\r\n----','sms','default','2023-08-29 18:42:15'); >+ INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) >+ VALUES ('reserves','HOLDDGST','','Hold available for pickup (digest)',0,'Hold(s) available for pickup','You have one or more holds available for pickup:\r\n----\r\n[% hold.biblio.title %]\r\n----','sms','default'); > } > ); > >@@ -25,7 +27,9 @@ return { > > $dbh->do( > q{ >- INSERT IGNORE INTO message_transports VALUES >+ INSERT IGNORE INTO message_transports >+ (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`, `branchcode`) >+ VALUES > ( 4, "email", 1, "reserves", "HOLDDGST", "" ), > ( 4, "sms", 1, "reserves", "HOLDDGST", "" ), > ( 4, "phone", 1, "reserves", "HOLDDGST", ""); >-- >2.34.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36790
:
166204
|
166218
|
166220
|
166221