[Koha-patches] [PATCH] [SIGNED-OFF] Bug 5603: advance_notice.pl uninitialized element in hash

[Nicole Engard]

From: Ian Walls <ian.walls at bywatersolutions.com>

Changings one of the LEFT JOINS in C4::Members::Messaging::GetMessagingPreferences
to a JOIN to prevent NULL message_transport_types from being returned

Signed-off-by: Nicole Engard <nengard at bywatersolutions.com>
---
 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.5.6.5