[Koha] Fwd: Error in Koha

[Jonathan Druart]

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 <lists at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>