Bugzilla – Attachment 110935 Details for
Bug 26268
Remove items.paid for once and for all
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26268: Fix deleteditems query in DB rev
Bug-26268-Fix-deleteditems-query-in-DB-rev.patch (text/plain), 912 bytes, created by
Jonathan Druart
on 2020-09-29 15:06:24 UTC
(
hide
)
Description:
Bug 26268: Fix deleteditems query in DB rev
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-09-29 15:06:24 UTC
Size:
912 bytes
patch
obsolete
>From c22259d53578878a991b436deee8371aeb6dc040 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Tue, 29 Sep 2020 17:05:54 +0200 >Subject: [PATCH] Bug 26268: Fix deleteditems query in DB rev > >--- > installer/data/mysql/atomicupdate/bug_26268.perl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_26268.perl b/installer/data/mysql/atomicupdate/bug_26268.perl >index 152f10998d..b5291f6209 100644 >--- a/installer/data/mysql/atomicupdate/bug_26268.perl >+++ b/installer/data/mysql/atomicupdate/bug_26268.perl >@@ -22,7 +22,7 @@ if ( CheckVersion($DBversion) ) { > my ($count) = $dbh->selectrow_array( > qq| > SELECT COUNT(*) >- FROM items >+ FROM deleteditems > WHERE paidfor IS NOT NULL AND paidfor <> "" > | > ); >-- >2.20.1
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=110935">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 26268
:
108797
|
108799
|
108807
|
108808
|
108809
|
108810
|
108812
|
108813
|
108814
|
109674
|
109675
|
109676
|
109677
|
109930
|
109931
|
109932
|
109933
|
109934
|
110801
|
110802
|
110803
|
110804
|
110805
|
110806
|
110836
|
110837
|
110838
|
110839
|
110840
|
110841
| 110935