January 2005 - Koha-devel - lists.koha-community.org

Search and Install bugs in Koha2.2RC5
by T & J Kotula 03 Jan '05

03 Jan '05

Hi all, Just installed Koha2.2 for the first time. Looks great. 1. There is a typo in koha.upgrade, after it copies OPAC interface to /usr/local/opac/cgi-bin, the script reportes an error: "Use of uninitialized value in concatenation (.) or string at Install.pm line 1656". I was trying to upgrade 2.0 to 2.2RC5. 2. On a MARCdetail.pl screen, when I hit any search button (the ones with magnifying glass icons) I get an internal server error :-(. The error log is a rather long, see below. 3. I'm also having problems installing 2.2RC5 from scratch. After typing in mysql root password, the installer script bombs out with a message "Error 1054 at line 1. Unknown column 'lock_tables_priv' in 'field list'" followed by "Access denied for user to database Koha". It installed fine when I removed 'lock_tables_priv' from insert statement in Install.pm. I'm running as root on FC2. Thanks for your help. tomasz kotula --------------------------------------------------- [error] File does not exist: /usr/local/koha/intranet/htdocs/favicon.ico [error] 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 270., referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] DBD::mysql::st execute failed: You have an error in your SQL syntax near 'where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=bibli' at line 1 at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 272., referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 315., referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] HTML::Template->new() : Cannot open included file /usr/local/koha/opac/htdocs/opac-tmpl/default/en/search.marc/result.tmpl : file not found. at /usr/lib/perl5/site_perl/5.8.5/HTML/Template.pm line 1580, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] \tHTML::Template::_init_template('HTML::Template=HASH(0x92bbd7c)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Template.pm line 1177, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] \tHTML::Template::_init('HTML::Template=HASH(0x92bbd7c)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Template.pm line 1071, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] \tHTML::Template::new('HTML::Template', 'filename', '/usr/local/koha/opac/htdocs/opac-tmpl/default/en/search.marc/...', 'die_on_bad_params', 0, 'global_vars', 1, 'path', 'ARRAY(0x99c3f48)', ...) called at /usr/local/koha/intranet/modules/C4/Output.pm line 77, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] \tC4::Output::gettemplate('search.marc/result.tmpl', 'undef', 'CGI=HASH(0x9026cdc)') called at /usr/local/koha/intranet/modules/C4/Auth.pm line 114, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] \tC4::Auth::get_template_and_user('HASH(0x99c3f78)') called at /usr/local/koha/intranet/cgi-bin/search.marc/search.pl line 134, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529 [error] Premature end of script headers: search.pl, referer: http://192.168.5.55:8080/cgi-bin/koha/MARCdetail.pl?bib=529

2 1

koha-2.2RC4
by shebina 03 Jan '05

03 Jan '05

hi..... the catalog search is not working properly i can search only by item type ,branch and barcode (in marc turned on and in marc turned off) any solution????????/ shebina

3 2

New document in kohadocs.org
by Stephen Hedges 02 Jan '05

02 Jan '05

A new document has been loaded on http://www.kohadocs.org: "Installing Koha on Fedora" by Joshua Ferraro. It is available there as a DocBook XML source tree, as well as a html version and a pdf version derived from the xml source. The xml source tree has also been loaded in the koha-doc area of Sourceforge. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0