[Koha-bugs] [Bug 9811] Patrons search improvements

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

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

--- Comment #22 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 19633
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=19633&action=edit
Patron module start page

Adding some notes about my findings here:

1) (Normal) Sorting: I think it would be nice if fines, circ notes and
checkouts would be sortable too. I know checkouts is a bit difficult, but if it
was sortable you could easily find those with checkouts at least.

2) (Trivial) There is some wrong capitalization, that was already there before
and now appears in the filters too: Street Address > Street address

3) (Major) Filters: I tried to limit the search to a specific patron category
and while it said "Processing" nothing happened and the page seemed broken. I
had to reload the page. Same happens when I search for a name using the normal
search. Not sure what's going wrong here. I checked the logs, pasting some of
the errors here:

[Sun Jul 14 17:28:35 2013] [error] [client 127.0.0.1] [Sun Jul 14 17:28:35
2013] search: DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /home/katrin/kohaclone/C4/Utils/DataTables/Members.pm line 110., referer:
http://localhost:8080/cgi-bin/koha/members/member.pl
[Sun Jul 14 17:28:43 2013] [error] [client 127.0.0.1] [Sun Jul 14 17:28:43
2013] search: DBD::mysql::st execute failed: FUNCTION
categories.categorycodeWHERE does not exist at
/home/katrin/kohaclone/C4/Utils/DataTables/Members.pm line 109., referer:
http://localhost:8080/cgi-bin/koha/members/member.pl
[Sun Jul 14 17:28:43 2013] [error] [client 127.0.0.1] [Sun Jul 14 17:28:43
2013] search: DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /home/katrin/kohaclone/C4/Utils/DataTables/Members.pm line 110., referer:
http://localhost:8080/cgi-bin/koha/members/member.pl
[Sun Jul 14 17:29:09 2013] [error] [client 127.0.0.1] [Sun Jul 14 17:29:09
2013] search: DBD::mysql::st execute failed: FUNCTION
categories.categorycodeWHERE does not exist at
/home/katrin/kohaclone/C4/Utils/DataTables/Members.pm line 109., referer:
http://localhost:8080/cgi-bin/koha/members/member.pl
[Sun Jul 14 17:29:09 2013] [error] [client 127.0.0.1] [Sun Jul 14 17:29:09
2013] search: DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /home/katrin/kohaclone/C4/Utils/DataTables/Members.pm line 110., referer:
http://localhost:8080/cgi-bin/koha/members/member.pl

4) (Trivial) There is something a little odd about the datatables CSS - the
first part of the controls is a darker grey than the second part starting with
"First".

5) Wishlist: Could we rename the column Cat = Category? I remember all too well
when someone (probably me) translated it to "Katze" :) But not sure if that
takes up too much room or not.

-- 
You are receiving this mail because:
You are watching all bug changes.