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.
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.