Back to bug 35654

Who When What Removed Added
magnus 2024-04-04 08:41:06 UTC CC magnus
enica 2024-04-04 20:04:25 UTC Summary Add option to delete last item to delete_items.pl Add option to delete_items.pl to delete record if existing item getting deleted is the only one attached to the bib
angela.berrett 2024-04-05 17:11:40 UTC CC angela.berrett
andrew 2024-11-07 16:13:15 UTC CC andrew
mspinney 2024-11-12 19:00:35 UTC CC mspinney
blawlor 2024-11-14 01:45:46 UTC Status NEW Needs Signoff
andrew 2024-11-14 14:26:26 UTC Status Needs Signoff Signed Off
andrew 2024-11-14 14:26:28 UTC Attachment #174480 Attachment is obsolete 0 1
andrew 2024-12-04 15:38:50 UTC Assignee koha-bugs blawlor
emily.lamancusa 2024-12-17 16:49:50 UTC CC emily.lamancusa
blawlor 2024-12-17 17:45:28 UTC Status Signed Off Needs Signoff
blawlor 2025-01-22 20:35:36 UTC Patch complexity --- Small patch
blawlor 2025-01-22 20:35:38 UTC Attachment #175208 Attachment is obsolete 0 1
Attachment #175194 Attachment is obsolete 0 1
Attachment #174529 Attachment is obsolete 0 1
Attachment #175209 Attachment is obsolete 0 1
Attachment #175195 Attachment is obsolete 0 1
Attachment #175193 Attachment is obsolete 0 1
andrew 2025-01-22 21:20:27 UTC Status Needs Signoff Signed Off
andrew 2025-01-22 21:20:29 UTC Attachment #176936 Attachment is obsolete 0 1
lucas 2025-02-11 17:37:02 UTC CC lucas
Status Signed Off Patch doesn't apply
jonathan.druart 2025-02-12 13:27:54 UTC Status Patch doesn't apply Signed Off
jonathan.druart 2025-02-12 13:27:57 UTC Attachment #176937 Attachment is obsolete 0 1
jonathan.druart 2025-02-12 13:28:05 UTC CC jonathan.druart
m.de.rooy 2025-03-07 10:18:28 UTC Status Signed Off Failed QA
blawlor 2025-03-24 20:26:37 UTC Status Failed QA Signed Off
blawlor 2025-03-24 20:26:40 UTC Attachment #177868 Attachment is obsolete 0 1
kyle 2025-08-14 16:00:08 UTC CC kyle
Status Signed Off Failed QA
blawlor 2025-08-14 18:07:16 UTC Status Failed QA Needs Signoff
blawlor 2025-08-14 18:19:04 UTC Text to go in the release notes This patch updates the delete_items script to use Koha::Items->search instead of a direct database query.

Using a --where option that refers to the items table by name such as:
./misc/cronjobs/delete_items.pl --where "items.withdrawn = 0"

will no longer work and result in an error:
execute failed: Unknown column 'items.withdrawn' in 'where clause'

Use the --where option without naming the items table instead:
./misc/cronjobs/delete_items.pl --where "withdrawn = 0"
andrew 2025-08-14 19:27:14 UTC Status Needs Signoff Signed Off
andrew 2025-08-14 19:27:17 UTC Attachment #179675 Attachment is obsolete 0 1
andrew 2025-08-14 19:27:21 UTC Attachment #185416 Attachment is obsolete 0 1
kyle 2025-08-19 13:28:55 UTC QA Contact testopia kyle
kyle 2025-08-19 13:30:37 UTC Attachment #185425 Attachment is obsolete 0 1
kyle 2025-08-19 13:30:50 UTC Attachment #185426 Attachment is obsolete 0 1
kyle 2025-08-19 13:32:56 UTC Status Signed Off Passed QA

Back to bug 35654