Verkehrs-Club der Schweiz VCS Arnold Gräub Leiter EDV/Informatik Tel. 062 956 56 45 mailto:arnold.graeub@verkehrsclub.ch Internet: www.verkehrsclub.ch

...

...

paul POULAIN <paul.poulain@free.fr> 09.01.03 15:30:02 >>> Arnold Graeub a écrit:

Hi, I have installed the new Version Koha-1.3.3. The script mainpage.pl requires Template.pm, so I downloaded HTML::Template from CPAN. When running mainpage.pl, the following error messge occurs, koha-error.log:

HTML::Template->new() : Cannot open included file /default/en/intranet-main.tmpl : file not found. at /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1580 HTML::Template::_init_template('HTML::Template=HASH(0x81c4434)') called at /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1177 HTML::Template::_init('HTML::Template=HASH(0x81c4434)') called at /usr/lib/perl5/site_perl/5.8.0/HTML/Template.pm line 1071 HTML::Template::new('HTML::Template','filename','/default/en/intranet-main.tmpl','die_on_bad_params',0,'global_vars',1,'path','ARRAY(0x857a180)',...) called at /usr/lib/perl5/site_perl/C4/Output.pm line 92 C4::Output::gettemplate('intranet-main.tmpl','intranet') called at /usr/lib/perl5/site_perl/C4/Auth.pm line 105 C4::Auth::get_template_and_user('HASH(0x857a85c)') called at /usr/local/httpd/koha/intranet/cgi-bin/mainpage.pl line 11 [Thu Jan 9 09:53:55 2003] [error] [client 194.191.145.126] Premature end of script headers: /usr/local/httpd/koha/intranet/cgi-bin/mainpage.pl

Where is the path to /default/en/intranet-main.tmpl defined ?

Strange indeed... It means the path_to_template has not been set. did you install koha from scratch or upgrade from a previous 1.3.x version ? It means that the path_to_template is not defined. To define it go to /etc/koha.conf and look at the line : intrahtdocs=/home/httpd/html/intra_133/htdocs/intranet-tmpl (that's mine). where "/home/httpd/htlm/intra_133" is the root directory you've entered at 1st stage of installer. Let us know if this helps. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org) Bonsoir Paul, Merci beaucoup de ton assistance! The path intrahtdocs was not set. The next problem is the following, koha-error.log: DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at /usr/lib/perl5/site_perl/C4/Auth.pm line 387. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/lib/perl5/site_perl/C4/Auth.pm line 389. On line 386 in Auth.pm string "my $sth=$dbh->prepare("select borrowernumber from borrowers where userid=?");" In the mysql-tables there is no column "userid" but "usercode". Is this the problem? Merci d'avance Arnold