From 17003e56df810bf33ada03d49b02618ec41b6eee Mon Sep 17 00:00:00 2001 From: Colin Campbell Date: Fri, 14 May 2010 17:24:13 +0100 Subject: [PATCH] Bug 4507 Don't return null vendor to claims processing The empty vendor created by the select if any subscriptions have no associated vendor generates a 'wrong-looking' display and selecting it gives no options Signed-off-by: Galen Charlton --- C4/Serials.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index bca9fc85de..f8a9bf5d98 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -96,7 +96,7 @@ sub GetSuppliersWithLateIssues { FROM subscription LEFT JOIN serial ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id - WHERE (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; + WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; return $dbh->selectall_arrayref($query, { Slice => {} }); } -- 2.39.5