Hello to all!... I have successfully installed koha-2.2.9. 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 The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, w@w.c and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/2.2.9 (Debian) PHP/5.2.6-1 with Suhosin-Patch Server at localhost Port 8889 MySQL server IS running: # ps aux |grep mysql root 10115 0.0 0.0 1820 516 pts/4 S 00:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 10163 0.0 1.4 128736 18144 pts/4 Sl 00:54 0:07 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 10165 0.0 0.0 4704 616 pts/4 S 00:54 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld and also I get # a2enmod auth_mysql Module auth_mysql already enabled # /etc/init.d/apache2 restart What should I do? Thank you in advance, Constantine Tsardounis http://costis.name
constantine <costas.magnuse@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:- * Any error message (preferred) or problem description - if it's not on the screen, check any relevant log files you can find. * Web address of error (if any). * How to obtain the error, step-by-step if possible. * If that process has worked for you before, the date when it worked. (This is copy-pasta which you can avoid in future by reading the list archives before posting.) Regards, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237
On Wed, Jul 2, 2008 at 12:08 PM, MJ Ray <mjr@phonecoop.coop> wrote:
constantine <costas.magnuse@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@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@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
participants (2)
-
constantine -
MJ Ray