Hi <br>thanks..<br>I started Z3950 daemon,<br>and i am using,<br>mysql Ver 14.7 Distrib 4.1.15, for pc-linux-gnu (i386) using readline 4.3<br><br>thanks and regards,<br><br>Lalitanand.<br><br><div><span class="gmail_quote">
On 8/1/06, <b class="gmail_sendername">Stephen Hedges</b> <<a href="mailto:st.hedges@gmail.com">st.hedges@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I'm guessing that:<br>1) you have not started the Z3950 daemon<br>2) you are using MySQL 5<br><br>Stephen<br><br>On 8/1/06, lalitanand dandge <<a href="mailto:dandgelb@gmail.com">dandgelb@gmail.com</a>> wrote:<br>> 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<br>> 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
<br>> Reference)<br>> then the result i get is: Nothing found:<br>> (the url shows<br>> "<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 "<br>> <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<br>> "
<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<br>> "<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>> page<br>> there is link "details" of the borrower, i get<br>> "<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>> "<br>> this page, but the borrower details fields are blank (it does not show name<br>> 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<br>> /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line<br>> 127., referer:<br>> <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<br>> /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line<br>> 127., referer:
<br>> <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
<br>> failed: You have an error in your SQL syntax; check the manual that<br>> corresponds to your MySQL server version for the right syntax to use near<br>> 'and reserves.borrowernumber = borrowers.borrowernumber
, referer:<br>> <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
<br>> reserves.biblio' at line 2 at<br>> /usr/local/koha/intranet/modules/C4/Reserves2.pm line 147.,<br>> referer:<br>> <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<br>> fetchrow_hashref failed: fetch() without execute() at<br>> /usr/local/koha/intranet/modules/C4/Reserves2.pm line 149.,<br>
> referer:<br>> <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><br>> _______________________________________________
<br>> Koha mailing list<br>> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
<br>><br>><br>><br></blockquote></div><br><br clear="all"><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>