Bug 40740

Summary: Validation for biblioitems in about/system information joins on biblionumber not biblioitemnumber
Product: Koha Reporter: Lisette Scheer <lisette>
Component: AboutAssignee: Lisette Scheer <lisette>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: david
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
This patch fixes an issue where the about page warns incorrectly when there are items in both the biblioitems and deletedbiblioitems tables on the same record.
Version(s) released in:
Circulation function:
Bug Depends on: 35033    
Bug Blocks:    
Attachments: Bug 40740: Validation for biblioitems in about/system information joins on biblionumber not biblioitemnumber

Description Lisette Scheer 2025-09-02 15:28:27 UTC
select bi.biblioitemnumber, dbi.biblioitemnumber from biblioitems bi join deletedbiblioitems dbi on bi.biblionumber=dbi.biblionumber  

Warns if there's items from the same biblio, one not deleted, one is deleted.
Comment 1 Lisette Scheer 2025-09-02 15:36:34 UTC
Created attachment 186056 [details] [review]
Bug 40740: Validation for biblioitems in about/system information joins on biblionumber not biblioitemnumber

This patche fixes the validation for biblioitems to only warn when the biblioitemnumber is in both tables instead of the biblionumber.

To test:
1. Delete an item that has another item on the record.
2. Go to About and select the system configuration tab
3. Observe there is a warning.
4. Run a report select bi.biblioitemnumber, dbi.biblioitemnumber from biblioitems bi join deletedbiblioitems dbi on bi.biblionumber=dbi.biblionumber
5. You'll see the numbers don't match
6. Apply the patch
7. Repeat step 2
8. Observe no warning
9. Repeat step 4
10. Observe no results.
11. Sign off!
Comment 2 David Nind 2025-09-06 03:37:07 UTC
I didn't get a warning on the system information tab.

I deleted one of the items for Effective Perl programming (biblionumber = 139), in the default KTD it has two items.