<div class="gmail_quote">On Sat, May 1, 2010 at 2:28 PM, vishnu varthan <span dir="ltr"><<a href="mailto:vishnu09.perumal@gmail.com">vishnu09.perumal@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br clear="all"><br>
<br><br><div class="gmail_quote"><div class="im">On Sat, May 1, 2010 at 2:01 PM, Koustubha Kale <span dir="ltr"><<a href="mailto:kmkale@anantcorp.com" target="_blank">kmkale@anantcorp.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Can you check if this number matches with your database by running queries against it through command or phpmyadmin?<br clear="all"></div><div><br></div><div>SELECT count( itemnumber ) FROM `items` WHERE itype = 'BOOK'<br>
</div><div>and</div><div>SELECT count( itemnumber ) FROM `items`<br></div><div><br></div><div>My test install shows 21049 and 21057 respectively. Means I have 8 records where item type is *NOT* BOOK. I find that in 8 places my itype is NULL. Obviously a problem with my imported data not zebra..</div>
</blockquote></div><div><br> Its work fine running queries through command or phpmyadmin<br><br> But using opac search i got these problems. <br></div><div><div></div><div class="h5"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><br></div><br><br></div><div><div></div><div><div class="gmail_quote">On Sat, May 1, 2010 at 12:59 PM, vishnu varthan <span dir="ltr"><<a href="mailto:vishnu09.perumal@gmail.com" target="_blank">vishnu09.perumal@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">How did you search for *ALL* records? <br></blockquote><div>
<br><br> select particular item types without using any keyword in opac.<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br clear="all">
Regards,<br>Koustubha Kale<br>Anant Corporation<br><br>Contact Details :<br>Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w),<br> Maharashtra, India, Pin : 400601.<br>
TeleFax : +91-22-21720108, +91-22-21720109<br>Mobile : +919820715876<br>Website : <a href="http://www.anantcorp.com" target="_blank">http://www.anantcorp.com</a><br>Blog : <a href="http://www.anantcorp.com/blog/?author=2" target="_blank">http://www.anantcorp.com/blog/?author=2</a><div>
<div><br>
<br><br><div class="gmail_quote">On Sat, May 1, 2010 at 12:01 PM, vishnu varthan <span dir="ltr"><<a href="mailto:vishnu@e-ndicus.com" target="_blank">vishnu@e-ndicus.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi sir,<br><br> i am using koha in centOS and using Zebra for indexing purpose.<br>
<br>
1. i inserted 5000 Records in catalog all the records are been stored.<br>
<br>
2. Rebuild Zebra for indexing purpose.<br>
<br>
3. now i am trying to search records using opac,but i am unable to view<br>
all the records. only few records(1000) are displayed.<br>
<br>
can anyone please explain What would be the problem?<br><br clear="all">with regards<br><font color="#888888">vishnu varthan p<br><a href="mailto:vishnu@e-ndicus.com" target="_blank">vishnu@e-ndicus.com</a><br>
</font></blockquote></div><br>
</div></div></blockquote></div><br>
</blockquote></div><br>
</div></div></blockquote></div></div></div><br></blockquote><div><br>If possible show us the output of these sql queries and you zebra log.<br clear="all">Regards,<br>Koustubha Kale<br>Anant Corporation<br><br>Contact Details :<br>
Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w),<br> Maharashtra, India, Pin : 400601.<br>TeleFax : +91-22-21720108, +91-22-21720109<br>Mobile : +919820715876<br>Website : <a href="http://www.anantcorp.com">http://www.anantcorp.com</a><br>
Blog : <a href="http://www.anantcorp.com/blog/?author=2">http://www.anantcorp.com/blog/?author=2</a> <br></div></div><br>