[Koha] rebuild_zebra: Biblios aren't displayed anymore

Beda Szukics beda at kollegium-sarnen.ch
Tue Oct 23 04:06:25 NZDT 2012


Am 22.10.2012 16:43, schrieb Paul:
> At 03:13 PM 10/22/2012 +0200, Beda Szukics wrote:
>> Hi all
>> Since I have done a rebuild of the zebra index with
>> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -a -r
>> the biblios and items aren't displayed anymore with the search results.
> 
> Two points:
> 
>         - do you have any duplicate 001 Control Numbers? [1] This was
> our biggest difficulty after upgrade from 3.6.1 to 3.8.5 [001 should be
> unique when taken in conjunction with 003, but zebra does not respect
> this.]
> 
>         - did you follow reindexing the authorities with the biblios? 
> ./bin/migration_tools/rebuild_zebra.pl -b -r -x
> 
> Best - Paul
> 
> [1] You can verify this in mysql with:
> 
> SELECT GROUP_CONCAT(biblionumber SEPARATOR ', ') AS biblionumbers,
> EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]') AS id FROM biblioitems
> GROUP BY id  HAVING count(id) > 1
> 
It seems so:
Your instruction tells me:
| biblionumbers













                   | id                  |

| 256, 512, 768, 1024, 1280, 1536, 1792, 2048, 2304, 2560, 2816, 3072,
3328, 3584, 4864, 5120, 5376, 5632, 5888, 6144, 6400, 6912, 7168, 7424,
7680, 7936, 8704, 8960, 9472, 513, 769, 1025, 1281, 1537, 1793, 2049,
2305, 2561, 2817, 3073, 3329, 3585, 5121, 5377, 5633, 5889, 6145, 7169,
7425, 7681, 7937, 8961, 9473, 9729, 2, 514, 770, 1026, 1282, 1538, 1794,
2050, 2306, 2562, 2818, 3074, 3330, 3586, 5122, 5378, 5634, 5890, 6146,
6914, 7170, 7426, 7682, 7938, 8962, 9474, 259, 515, 771, 1027, 1283,
1539, 1795, 2051, 2307, 2563, 2819, 3075, 3331, 5123, 5379, 5635, 5891,
6147, 6915, 7171, 7427, 7939, 8707, 8963, 9475, 4, 516, 772, 1028, 1284,
1540, 1796, 2052, 2308, 2564, 2820, 3076, 3332, 5124, 5380, 5636, 5892,
6148, 6916, 7172, 7428, 7940, 8452, 10244, 261, 517, 773, 1029, 1285,
1541, 2053, 2309, 2565, 2821, 3077, 3333, 5125, 5381, 5637, 5893, 6149,
6405, 6917, 7173, 7429, 7685, 7941, 8197, 9221, 774, 1030, 1286, 1542,
1798, 2054, 2310, 2566, 2822, 3078, 3334, 3590, 4614, 4870, 5126, 5382,
5638, 5894, 6150, 6918, 7 |                     |

[and some more rows]

15 rows in set, 1 warning (2.22 sec)

What can I do about that?




I didn't do a rebuild of the authority indexes.

Thank you               Beda


More information about the Koha mailing list