Bugzilla – Attachment 114676 Details for
Bug 16787
'Too many holds' message appears inappropriately and is missing data
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16787: Add noReservesAllowed to club holds
Bug-16787-Add-noReservesAllowed-to-club-holds.patch (text/plain), 2.38 KB, created by
Nick Clemens (kidclamp)
on 2020-12-23 15:07:17 UTC
(
hide
)
Description:
Bug 16787: Add noReservesAllowed to club holds
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2020-12-23 15:07:17 UTC
Size:
2.38 KB
patch
obsolete
>From afa39a7498b3077f904e74bf2cd35fc003310917 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Mon, 2 Mar 2020 16:49:16 +0000 >Subject: [PATCH] Bug 16787: Add noReservesAllowed to club holds > >--- > .../bug_16787_add_noReservesAllowed_to_club_holds.perl | 16 ++++++++++++++++ > installer/data/mysql/kohastructure.sql | 3 ++- > 2 files changed, 18 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl b/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl >new file mode 100644 >index 0000000000..7cd3fc669a >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_16787_add_noReservesAllowed_to_club_holds.perl >@@ -0,0 +1,16 @@ >+$DBversion = 'XXX'; >+if( CheckVersion( $DBversion ) ) { >+ $dbh->do(q{ >+ ALTER TABLE club_holds_to_patron_holds >+ MODIFY COLUMN error_code >+ ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold', >+ 'tooManyHoldsForThisRecord', 'tooManyReservesToday', >+ 'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches', >+ 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred', >+ 'noReservesAllowed' >+ ) >+ }); >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 16787: Add noReservesAllowed to club holds error codes)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index ef3bff04b0..e458575a7b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4236,7 +4236,8 @@ CREATE TABLE IF NOT EXISTS club_holds_to_patron_holds ( > error_code ENUM ( 'damaged', 'ageRestricted', 'itemAlreadyOnHold', > 'tooManyHoldsForThisRecord', 'tooManyReservesToday', > 'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches', >- 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred' >+ 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred', >+ 'noReservesAllowed' > ) NULL DEFAULT NULL, > error_message varchar(100) NULL DEFAULT NULL, > PRIMARY KEY (id), >-- >2.11.0
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 16787
:
52652
|
68894
|
68895
|
72827
|
72828
|
72889
|
91146
|
91147
|
91148
|
91149
|
96152
|
97403
|
99949
|
99950
|
100951
|
101473
|
101474
|
101475
|
101895
|
107793
|
107794
|
107795
|
114675
|
114676
|
114677
|
119279
|
119280
|
119281
|
119335
|
119336
|
119337
|
119616
|
119617
|
119619
|
119620
|
119621
|
119622
|
119623
|
119738
|
119739
|
119740
|
119741
|
119942
|
120009