From 3e8f5c1a91928b7e75768625885e6f92d7573771 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Sun, 20 Oct 2019 10:16:51 +0200 Subject: [PATCH] Bug 18743: Correct number of pending suggestions (acq home page) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit This patch could be moved to its own bug report if we want to adjust tests. Sponsored-by: BULAC - http://www.bulac.fr/ Signed-off-by: Séverine QUEUNE Signed-off-by: Séverine QUEUNE Signed-off-by: Nick Clemens --- C4/Suggestions.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm index 15b02c51fa..764c331752 100644 --- a/C4/Suggestions.pm +++ b/C4/Suggestions.pm @@ -414,7 +414,7 @@ sub CountSuggestion { FROM suggestions LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby WHERE STATUS=? - AND (borrowers.branchcode='' OR borrowers.branchcode=?) + AND (suggestions.branchcode='' OR suggestions.branchcode=?) }; $sth = $dbh->prepare($query); $sth->execute( $status, $userenv->{branch} ); -- 2.11.0