From 3f2f015dea30c93ba673c3777d2d97166520f91e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 27 Mar 2014 13:14:08 +0100 Subject: [PATCH] Bug 7567: QA followup: FIX SQL query The WHERE clause should not erase $query. Signed-off-by: Jonathan Druart --- C4/NewsChannels.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 7c413aa..acefb70 100644 --- a/C4/NewsChannels.pm +++ b/C4/NewsChannels.pm @@ -150,7 +150,7 @@ sub get_opac_news { FROM opac_news LEFT JOIN branches ON opac_news.branchcode=branches.branchcode }; - $query = ' WHERE 1'; + $query .= ' WHERE 1'; if ($lang) { $query .= " AND (opac_news.lang='' OR opac_news.lang=?)"; push @values,$lang; -- 1.7.10.4