Bugzilla – Attachment 94178 Details for
Bug 23805
Add a dedicated credit_types table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23049: (follow-up) Handle unexpected types
Bug-23049-follow-up-Handle-unexpected-types.patch (text/plain), 1.32 KB, created by
Martin Renvoize (ashimema)
on 2019-10-15 11:06:07 UTC
(
hide
)
Description:
Bug 23049: (follow-up) Handle unexpected types
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-10-15 11:06:07 UTC
Size:
1.32 KB
patch
obsolete
>From ee84870d972c5339bf7d3311c8d057a63eef1f0c Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Tue, 15 Oct 2019 12:00:41 +0100 >Subject: [PATCH] Bug 23049: (follow-up) Handle unexpected types > >https://bugs.koha-community.org/show_bug.cgi?id=23805 >--- > .../mysql/atomicupdate/bug_23805_credit.perl | 21 +++++++++++++++++++ > 1 file changed, 21 insertions(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_23805_credit.perl b/installer/data/mysql/atomicupdate/bug_23805_credit.perl >index 27896d0313..f914b85cdd 100644 >--- a/installer/data/mysql/atomicupdate/bug_23805_credit.perl >+++ b/installer/data/mysql/atomicupdate/bug_23805_credit.perl >@@ -101,6 +101,27 @@ if ( CheckVersion($DBversion) ) { > } > ); > >+ # Add any unexpected accounttype codes to credit_types as appropriate >+ $dbh->do( >+ qq{ >+ INSERT IGNORE INTO account_credit_types ( >+ code, >+ description, >+ can_be_added_manually, >+ is_system >+ ) >+ SELECT >+ SUBSTR(accounttype, 1, 80), >+ "Unexpected type found during upgrade", >+ 1, >+ 0 >+ FROM >+ accountlines >+ WHERE >+ amount < 0 >+ } >+ ); >+ > # Populating credit_type_code > $dbh->do( > qq{ >-- >2.20.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 23805
:
94153
|
94154
|
94155
|
94156
|
94157
|
94158
|
94159
|
94160
|
94161
|
94162
|
94163
|
94164
|
94166
|
94167
|
94168
|
94169
|
94170
|
94171
|
94172
|
94173
|
94174
|
94175
|
94176
|
94177
|
94178
|
94801
|
94815
|
94832
|
94895