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
T & J Kotula a écrit :
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.
mmm... i'm not sure wether this is a problem or not. and I don't see where is the typo. could you give me some hints ?
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.
I knew. It's fixed.
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.
You are not the 1st to report the problem. I've rolled back to previous behaviour. the lock_tables_priv exists only in recent versions of mysql (seomthing like 4.x) And the "grant all to ..." does not work in early versions of Koha too. So there is no simple solution to this problem. Should be better to have lock_tables_priv problem on bulkmarcimport for libraries that will use this on recent mySQL servers. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (2)
-
Paul POULAIN -
T & J Kotula