Bugzilla – Attachment 185426 Details for
Bug 35654
Add option to delete_items.pl to delete record if existing item getting deleted is the only one attached to the bib
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35654: (follow-up) Update example script to be compatible with change to using Koha::Items
Bug-35654-follow-up-Update-example-script-to-be-co.patch (text/plain), 1.35 KB, created by
Andrew Fuerste-Henry
on 2025-08-14 19:27:21 UTC
(
hide
)
Description:
Bug 35654: (follow-up) Update example script to be compatible with change to using Koha::Items
Filename:
MIME Type:
Creator:
Andrew Fuerste-Henry
Created:
2025-08-14 19:27:21 UTC
Size:
1.35 KB
patch
obsolete
>From 24dffce0aa4e104af168a29c8ee1f7f00c6a784d Mon Sep 17 00:00:00 2001 >From: Brendan Lawlor <blawlor@clamsnet.org> >Date: Thu, 14 Aug 2025 18:00:59 +0000 >Subject: [PATCH] Bug 35654: (follow-up) Update example script to be compatible > with change to using Koha::Items > >Since this patch updates the script to use Koha::Items->search instead of a direct database query >--where options that refer to the items table will be broken and result in an error like: >execute failed: Unknown column 'items.withdrawn' in 'where clause' > >Signed-off-by: Andrew Fuerste Henry <andrew@bywatersolutions.com> >--- > misc/cronjobs/delete_items.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/misc/cronjobs/delete_items.pl b/misc/cronjobs/delete_items.pl >index ebf2738acc8..53e5e88e39d 100755 >--- a/misc/cronjobs/delete_items.pl >+++ b/misc/cronjobs/delete_items.pl >@@ -135,7 +135,7 @@ Deletes the bibliographic record if the last item is deleted. > > The following is an example of this script: > >- delete_items.pl --where "items.withdrawn ! 0" --where "items.withdrawn_on < $(date --date="13 month ago" --rfc-3339=date)" --commit >+ delete_items.pl --where "withdrawn ! 0" --where "withdrawn_on < $(date --date="13 month ago" --rfc-3339=date)" --commit > > delete_items.pl --where "itemlost >= '1'" --where "itemlost <='4'" --where "itemlost_on < '2014-04-28'" --commit > >-- >2.39.5
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 35654
:
174480
|
174529
|
175193
|
175194
|
175195
|
175208
|
175209
|
176936
|
176937
|
177868
|
179675
|
185416
|
185425
|
185426
|
185539
|
185540