From c7597897ed0c6e5fa93dbfc4093b2ac8d066bcd8 Mon Sep 17 00:00:00 2001
From: Sophie Meynieux <sophie.meynieux@biblibre.com>
Date: Mon, 10 Sep 2012 17:45:34 +0200
Subject: [PATCH] Bug 6030 followup : Specify "biblio.title" as a column name to differentiate from borrowers.title
Content-Type: text/plain; charset="utf-8"
http://koha-community.org

---
 misc/cronjobs/overdue_notices.pl |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl
index 4e53659..a7f222e 100755
--- a/misc/cronjobs/overdue_notices.pl
+++ b/misc/cronjobs/overdue_notices.pl
@@ -404,8 +404,8 @@ foreach my $branchcode (@branches) {
 
     $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
 
-    my $sth2 = $dbh->prepare( <<"END_SQL" );
-SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
+    my $sth2 = $dbh->prepare( <<'END_SQL' );
+SELECT biblio.title as "biblio.title",  biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
   FROM issues,items,biblio, biblioitems
   WHERE items.itemnumber=issues.itemnumber
     AND biblio.biblionumber   = items.biblionumber
-- 
1.7.2.5