Summary: | Validation for biblioitems in about/system information joins on biblionumber not biblioitemnumber | ||
---|---|---|---|
Product: | Koha | Reporter: | Lisette Scheer <lisette> |
Component: | About | Assignee: | 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
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! 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. |