From 53dd35a913bfcf625eb797d23d2b49ed54f5a246 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) This patch could be moved to its own bug report if we want to adjust tests. --- 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