issue between koha 2.5 and mysql 5.0
is there an issue between koha 2.5 and mysql 5.0? my logs have this: [Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 366., referer: http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search [Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st execute failed: Unknown column 'biblio.biblionumber' in 'on clause' at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 364., referer: http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search any idea?
Eric, did your install actually complete? Usually there's a problem with MySQL 5 because "return" is both a reserved word and the name of a Koha column, so the install aborts. Stephen eric salayon wrote:
is there an issue between koha 2.5 and mysql 5.0? my logs have this:
[Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 366., referer: http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search [Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st execute failed: Unknown column 'biblio.biblionumber' in 'on clause' at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 364., referer: http://opac.tip.edu.ph/cgi-bin/koha/opac-search.pl?startfrom=1&marclist=&and_or=and&excluding=&operator=contains&value=computer&&resultsperpage=19&orderby=&type=intranet&op=do_search
any idea? _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
HI! i'v installed koha manually, the intranet(8080) is OK, but opac(80) don't work ok. This is opac-error log. Any idea? [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] HTML::Template->new() : Cannot open included file /home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl : file not found. at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1580 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init_template('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1177 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1071 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::new('HTML::Template','filename','/home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmp...','die_on_bad_params',0,'global_vars',1,'path','ARRAY(0x8994db8)',...) called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Output.pm line 77 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Output::gettemplate('opac-main.tmpl','opac','CGI=HASH(0x804cccc)') called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Auth.pm line 114 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Auth::get_template_and_user('HASH(0x899072c)') called at /home/e-smith/files/primary/cgi-bin/koha/opac/cgi-bin/opac-main.pl line 32 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] Premature end of script headers: opac-main.pl
Someone knows which files i would have to use to populate the database, manually? i don't know if koha.mysql is enough.. thank you! ------- Giovani Augusto Quintao Pereira International Syst S/A
HI!
i'v installed koha manually, the intranet(8080) is OK, but opac(80) don't work ok. This is opac-error log. Any idea?
[Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] HTML::Template->new() : Cannot open included file /home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl : file not found. at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1580 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init_template('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1177 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1071 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::new('HTML::Template','filename','/home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmp...','die_on_bad_params',0,'global_vars',1,'path','ARRAY(0x8994db8)',...) called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Output.pm line 77 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Output::gettemplate('opac-main.tmpl','opac','CGI=HASH(0x804cccc)') called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Auth.pm line 114 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Auth::get_template_and_user('HASH(0x899072c)') called at /home/e-smith/files/primary/cgi-bin/koha/opac/cgi-bin/opac-main.pl line 32 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] Premature end of script headers: opac-main.pl
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
giovani, the koha is looking for the file opac-main.tmpl which should reside in the folder /home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmpl/default/en/ eric On 5/26/06, Giovani Augusto Quintao Pereira <giovani@dcc.ufmg.br> wrote:
HI!
i'v installed koha manually, the intranet(8080) is OK, but opac(80) don't work ok. This is opac-error log. Any idea?
[Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] HTML::Template->new() : Cannot open included file
/home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmpl/default/en/opac- main.tmpl : file not found. at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1580 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init_template('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1177 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tHTML::Template::_init('HTML::Template=HASH(0x80c2618)') called at /usr/lib/perl5/vendor_perl/5.8.3/HTML/Template.pm line 1071 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121]
\tHTML::Template::new('HTML::Template','filename','/home/e-smith/files/primary/cgi-bin/koha/opac/htdocs/opac-tmp...','die_on_bad_params',0,'global_vars',1,'path','ARRAY(0x8994db8)',...) called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Output.pm line 77 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Output::gettemplate('opac-main.tmpl','opac','CGI=HASH(0x804cccc)') called at /home/e-smith/files/primary/cgi-bin/koha/intranet/modules/C4/Auth.pm line 114 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] \tC4::Auth::get_template_and_user('HASH(0x899072c)') called at /home/e-smith/files/primary/cgi-bin/koha/opac/cgi-bin/opac-main.pl line 32 [Thu May 25 14:04:47 2006] [error] [client 192.168.20.121] Premature end of script headers: opac-main.pl
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
actually, i edited the koha.mysql and put the back quote on the return field. any suggestions on my error sir? tnx in advance! eric On 5/25/06, Stephen Hedges <shedges@skemotah.com> wrote:
Eric, did your install actually complete? Usually there's a problem with MySQL 5 because "return" is both a reserved word and the name of a Koha column, so the install aborts.
Stephen
eric salayon wrote:
is there an issue between koha 2.5 and mysql 5.0? my logs have this:
[Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 366., referer:
[Mon May 22 14:35:21 2006] [error] [client 10.0.0.9] DBD::mysql::st execute failed: Unknown column 'biblio.biblionumber' in 'on clause' at /www/Koha/Librarian/modules/C4/SearchMarc.pm line 364., referer:
any idea? _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (3)
-
eric salayon -
Giovani Augusto Quintao Pereira -
Stephen Hedges