[Koha-bugs] [Bug 5423] New: Deleted Patrons are no longer saved in table deletedborrowers

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

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

           Summary: Deleted Patrons are no longer saved in table
                    deletedborrowers
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_2
          Platform: All
        OS/Version: All
            Status: ASSIGNED
          Severity: blocker
          Priority: P5
         Component: Database
        AssignedTo: katrin.fischer at bsz-bw.de
        ReportedBy: katrin.fischer at bsz-bw.de
         QAContact: koha-bugs at lists.koha-community.org
   Estimated Hours: 0.0


There are structural differences between borrowers and deletedborrowers. 

- cardnumber varchar(16) vs. varchar(9)
- privacy column is missing from deletedborrowers

koha-error-log message after successfully(!) deleting a borrower:

[Sun Nov 21 01:57:45 2010] [error] [client ::1] [Sun Nov 21 01:57:45 2010]
deletemem.pl: DBD::mysql::st execute failed: Column count doesn't match value
count at row 1 at /home/katrin/kohaclone/C4/Members.pm line 1610., referer:
http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=5

The data of the deleted borrower is not saved to the table deletedborrowers.

I am going to send a patch to update the database and resolve the differences
between the tables.

-- 
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.