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

[John Choo]

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-tp14395913p14554759.html
Sent from the Koha - Win32 mailing list archive at Nabble.com.