[Koha-bugs] [Bug 3796] Place a hold on a specific copy allows impossible items

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3796

Barton Chittenden <barton at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P5 - low                    |P3
                 CC|                            |barton at bywatersolutions.com

--- Comment #2 from Barton Chittenden <barton at bywatersolutions.com> ---
I have a user who reports inconsistent display of bar codes in the holds queue:

When I view the holds queue for biblionumber 290651

http:// ... /cgi-bin/koha/reserve/request.pl?biblionumber=290651

+------------+---------------------+-------+-----------+-----------+-----------------------+------------------------+
|Priority    |Patron               |Notes  |Date       |Expiration |Pickup
library         |Details                 |
+------------+---------------------+-------+-----------+-----------+-----------------------+------------------------+
|In Transit  |Test3 CCC            |       |04/18/2014 |           |Waiting to
be pulled   |50610019572606          |
|1           |Test1 AAA            |       |03/25/2014 |           |Post Falls
Library     |Only item 50610018605688|
|2           |Test2 BBB            |       |04/12/2014 |           |Coer
d'Alene Library   |Only item 50610019575724| <= Link under barcode points to
correct bib, but barcode is wrong.
|3           |Test4 DDD            |       |04/14/2014 |           |Post Falls
Library     |Next available          |
+------------+---------------------+-------+-----------+-----------+-----------------------+------------------------+

The link under the barcode in the details http:// ...
/cgi-bin/koha/catalogue/detail.pl?biblionumber=290651 points to the correct
bib, titled 'Four blood moons /'.

If you search for the item with barcode '50610019575724', the title is
'Frozen', the itemnumber is '688025' and it has biblionumber 296437.

In other words the reserves.biblionumber and reserves.itemnumber do not agree.

select borrowernumber, firstname, surname, biblio.title, biblio.biblionumber as
'biblio biblionumber', reserves.biblionumber as 'reserves biblionumber',
barcode, itemnumber from reserves inner join items using (itemnumber) inner
join biblio on (items.biblionumber = biblio.biblionumber) inner join borrowers
using (borrowernumber) where reserves.biblionumber=290651;
+----------------+---------------+---------+--------------------+---------------------+-----------------------+----------------+------------+
| borrowernumber | firstname     | surname | title              | biblio
biblionumber | reserves biblionumber | barcode        | itemnumber |
+----------------+---------------+---------+--------------------+---------------------+-----------------------+----------------+------------+
|        1047659 | Test1         | AAA     | Four blood moons / |             
290651 |                290651 | 50610018605688 |     671064 |
|        1148679 | Test2         | BBB     | Frozen             |             
296437 |                290651 | 50610019575724 |     688025 |
|        1101608 | Test3         | CCC     | Four blood moons / |             
290651 |                290651 | 50610019572606 |     686626 |
+----------------+---------------+---------+--------------------+---------------------+-----------------------+----------------+------------+
3 rows in set (0.00 sec)

I don't have a description of how this occurred, but if resrerves.itemnumber is
not NULL, items.itemnumber and reserves.itemnumber should match.

I've also bumped the priority on this ticket.

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