From ba938c87243b33ebf7912a9efd291a4bf7f7e34a Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 4 Dec 2014 16:05:34 +0100 Subject: [PATCH] Bug 12059: Prefer to list fields in the query To avoir further issue, it's better to explicitely list the fields we want to retrieve. Signed-off-by: Jonathan Druart Signed-off-by: Mason James --- C4/Acquisition.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index c6993c3da6..7e3bb1ff48 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2734,7 +2734,11 @@ sub GetInvoiceDetails { my $invoice = $sth->fetchrow_hashref; $query = q{ - SELECT aqorders.*, biblio.*, biblioitems.*, aqbasket.basketname + SELECT aqorders.*, biblio.*, + biblio.copyrightdate, + biblioitems.publishercode, + biblioitems.publicationyear, + aqbasket.basketname FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber -- 2.39.5