[Koha-bugs] [Bug 22291] 'Batch modify' button on itemnumber causes internal server error if itemnumbers do not correspond to real items.

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22291

--- Comment #1 from Barton Chittenden <barton at bywatersolutions.com> ---
Note that even though the query that I used to illustrate this problem won't
ever occur in production, this was triggered by a real report, that looked
something like this:

SELECT
    aqbasket.basketname,
    aqbasket.closedate,
    aqorders.biblionumber,
    aqorders_items.itemnumber,
    items.itemnumber AS 'items.itemnumber',
    biblio.title,
    items.barcode 
FROM
    aqbasket
    LEFT JOIN aqorders USING (basketno)
    LEFT JOIN aqorders_items on (aqorders.ordernumber =
aqorders_items.ordernumber)
    LEFT JOIN biblio on (aqorders.biblionumber = biblio.biblionumber)
    LEFT JOIN items on (aqorders_items.itemnumber = items.itemnumber)
WHERE
    aqbasket.basketname='XXXXXXXXXXXXXX'
GROUP BY
    aqorders_items.itemnumber

The 'Batch Modify' button was attached to the 'aqorders_items.itemnumber'
column, and there were instances where that was populated, even when
'items.itemnumber' was NULL.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.