2009/6/22 Mason James <mason.loves.sushi@gmail.com>

On 2009/06/23, at 8:54 AM, Roche III, Edward wrote:

> OK...now I opened a item record (through Webmin)like I was going to
> edit it didn't change anything then saved the record and now I can
> enter that barcode and it will allow me to check it out with no
> error. These barcodes were import into a temp table then I ran a
> UPDATE sql statement to update the barcodes in the item table from
> the temp table. Can anyone think of a reason why the system will
> not find the barcode unless I open and save the record first?

well, if you *manually* use sql to UPDATE your barcode values , zebra
doesnt know about that ;)

so rebuild your zebra-index after, and try searching again

FYI: the correct way to do this is to use the C4:Items:ModItems()
subroutine - then zebra is updated correctly too
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel

There's technically a second layer between the Koha MySQL database and Zebra: the MARC holdings tags. Whenever you update something in the biblio, biblioitems, or items table, you have to run misc/batchRebuildBiblioTables.pl to update the MARC record, and then run rebuild_zebra .

(Note that, as Mason said, it usually is easier to use the Perl API to do this; it'll update the items table and MARC record, and queue the record to be updated in Zebra.)

--
Jesse Weaver