Summary: | can't open a patron record | ||
---|---|---|---|
Product: | Koha | Reporter: | Nicole C. Engard <nengard> |
Component: | Patrons | Assignee: | Kyle M Hall <kyle.m.hall> |
Status: | CLOSED DUPLICATE | QA Contact: | Ian Walls <koha.sekjal> |
Severity: | major | ||
Priority: | P5 - low | CC: | gmcharlt, wizzyrea |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Nicole C. Engard
2012-04-12 11:58:22 UTC
what's in a select * from borrowers where borrowernumber = xxx ? Maybe there's a field that's not escaped correctly and you have some punctuation in there that's making it mad? Nothing special that I see: mysql> select * from borrowers where borrowernumber =54 \G *************************** 1. row *************************** borrowernumber: 54 cardnumber: 9876543453 surname: Engard firstname: Brian title: othernames: initials: streetnumber: streettype: NULL address: 123 My Street address2: city: Philadelphia state: PA zipcode: 19101 country: email: engar@gmail.com phone: 555.111.2345 mobile: fax: emailpro: phonepro: B_streetnumber: NULL B_streettype: NULL B_address: 123 Alternate Address B_address2: B_city: Newark B_state: DE B_zipcode: 19711 B_country: B_email: brian@gmail.com B_phone: 555.123.4563 dateofbirth: NULL branchcode: NIC categorycode: PT dateenrolled: 2011-02-18 dateexpiry: 2019-09-01 gonenoaddress: 0 lost: 0 debarred: NULL debarredcomment: NULL contactname: NULL contactfirstname: NULL contacttitle: NULL guarantorid: NULL borrowernotes: circ notes relationship: NULL ethnicity: NULL ethnotes: NULL sex: M password: y9RPi1tIpR99q5irzfRdTg flags: 67588 userid: brian opacnote: opac note contactnote: Alternate comment note sort1: sort2: altcontactfirstname: Nicole altcontactsurname: Engard altcontactaddress1: Same altcontactaddress2: altcontactaddress3: Philadelphia altcontactstate: PA altcontactzipcode: 19101 altcontactcountry: USA altcontactphone: 555.343.2123 smsalertnumber: NULL privacy: 1 1 row in set (0.00 sec) |