Hello, You should contact directly your support provider if you have one, or used to have one. I was talking about MARC field, not DB Field. Re-read my answer with thinking MARC field instead of DB field.
Regards, Jonathan On Sat, 1 Apr 2017 at 06:58 mj <li...@merit.unu.edu> wrote: > Hi Jonathan, hi list, > > Answers inline: > > On 03/30/2017 05:59 PM, Jonathan Druart wrote: > > Looks like it means you have one record without the biblionumber field. > Browsing my database using phpmyadmin, looking at items.biblionumber > they all appear to have one. (should I be looking at items.biblionumber??) > > > How did you import you records into Koha? > This is a long running koha install, the data was imported many years > ago by biblibre, and these issues have started only recently. (biggest > recent change was update from 3.16 to 16.11.03.000 in sept 2016, and > then on to 16.11.05.000 recently) > > > > Did you try a full reindex? > Yep, results in some errors as well: > >> retrieving biblio 7711 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> .error retrieving biblio 7712 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> > 7701............................................................................7801.....................error > retrieving biblio 7849 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> > 7901............................................................................error > retrieving biblio 8004 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> .error retrieving biblio 8005 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> .error retrieving biblio 8006 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> .error retrieving biblio 8007 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> ..................error retrieving biblio 8025 at > /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 668. > >> .error retrieving biblio 8026 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> > 8001............................................................................8101......error > retrieving biblio 8134 at /usr/share/koha/bin/migration_tools/ > rebuild_zebra.pl line 668. > >> > ................................................................................8201................................................................................ > >> Records exported: 8271 > and: > > So, i tried searching our database for items.biblionumber = 7711 or 7712 > or 8006... all results: EMPTY. > > I am searching in the wrong place (items.biblionumber) or is the > zebra-reindex choking on non-exsisting records? > > You asked for: > > mysql> SELECT DISTINCT(branchcode) FROM branches > > -> ; > > +------------+ > > | branchcode | > > +------------+ > > | OURBR | > > +------------+ > > 1 row in set (0.00 sec) > > And this is right: we have only one branch, called OURBR. > > Then looking at items.homebranch and items.holdingbranch: every one of > our 8472 items seems to have this defined correctly: "OURBR" > (are there other fields to check, besides items.homebranch and > items.holdingbranch?) > > So this seems to becoming more and more of a mystery? > > Really hoping for some more suggestions... > > Best regards, > MJ > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
