https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39150
Bug ID: 39150
Summary: Should borrowers.contacttitle be removed?
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
As far as I know, the contacttitle in borrowers is not used anywhere and I'm
not sure it is even possible to edit it in the interface. I might be wrong, but
this seems like a leftover from when guarantors were stored directly in the
borrowers table?
To recreate:
1. Go to Patrons > New patron > Kid
--> Under Non-patron guarantor, there is only surname and firstname
2. Fill out only the mandatory fields and the Non-patron guarantor fields
3. Save the new patron
4. In the database, view the record for this patron
`select * from borrowers where borrowernumber = 54 \G;`
--> Only contactname, contactfirstname and relationship are filled out
--> contacttitle is NULL
MariaDB [koha_kohadev]> select * from borrowers where borrowernumber = 54 \G;
*************************** 1. row ***************************
borrowernumber: 54
cardnumber: q
surname: q
firstname:
preferred_name:
middle_name:
title:
othernames:
initials:
pronouns:
streetnumber:
streettype: NULL
address:
address2:
city:
state:
zipcode:
country:
email:
phone:
mobile:
fax:
emailpro:
phonepro:
B_streetnumber:
B_streettype: NULL
B_address:
B_address2:
B_city:
B_state:
B_zipcode:
B_country:
B_email:
B_phone:
dateofbirth: NULL
branchcode: CPL
categorycode: K
dateenrolled: 2025-02-17
dateexpiry: 2033-05-17
password_expiration_date: NULL
date_renewed: NULL
gonenoaddress: NULL
lost: NULL
debarred: NULL
debarredcomment: NULL
contactname: guarantor surname
contactfirstname: guarantor firstname
contacttitle: NULL
borrowernotes:
relationship: father
sex:
password: !
secret: NULL
auth_method: password
flags: NULL
userid: q
opacnote:
contactnote:
sort1:
sort2:
altcontactfirstname:
altcontactsurname:
altcontactaddress1:
altcontactaddress2:
altcontactaddress3:
altcontactstate:
altcontactzipcode:
altcontactcountry:
altcontactphone:
smsalertnumber: NULL
sms_provider_id: NULL
privacy: 1
privacy_guarantor_fines: 0
privacy_guarantor_checkouts: 0
checkprevcheckout: inherit
updated_on: 2025-02-17 17:31:26
lastseen: NULL
lang: default
login_attempts: 0
overdrive_auth_token: NULL
anonymized: 0
autorenew_checkouts: 1
primary_contact_method:
protected: 0
1 row in set (0.001 sec)
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
