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
