From 6066683ec59bbea1c131605f92d73302a3bc70d6 Mon Sep 17 00:00:00 2001 From: Brendan Lawlor 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' --- 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 ebf2738acc..53e5e88e39 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