[Koha-patches] [PATCH] (bug #3925) fix build_holds_queue.pl

Nahuel ANGELINETTI nahuel.angelinetti at biblibre.com
Tue Dec 15 12:09:56 CET 2009


This fix sql query when item-level_itype is set to "off".
---
 misc/cronjobs/holds/build_holds_queue.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/misc/cronjobs/holds/build_holds_queue.pl b/misc/cronjobs/holds/build_holds_queue.pl
index 57e1183..febf90a 100755
--- a/misc/cronjobs/holds/build_holds_queue.pl
+++ b/misc/cronjobs/holds/build_holds_queue.pl
@@ -183,7 +183,7 @@ sub GetItemsAvailableToFillHoldRequestsForBib {
                            AND itemnumber IS NOT NULL
                            AND (found IS NOT NULL OR priority = 0)
                         )
-                       AND biblionumber = ?";
+                       AND items.biblionumber = ?";
     my @params = ($biblionumber, $biblionumber);
     if ($#branches_to_use > -1) {
         $items_query .= " AND holdingbranch IN (" . join (",", map { "?" } @branches_to_use) . ")";
-- 
1.6.3.3




More information about the Koha-patches mailing list