Bug 31297: Allow null value for description in subscription_numberpatterns
authorNick Clemens <nick@bywatersolutions.com>
Fri, 22 Dec 2023 14:52:04 +0000 (14:52 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Wed, 3 Jan 2024 15:40:37 +0000 (16:40 +0100)
commit17322360279a1a20e0e1f007847d1cb422df685a
treea9142df9b965e26dbdb177cdf16ebe70abeb5298
parent31a356afd35a8c8e48947faab7599089ab0500ed
Bug 31297: Allow null value for description in subscription_numberpatterns

To test:
1 - Go to Serials
2 - Add a enw subscription
3 - Select Vendor and record, click next
4 - Select Numbring pattern: Number, or any to populate forms
4 - Click 'show advanced pattern'
5 - 'Modify pattern'
6 - Add a new name
7 - 'Save as new pattern'
8 - Nothin happens
9 - Check logs:
    C4::Serials::Numberpattern::AddSubscriptionNumberpattern(): DBI Exception: DBD::mysql::st execute failed: Field 'description' doesn't have a default value at /kohadevbox/koha/serials/create-numberpattern.pl line 58
10 - Apply patch
11 - Update database
12 - Restart all
13 - Click save again
14 - Success!

Signed-off-by: Andrew Fuerste-Henry <andrewfh@dubcolib.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Removed wrong 'out' from atomic update file.

Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
(cherry picked from commit f9b57c5342641e1b8efa68aa202857edadb8f605)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql