[Koha-bugs] [Bug 5603] New: advance_notices.pl generating "uninitialized value in hash element"

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5603

           Summary: advance_notices.pl generating "uninitialized value in
                    hash element"
 Change sponsored?: ---
           Product: Koha
           Version: HEAD
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Notices
        AssignedTo: henridamien at koha-fr.org
        ReportedBy: ian.walls at bywatersolutions.com
         QAContact: koha-bugs at lists.koha-community.org
   Estimated Hours: 0.0


When running advance_notices.pl, numerous lines of the following are generated:

Use of uninitialized value in hash element at
/home/koha/kohaclone/C4/Members/Messaging.pm line 101.

Investigation shows this is due to the SQL in GetMessagingPreferences returning
null values for message_transport_type for advanced messaging types NOT
utilized by patrons.

The solution is to change the LEFT JOIN on line 77 to JOIN; this eliminates the
NULL entries.  Apparently, the patch for bug 4254 didn't factor in that NULL
values would be returned now that the duplicate columns were eliminated.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.