[Koha] Fwd: Error in Koha

[lists]

Anyone with an idea..?

On 1-4-2017 11:58, mj 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