[Koha] Fwd: Error in Koha

[mj]

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