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: koha-bugs@lists.koha-community.org Reporter: caroline.cyr-la-rose@inlibro.com QA Contact: testopia@bugs.koha-community.org 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.