[Koha] Internal Server Error

Thu Jul 3 07:07:35 NZST 2008

On Wed, Jul 2, 2008 at 12:08 PM, MJ Ray <mjr at phonecoop.coop> wrote:
> constantine <costas.magnuse at gmail.com> wrote:
>> I can add Members/Organizations and search for them flawlessly,
>> BUT, trying to add a bibliographic records leads me to this error:
>>
>> Internal Server Error [...]
>> MySQL server IS running: [...]
>> # a2enmod auth_mysql
>> Module auth_mysql already enabled
>> # /etc/init.d/apache2 restart
>>
>> What should I do?
>
> Hi.  Thanks for the question, but I'll be surprised if anyone can help
> from that.  In particular, you probably need to tell us:-
And I thought I was making informative posts :D...

> * Web address of error (if any).
> * How to obtain the error, step-by-step if possible.
I am adding the data manually using the address:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl

When I retrieve the data from a Z39.50 server (this feature really
rocks!) the address with the completed data is:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1

Then I click "Add Bibliographic Record and go to Tems", which leads me
to the "Internal Server Error" page which is also:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl

> * Any error message (preferred) or problem description - if it's not
> on the screen, check any relevant log files you can find.
I have added "Loglevel debug" in apache2.conf and koha-httpd.conf alike.
The apache2/error.log returns nothing.

However I get:

###############
root at sangre:/usr/local/koha/log# tail koha-access_log
###############
127.0.0.1 - - [02/Jul/2008:21:54:07 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 500 428
127.0.0.1 - - [02/Jul/2008:21:55:49 +0300] "GET
/cgi-bin/koha/loadmodules.pl?module=addbiblio&type=intranet HTTP/1.1"
302 -
127.0.0.1 - - [02/Jul/2008:21:55:49 +0300] "GET
/cgi-bin/koha/acqui.simple/addbooks.pl HTTP/1.1" 200 3782
127.0.0.1 - - [02/Jul/2008:21:56:15 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 200 36007
127.0.0.1 - - [02/Jul/2008:21:56:38 +0300] "GET
/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
HTTP/1.1" 200 759
127.0.0.1 - - [02/Jul/2008:21:56:39 +0300] "GET
/intranet-tmpl/default/en/includes/intranet.css HTTP/1.1" 404 296
127.0.0.1 - - [02/Jul/2008:21:56:41 +0300] "POST
/cgi-bin/koha/z3950/search.pl HTTP/1.1" 200 706
127.0.0.1 - - [02/Jul/2008:21:56:42 +0300] "GET
/intranet-tmpl/default/en/includes/intranet.css HTTP/1.1" 404 296
127.0.0.1 - - [02/Jul/2008:21:56:45 +0300] "GET
/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
HTTP/1.1" 200 40843
127.0.0.1 - - [02/Jul/2008:21:57:04 +0300] "POST
/cgi-bin/koha/acqui.simple/addbiblio.pl HTTP/1.1" 500 428

###############
root at sangre:/usr/local/koha/log# cat koha-error_log
###############
[Wed Jul 02 21:55:50 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 16118 to 3764 : URL
/cgi-bin/koha/acqui.simple/addbooks.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbooks.pl
[Wed Jul 02 21:56:17 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 767546 to 35989 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbooks.pl
[Wed Jul 02 21:56:39 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 1549 to 741 : URL
/cgi-bin/koha/z3950/search.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl
[Wed Jul 02 21:56:39 2008] [error] [client 127.0.0.1] File does not
exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:39 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 376 to 278 : URL
/intranet-tmpl/default/en/includes/intranet.css, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:41 2008] [error] [client 127.0.0.1] something went
wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl
line 135., referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:41 2008] [error] [client 127.0.0.1] doing the search
at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145.,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 1 (connect), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 6 (send apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 2 (send data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 3 (receive data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 7 (receive apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 6 (send apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 2 (send data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 3 (receive data), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 7 (receive apdu), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 9 (receive search), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] connection 0:
event 10 (end), referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] z3950.loc.gov at
/usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 1358 to 688 : URL
/cgi-bin/koha/z3950/search.pl, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=0521580129
[Wed Jul 02 21:56:42 2008] [error] [client 127.0.0.1] File does not
exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css,
referer: http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:56:42 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 376 to 278 : URL
/intranet-tmpl/default/en/includes/intranet.css, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:56:48 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 896041 to 40825 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/z3950/search.pl
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Q2 : select
distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as
m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as
m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_word as m9
where biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and
m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and
m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and
m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid and
m1.bibid=m9.bibid) and ((m1.word  like 'Advances' and m1.tagsubfield
in ('245a'))and (m2.word like 'in' and m2.tagsubfield in('245a'))and
(m3.word like 'economics' and m3.tagsubfield in('245a'))and (m4.word
like 'and' and m4.tagsubfield in('245a'))and (m5.word like
'econometrics' and m5.tagsubfield in('245a'))and (m6.word like
'theory' and m6.tagsubfield in('245b'))and (m7.word like 'and' and
m7.tagsubfield in('245b'))and (m8.word like 'applications' and
m8.tagsubfield in('245b'))and (m9.word like 'seventh' and
m9.tagsubfield in('245b'))) order by biblio.title ASC term is
Advances in economics and econometrics   theory and applications
seventh world congress   24 cm. Cambridge University Press, no. 26-28
at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274.,
referer: http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Arguments must
be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm
line 1440, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [error] [client 127.0.0.1] Premature end of
script headers: addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Wed Jul 02 21:57:06 2008] [debug] mod_deflate.c(619): [client
127.0.0.1] Zlib: Compressed 657 to 410 : URL
/cgi-bin/koha/acqui.simple/addbiblio.pl, referer:
http://sangre:8889/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1

> * If that process has worked for you before, the date when it worked.

It has never worked for me and I 've mad a clean install of koha 2.2.9
at least 5 times.
(Unfortunately, using koha 3 leads me to other errors)

My Best Wishes,

Constantine Tsardounis
http://www.costis.name