Emiliano Marmonti a écrit:

Hi everybody

Anybody knows what could be happening? I think have completed all the steps to install, but when I try to execute updatedatabase script appears a problem:

DBD::mysql::st execute failed: Multiple primary key defined at updatedatabase line 416. Alter id in z3950servers DBD::mysql::st execute failed: Multiple primary key defined at updatedatabase line 416. Alter bookfundid in aqbookfund Checking for data required in table userflags... Checking for data required in table systempreferences...

I suppose you tried to install NOT from 0, but from a 1,2,x version running, as i tested install on a fresh computer and didn't get those problems. Those bugs points that the system tries to add a primary key, and it already exists, so, koha should work fine anyway :-)

And when you try to access to the site, appears the known 500 error. This is saying apache's log:

[Mon Dec 9 20:54:46 2002] [error] [client 168.83.60.175] Premature end of script headers: /usr/local/apache_1.3.27/cgi-bin/opac-cgi/search.pl DBD::mysql::st execute failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Auth.pm line 140. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Auth.pm line 142. DBD::mysql::st execute failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Auth.pm line 152. DBD::mysql::st execute failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Auth.pm line 159. DBD::mysql::db selectrow_array failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Context.pm line 318. DBD::mysql::db selectrow_array failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Context.pm line 318. DBD::mysql::db selectrow_array failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Context.pm line 318. ==> at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Output.pm line 108. DBD::mysql::db selectrow_array failed: No Database Selected at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Context.pm line 318. OUT at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Output.pm line 131. HTML::Template->new() : Cannot open included file /default/en/catalogue/searchresults.tmpl : file not found. at /usr/lib/perl5/site_perl/5.6.1/HTML/Template.pm line 1580 HTML::Template::_init_template('HTML::Template=HASH(0x8107e88)') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Template.pm line 1177 HTML::Template::_init('HTML::Template=HASH(0x8107e88)') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Template.pm line 1071 HTML::Template::new ('HTML::Template', 'filename', '/default/en/catalogue/searchresults.tmpl', 'die_ on_bad_params', 0, 'global_vars', 1, 'path', ...) called at /usr/local/apache_1.3.27/koha/intranet/modules/C4/Output.pm line 92 C4::Output::gettemplate('catalogue/searchresults.tmpl', 0) called at /usr/local/apache_1.3.27/cgi-bin/opac-cgi/search.pl line 45 [Mon Dec 9 21:02:23 2002] [error] [client 168.83.60.175] Premature end of script headers: /usr/local/apache_1.3.27/cgi-bin/opac-cgi/search.pl

Any idea? Thanks in advance. Emiliano,

Could you post your /etc/koha.conf ? * the "cannot connect" should be a login/password problem * the "cannot open template" should be a template path problem This confirms you should have install koha 1,3,2 from a previous install i think ! -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIBGB libre http://fr.koha.org)