From c5999dbbbd1bcfb45f258140c9b1f0041bb848f6 Mon Sep 17 00:00:00 2001 From: tipaul Date: Fri, 25 May 2007 15:14:43 +0000 Subject: [PATCH] BUG FIXING : Serials.pm was not Mysql5 compliant. (FROM table1, table2 changed to FROM table1 LEFT JOIN table2 ON.... ) --- C4/Serials.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 2a54851aef..f21f3be13c 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -98,7 +98,8 @@ sub GetSuppliersWithLateIssues { my $dbh = C4::Context->dbh; my $query = qq| SELECT DISTINCT id, name - FROM subscription, serial + FROM subscription + LEFT JOIN serial ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id WHERE subscription.subscriptionid = serial.subscriptionid AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) -- 2.39.5