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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Dec 14 16:55:24 CET 2010


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

Nicole C. Engard <nengard at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nengard at gmail.com

--- Comment #11 from Nicole C. Engard <nengard at gmail.com> 2010-12-14 15:55:22 UTC ---
I do have a privacy column in my deleted borrowers table (in HEAD) and I have
no errors in my log on deleting a patron.

Here's my table:


mysql> select * from deletedborrowers;
+----------------+----------------+---------+-----------+-------+------------+----------+--------------+------------+------------------+----------+-----------------+---------+---------+-------+----------------+--------+------+----------+----------+----------------+--------------+-----------+------------+--------+-----------+-----------+---------+---------+-------------+------------+--------------+--------------+------------+---------------+------+----------+-------------+------------------+--------------+-------------+---------------+--------------+-----------+----------+------+------------------+-------+----------------+----------+-------------+------------------+-------+---------------------+-------------------+--------------------+--------------------+--------------------+-------------------+-------------------+-----------------+----------------+---------+
| borrowernumber | cardnumber     | surname | firstname | title | othernames |
initials | streetnumber | streettype | address          | address2 | city      
     | zipcode | country | email | phone          | mobile | fax  | emailpro |
phonepro | B_streetnumber | B_streettype | B_address | B_address2 | B_city |
B_zipcode | B_country | B_email | B_phone | dateofbirth | branchcode |
categorycode | dateenrolled | dateexpiry | gonenoaddress | lost | debarred |
contactname | contactfirstname | contacttitle | guarantorid | borrowernotes |
relationship | ethnicity | ethnotes | sex  | password         | flags | userid 
       | opacnote | contactnote | sort1            | sort2 |
altcontactfirstname | altcontactsurname | altcontactaddress1 |
altcontactaddress2 | altcontactaddress3 | altcontactzipcode | altcontactcountry
| altcontactphone | smsalertnumber | privacy |
+----------------+----------------+---------+-----------+-------+------------+----------+--------------+------------+------------------+----------+-----------------+---------+---------+-------+----------------+--------+------+----------+----------+----------------+--------------+-----------+------------+--------+-----------+-----------+---------+---------+-------------+------------+--------------+--------------+------------+---------------+------+----------+-------------+------------------+--------------+-------------+---------------+--------------+-----------+----------+------+------------------+-------+----------------+----------+-------------+------------------+-------+---------------------+-------------------+--------------------+--------------------+--------------------+-------------------+-------------------+-----------------+----------------+---------+
|             37 | 23529000197047 | Charles | Lisa      |       |            | 
        | NULL         | NULL       | 5129 Library Rd. | NULL     |
Centerville, CA | 44262   | NULL    | NULL  | (212) 555-1212 | NULL   | NULL |
NULL     | NULL     | NULL           | NULL         |           | NULL       | 
      |           | NULL      |         |         | 1982-10-14  | MPL        |
K            | 1988-11-14   | 2020-12-31 |             0 |    0 |        0 |
Alford      | Jordan           | NULL         |          45 |               |
father       | NULL      | NULL     | M    | 42b29d0771f3b7ef |  NULL |
23529000197047 |          |             | 0.26352253767058 | Y     |           
         |                   |                    |                    |       
            |                   | NULL              |                 | NULL   
       |       1 |

1 row in set (0.00 sec)

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


More information about the Koha-bugs mailing list