[Koha-devel] Search and Install bugs in Koha2.2RC5

[T & J Kotula]

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