http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3796
Barton Chittenden <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P3 CC| |[email protected] --- Comment #2 from Barton Chittenden <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
