Hi<br>I installed Koha2.2.5 on my debian system.<br>I want to import the marc tags from the Library of Congress or other z39.50 server, <br>I added the Z3950 server: the entries I added are:<br>hostname: <a href="http://z3950.loc.gov">
z3950.loc.gov</a><br>Port No: 7090<br>and Database name: voyager<br>but the problem i am facing is:<br>when i do search on particular ISBN no. like 0-07-049543 (Java Complete Reference)<br>then the result i get is: Nothing found:
<br>(the url shows "<a href="http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&isbn=0-07-049543">http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&isbn=0-07-049543</a>"<br>and then changes to "
<a href="http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&random=249094171.290384">http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&random=249094171.290384</a>")<br>please tell me how to configure and check my koha system with z3950 support.
<br><br>another problem I am getting is,<br>when i search for patrons it gives the list of members page "<a href="http://localhost:8080/cgi-bin/koha/members/member.pl">http://localhost:8080/cgi-bin/koha/members/member.pl
</a>"<br>then after clicking issue: i get "<a href="http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a>" page<br>
there is link "details" of the borrower, i get "<a href="http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1">http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1</a>
"<br>this page, but the borrower details fields are blank (it does not show name and other things)<br>the error i get while doing these steps in the koha-error_log is <br><br>[Tue Aug 01 12:38:42 2006] [error] [client localhost] 2007-07-19 at /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line 127., referer:
<a href="http://202.141.152.81:8080/cgi-bin/koha/members/member.pl">http://202.141.152.81:8080/cgi-bin/koha/members/member.pl</a><br><br>[Tue Aug 01 12:39:02 2006] [error] [client localhost] 2007-07-19 at /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line 127., referer:
<a href="http://202.141.152.81:8080/cgi-bin/koha/members/member.pl">http://202.141.152.81:8080/cgi-bin/koha/members/member.pl</a><br><br>[Tue Aug 01 12:40:56 2006] [error] [client localhost] 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 'and
reserves.borrowernumber = borrowers.borrowernumber, referer: <a href="http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a><br><br>
[Tue Aug 01 12:40:56 2006] [error] [client localhost] \t\t\t\t\tand reserves.biblio' at line 2 at /usr/local/koha/intranet/modules/C4/Reserves2.pm line 147., referer: <a href="http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">
http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a><br><br>[Tue Aug 01 12:40:56 2006] [error] [client localhost] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Reserves2.pm line 149., referer:
<a href="http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a><br><br>So please help me in this regard, <br>How to configure my koha system to enable the marc record search using z3950
<br>and how to get the above mentioned errors sorted out.<br><br>thanks<br><br>lalitanand.<br><br><br><br>-- <br>"Talk is cheap. Show me the code. Think Open, use Open Source!"<br>Visit & Register at <a href="http://www.ossrc.org.in">
http://www.ossrc.org.in</a>