[Koha] Zebra troubles after upgrading from 2.2

[Tom Francart]

On Thu, Jul 12, 2012 at 11:45 AM, Chris Cormack
<chris at bigballofwax.co.nz> wrote:
> On 12 July 2012 20:18, Tom Francart <francart at gmail.com> wrote:
>> On Thu, Jul 12, 2012 at 10:12 AM, Chris Cormack
>> <chris at bigballofwax.co.nz> wrote:
>>> On 12 July 2012 19:46, Tom Francart <francart at gmail.com> wrote:
>>>> On Thu, Jul 12, 2012 at 9:27 AM, Chris Cormack <chris at bigballofwax.co.nz> wrote:
>>>>> On 12 July 2012 19:16, Tom Francart <francart at gmail.com> wrote:
>>>>>> Dear all,
>>>>>>
>>>>>> We've just upgraded from Koha 2.2 to Koha 3.8 and are having troubles
>>>>>> searching with zebra.
>>>>>>
>
>>
>> Hi Chris,
>>
>> Here's the output with the vv switch.
>
> Here's the salient bit
>
> log] Records: 0 i/u/d 0/0/0
>
> No items inserted, updated or deleted. So zebra is being given nothing
> it can index, it looks to me like your upgrade didn't work well, and
> the records are not complete.
>
> Do you have mysql access, can you do select marc,marcxml from
> biblioitems where biblionumber = 669
>
> And take a look at it, i suspect it is missing the 999 field, if not a lot more.
>
> Chris

Hi Chris,

First of all, thank you very much for taking the time to help us.

That query returns no records. In table biblioitems, biblionumber goes
only up to 667.

Most records have the marcxml field set, but I haven't found any that
contain the 999 field. Additionally, records 663-667 have an empty
marcxml field.

What would be the best way to fix it? I still have the original Koha 2
database. Removing biblioitems 663-667 and re-addng them to the
library wouldn't be a problem either.

best regards,
Tom