From 7a9f3c3376d9a8c734cb062bf6957ab67cd29ccd Mon Sep 17 00:00:00 2001 From: Ian Walls Date: Mon, 10 Jan 2011 22:13:48 -0500 Subject: [PATCH] Bug 5603: advance_notice.pl uninitialized element in hash Content-type: text/plain; charset="utf8" Changings one of the LEFT JOINS in C4::Members::Messaging::GetMessagingPreferences to a JOIN to prevent NULL message_transport_types from being returned --- C4/Members/Messaging.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Members/Messaging.pm b/C4/Members/Messaging.pm index f5530e9..bc0f81b 100644 --- a/C4/Members/Messaging.pm +++ b/C4/Members/Messaging.pm @@ -74,7 +74,7 @@ LEFT JOIN borrower_message_transport_preferences ON borrower_message_transport_preferences.borrower_message_preference_id = borrower_message_preferences.borrower_message_preference_id LEFT JOIN message_attributes ON message_attributes.message_attribute_id = borrower_message_preferences.message_attribute_id -LEFT JOIN message_transports +JOIN message_transports ON message_transports.message_attribute_id = message_attributes.message_attribute_id AND message_transports.message_transport_type = borrower_message_transport_preferences.message_transport_type WHERE message_attributes.message_name = ? -- 1.6.4