[Koha-win32] z39.50 not working general 500 Internal Server Error

Thu Feb 21 13:21:21 CET 2008

Hi John,

I did check that post out first before posting and I checked also that Yaz
environment variable was correct. Installed yaz again separately using
yaz_3.0.24.exe and I now get a different error to the one I posted earlier.
Please see below.

ray

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] Premature end of
script headers: search.pl, referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] Can't load
'C:/usr/site/lib/auto/Net/Z3950/ZOOM/ZOOM.dll' for module Net::Z3950::ZOOM:
load_file:The specified procedure could not be found at
C:/usr/lib/XSLoader.pm line 70., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1]  at
C:/usr/site/lib/Net/Z3950/ZOOM.pm line 12, referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] Compilation failed in
require at C:/usr/site/lib/ZOOM.pm line 6., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] BEGIN
failed--compilation aborted at C:/usr/site/lib/ZOOM.pm line 6., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] Compilation failed in
require at C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30.,
referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:29 2008] [error] [client 127.0.0.1] BEGIN
failed--compilation aborted at
C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] Premature end of
script headers: search.pl, referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] Can't load
'C:/usr/site/lib/auto/Net/Z3950/ZOOM/ZOOM.dll' for module Net::Z3950::ZOOM:
load_file:The specified procedure could not be found at
C:/usr/lib/XSLoader.pm line 70., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1]  at
C:/usr/site/lib/Net/Z3950/ZOOM.pm line 12, referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] Compilation failed in
require at C:/usr/site/lib/ZOOM.pm line 6., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] BEGIN
failed--compilation aborted at C:/usr/site/lib/ZOOM.pm line 6., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] Compilation failed in
require at C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30.,
referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

[Thu Feb 21 11:22:46 2008] [error] [client 127.0.0.1] BEGIN
failed--compilation aborted at
C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30., referer:
http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=&frameworkcode=01

John Choo wrote:
> 
> Hi Ray,
> 
> You might want to check this post out:
> http://www.nabble.com/Z39.50-won't-work-td8889632.html
> 
> 
> 
> Amaravati wrote:
>> 
>> Hi I'm running the following configuration
>> 
>> Koha version: 2.2.8
>> OS version: Microsoft Windows XP [Version 5.1.2600]
>> Perl version: 5.008008
>> MySQL version: mysql Ver 14.7 Distrib 4.1.22, for Win32 (ia32)
>> Apache version: Apache/2.2.4 (Win32)
>> 
>> This a clean install.
>> 
>> I'm trying to add a biblio in
>> [http://intranet/cgi-bin/koha/acqui.simple/addbiblio.p] When I try to do
>> a z39.50 search I get a generic "500 Internal Server Error" message. 
>> 
>> The intranet-error.log file contains the following:-
>> 
>> [Tue Dec 18 11:57:10 2007] [error] [client 127.0.0.1] Q : select distinct
>> m1.bibid from biblio,biblioitems,marc_biblio, where
>> biblio.biblionumber=marc_biblio.biblionumber and
>> biblio.biblionumber=biblioitems.biblionumber and
>> m1.bibid=marc_biblio.bibid and  order by biblio.title ASC at
>> c:/usr/koha228/intranet/modules/C4/SearchMarc.pm line 277., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbooks.pl
>> 
>> [Tue Dec 18 11:57:10 2007] [error] [client 127.0.0.1] DBD::mysql::st
>> execute failed: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to use
>> near 'where biblio.biblionumber=marc_biblio.biblionumber and
>> biblio.biblionumber=bibli' at line 1 at
>> c:/usr/koha228/intranet/modules/C4/SearchMarc.pm line 279., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbooks.pl
>> 
>> [Tue Dec 18 11:57:10 2007] [error] [client 127.0.0.1] DBD::mysql::st
>> fetchrow failed: fetch() without execute() at
>> c:/usr/koha228/intranet/modules/C4/SearchMarc.pm line 323., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbooks.pl
>> 
>> [Tue Dec 18 11:57:10 2007] [error] [client 127.0.0.1] DBD::mysql::st
>> execute failed: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to use
>> near '' at line 1 at c:/usr/koha228/intranet/modules/C4/Breeding.pm line
>> 172., referer: http://intranet/cgi-bin/koha/acqui.simple/addbooks.pl
>> 
>> [Tue Dec 18 11:57:10 2007] [error] [client 127.0.0.1] DBD::mysql::st
>> fetchrow_hashref failed: fetch() without execute() at
>> c:/usr/koha228/intranet/modules/C4/Breeding.pm line 173., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbooks.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] Premature end of
>> script headers: search.pl, referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] Can't load
>> 'C:/usr/site/lib/auto/Net/Z3950/ZOOM/ZOOM.dll' for module
>> Net::Z3950::ZOOM: load_file:The specified procedure could not be found at
>> C:/usr/lib/XSLoader.pm line 70., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1]  at
>> C:/usr/site/lib/Net/Z3950/ZOOM.pm line 12, referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] Compilation failed
>> in require at C:/usr/site/lib/ZOOM.pm line 6., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] BEGIN
>> failed--compilation aborted at C:/usr/site/lib/ZOOM.pm line 6., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] Compilation failed
>> in require at C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line
>> 30., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> [Tue Dec 18 11:57:29 2007] [error] [client 127.0.0.1] BEGIN
>> failed--compilation aborted at
>> C:/usr/koha228/intranet/cgi-bin/koha/z3950/search.pl line 30., referer:
>> http://intranet/cgi-bin/koha/acqui.simple/addbiblio.pl
>> 
>> Any pointers please?
>> 
>> ray
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/z39.50-not-working-general-500-Internal-Server-Error-tp14395913p15607290.html
Sent from the Koha - Win32 mailing list archive at Nabble.com.