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

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

18 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=791 Summary: Syntax error in query for thesaurus Product: Koha Version: 2.0.0 Platform: PC OS/Version: Linux - Debian Status: NEW Severity: blocker Priority: P2 Component: Parameters AssignedTo: tonnesen(a)cmsd.bc.ca ReportedBy: mparienti(a)easter-eggs.com QAContact: koha-bugs(a)lists.sourceforge.net The query for thesaurus word ends with "limit '0', '80'", which causes a syntax error with my mysql server version, the 4.0.20. The right syntax is "limit 0, 80". To correct this, I change the code: line 38 of koha/intranet/cgi-bin/admin/thesaurus becomes: my $offset= 0 + $input->param('offset'); line 197, 198 of koha/intranet/modules/C4/ change from: $query .= " limit ?,?"; push(@bind,$offset,($pagesize*4)); to: $query .= " limit $offset," . ($pagesize*4); ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 790] New: opac search on 'the' gives internal server error
by bugzilla-daemon＠wilbur.katipo.co.nz 10 Jun '04

10 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=790 Summary: opac search on 'the' gives internal server error Product: Koha Version: CVS Platform: PC OS/Version: Linux - Debian Status: NEW Severity: normal Priority: P2 Component: Searching AssignedTo: chris(a)katipo.co.nz ReportedBy: jferraro(a)athenscounty.lib.oh.us QAContact: koha-bugs(a)lists.sourceforge.net This is still a problem even though we thought it was fixed ... latest CVS still gives the error: [Thu Jun 10 17:00:50 2004] [error] [client 24.208.182.186] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-search.pl Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio, where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and order by biblio.title at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 170. DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where biblio.biblionumber=marc_biblio.biblionumber and biblio.b at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 172. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 215. Can't use an undefined value as a HASH reference at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 266. [Thu Jun 10 17:03:06 2004] [error] [client 24.208.182.186] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-search.pl ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

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

09 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=789 Summary: Cannot search for member by last name, first name Product: Koha Version: CVS Platform: All OS/Version: All Status: NEW Severity: critical Priority: P2 Component: Members AssignedTo: chris(a)katipo.co.nz ReportedBy: oleonard(a)athenscounty.lib.oh.us QAContact: koha-bugs(a)lists.sourceforge.net Latest versions of Koha (both rel_2_0 and HEAD) will return no results for a member search by "lastname, firstname" even if the name is in the database. It doesn't matter if the first name is full or partial. Searches will only return results for last names. The solution needs to no only allow one to search for members by inputting searches for names with single last names likes "Smith, John" but also multiple-word last names like "Van Dyke, John." ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 788] Installer calls mktemp
by bugzilla-daemon＠wilbur.katipo.co.nz 04 Jun '04

04 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=788 mjr(a)ttllp.co.uk changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 788] New: Installer calls mktemp
by bugzilla-daemon＠wilbur.katipo.co.nz 04 Jun '04

04 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=788 Summary: Installer calls mktemp Product: Koha Version: 2.0.0 Platform: All OS/Version: All Status: NEW Severity: major Priority: P2 Component: Installation AssignedTo: mjr(a)ttllp.co.uk ReportedBy: mjr(a)ttllp.co.uk QAContact: koha-bugs(a)lists.sourceforge.net machine-root% perl installer.pl Can't exec "mktemp": No such file or directory at Install.pm line 119. Use of uninitialized value in scalar chomp at Install.pm line 120. Surely there is a perl way to do this? mktemp is another package to depend on. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 738] Extra reports
by bugzilla-daemon＠wilbur.katipo.co.nz 03 Jun '04

03 Jun '04

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=738 ------- Additional Comments From mjr(a)ttllp.co.uk 2004-06-04 00:23 ------- M Brooke Helman wrote: > [...] In my dreams, I would love for Koha to be > able to generate a report that tells me how much each item type > circulates. (IE my fiction collection as a whole has circulated 13,000 > times last year 4,800 of which were renewals.) In my wildest dreams, > Koha would take that data and do nifty pie charts I could present to > other librarians or officials. I definitely get the impression that I > can at least get raw numbers. But how? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0