From 23af1c4a89afff6bba79189a6781e2309007d0f4 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. Signed-off-by: Séverine QUEUNE Signed-off-by: Séverine QUEUNE --- C4/Suggestions.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm index 15b02c5..764c331 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.7.4