June 2004 - Koha-bugs - lists.koha-community.org

[Bug 792] opac-new.pl crashes
by bugzilla-daemon＠wilbur.katipo.co.nz 01 Jul '04

01 Jul '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=792 ------- Additional Comments From gregk(a)no1.com.au 2004-07-01 11:01 ------- I just did a change in opac-new.pl for testing purposes, increasing $number_of_results to 200 and tried the same query. It worked perfectly. Conclusion: This search report only handles a maximum of $number_of_results to be returned in the result set at the moment. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 792] opac-new.pl crashes
by bugzilla-daemon＠wilbur.katipo.co.nz 01 Jul '04

01 Jul '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=792 ------- Additional Comments From gregk(a)no1.com.au 2004-07-01 10:47 ------- Cause of the problem has been found (I think). I tried the search again today and put in "0" as the number of days to search for. It worked fine. I then tried 1 day, and it returned 1 book. 2 days failed. My next guess was that perhaps there was some dud data in my database... so I was going to manually edit the date book by book till I found out which one it was. This was working fine, and I got to 20 books in the table. Book # 21 cause the error. I put the date for that book back, and thought I'd check the rest. Every other book cause the same problem when its date was within the 1 day criteria. Conclusion: Either 90% of the data in my database is dud, or koha doesnt like displaying more than 20 books in this module! ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 791] Syntax error in query for thesaurus
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=791 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From mjr(a)ttllp.co.uk 2004-07-01 06:11 ------- Please try changing affected code, starting around line 195 of C4/Authorities.pm, to read: $query .= " limit ?,?"; warn "q : $query".@bind; my $sth=$dbh->prepare($query); for my $i (0..$#bind) { $sth->bind_param($i,$bind[$i]); } $sth->bind_param($#bind+1,$offset,SQL_INTEGER); $sth->bind_param($#bind+2,($pagesize*4),SQL_INTEGER); $sth->execute(); Also change line 24 to read: use DBI qw(:sql_types); Thanks to Kris Boutilier for the pointer to SQL_INTEGER. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 708] Add language selection to OPAC
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=708 ------- Additional Comments From tmcmahon(a)wlpl.org 2004-07-01 05:33 ------- Give library users a way to select the language they want to use for the OPAC interface. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 796] New: Link opac-userdetails.pl leads to error
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=796 Summary: Link opac-userdetails.pl leads to error Product: Koha Version: 2.0.0 Platform: All OS/Version: All Status: NEW Severity: major Priority: P2 Component: OPAC AssignedTo: chris(a)katipo.co.nz ReportedBy: oleonard(a)athenscounty.lib.oh.us QAContact: koha-bugs(a)lists.sourceforge.net I'm not sure what changed, but opac-userdetails.pl is no longer working for us. Here's the error in the log: HTML::Template->param() : You gave me an odd number of parameters to param()! at /usr/local/koha/opac/cgi-bin/opac-userdetails.pl line 33 ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 789] Cannot search for member by last name, first name
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=789 ------- Additional Comments From oleonard(a)athenscounty.lib.oh.us 2004-07-01 02:50 ------- As I recall, the solution that Chris and I discussed hinged on requiring a comma between first and last names. Maybe Chris can confirm. I don't have any problem with requiring the comma. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 792] opac-new.pl crashes
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=792 ------- Additional Comments From oleonard(a)athenscounty.lib.oh.us 2004-07-01 02:47 ------- This is the error that I get if I do a recent acquisitions search: Can't use string ("1") as a HASH ref while "strict refs" in use at /usr/local/koha/opac/cgi-bin/opac-new.pl line 33, <DATA> line 422. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 436] circulation.pl only partially templated
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=436 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |major Status|NEW |ASSIGNED ------- Additional Comments From mjr(a)ttllp.co.uk 2004-07-01 01:39 ------- Any progress on this bug? Doesn't seem to cause crash or data loss, so downgrading to major. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 789] Cannot search for member by last name, first name
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=789 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|chris(a)katipo.co.nz |mjr(a)ttllp.co.uk Severity|critical |major ------- Additional Comments From mjr(a)ttllp.co.uk 2004-07-01 01:37 ------- No data loss or crash. Downgrading to major. Maybe the split() in modules/C4/Search.pm:1895 should split on ', ' instead of ' '? Please let me know. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 791] Syntax error in query for thesaurus
by bugzilla-daemon＠wilbur.katipo.co.nz 30 Jun '04

30 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=791 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|tonnesen(a)cmsd.bc.ca |mjr(a)ttllp.co.uk Summary|Syntax error in query for |Syntax error in query for |thesaurus |thesaurus ------- Additional Comments From mjr(a)ttllp.co.uk 2004-07-01 01:30 ------- I've made the first of these changes in the 2.0 development tree. The second change you suggest would reintroduce a bad habit that I'm trying to avoid as much as possible: interpolating into an SQL query. Do you know a way to achieve the same thing with placeholders? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0