Thanks for the quick response.<br>
<br>
I should have mentioned I did that and it gets to record 1500 and throws
a NULL error - I don't have it in front of me - but like oversized on
NULL operation. I'm thinking I have a bad entry in a NULL field.
Anyway to locate it without eyeballing a few hundred records?<br>
<br>
Thanks<br>
<br>
Paul Davis<br><br><div class="gmail_quote">On Thu, Sep 2, 2010 at 2:00 PM, Chris Cormack <span dir="ltr"><<a href="mailto:chris@bigballofwax.co.nz">chris@bigballofwax.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
2010/9/3 Paul Davis <<a href="mailto:ped811@gmail.com">ped811@gmail.com</a>>:<br>
<div><div></div><div class="h5">> Hello;<br>
> I have upgraded to 3.0.6 am having issues with many of my items do not have<br>
> the holding branch or home branch, which shows items unavailable in the OPAC<br>
> but still can check them out in the admin. (This may have been a carry over<br>
> from an earlier upgrade because I am finding and solving issues with my<br>
> zebra record.abs and MARC framework.) I examined the items table and found<br>
> these fields empty. Populated the fields with SQL commands to match working<br>
> records, re-indexed and still nothing. The only why I have found is to go<br>
> to each record, click Edit, edit items, edit the item - fill in the info<br>
> (most times it is there) and hit save. After the cron job re-index they<br>
> show up fine in the OPAC.<br>
><br>
> There are a lot of records involved - is there a batch way to accomplish the<br>
> same thing? In the items table, homebranch and holdingbranch are already<br>
> populated like the other working items.<br>
><br>
</div></div>Hi Paul<br>
<br>
Yes you can run the script misc/maintenance/<a href="http://sync_items_in_marc_bib.pl" target="_blank">sync_items_in_marc_bib.pl</a><br>
from the commandline<br>
<br>
Chris<br>
><br>
</blockquote></div><br><br clear="all"><br>-- <br>Paul<br>