[Koha-bugs] [Bug 4108] New: GetMember generating invalid SQL

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4108

           Summary: GetMember generating invalid SQL
           Product: Koha
           Version: HEAD
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Patrons
        AssignedTo: colin.campbell at ptfs-europe.com
        ReportedBy: colin.campbell at ptfs-europe.com
   Estimated Hours: 0.0
 Change sponsored?: ---


Lots of errors being generated by C4/Members.pm over invalid SQL and fetching
from invalid statement handles - Cause is not handing when a parameter is
passed as undefined causing it to write where x = NULL into the query. As
success of preparing the statement is not tested data is then fetched from an
invalid handle.
Results in calling code are ubdefined (in some cases an error in others
potentially a more subtle bug.

Also parameters are being passed as a hash is safer to pass them as a hashref
so that errors tend to be caught at compile time rather than runtime.


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.