Summary: | Cannot rebuild zebra | ||
---|---|---|---|
Product: | Koha | Reporter: | Chaminda de Silva <chimesh> |
Component: | bugs.koha-community.org | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED WORKSFORME | QA Contact: | Testopia <testopia> |
Severity: | major | ||
Priority: | P5 - low | CC: | dcook |
Version: | 22.05 | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Bug Depends on: | 15187 | ||
Bug Blocks: |
Description
Chaminda de Silva
2022-10-28 10:30:49 UTC
It looks like you've got bad data there in your record. Can you share a URL to that record? (In reply to David Cook from comment #1) > It looks like you've got bad data there in your record. > > Can you share a URL to that record? 1. How to findout the URL of the particulaar record. (In reply to Chaminda de Silva from comment #2) > 1. How to findout the URL of the particulaar record. Do you mean how do you determine which record is causing the problem? You'll need to do a SQL Report. You could try something like the following: SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="880" and subfield[@code="6" and substring(text(),1,3)="24 "]]/*') as f880 from biblio_metadata HAVING f880 <> '' Do you have a public OPAC? If you can provide the URL to that OPAC, I can lookup the records once you've given me a biblionumber. (As a side note: I'd copied the regex for this from the Elasticsearch code, but really we should've written it at as "(\d\d\d)" rather than "(...)".) (In reply to David Cook from comment #3) > (In reply to Chaminda de Silva from comment #2) > > 1. How to findout the URL of the particulaar record. > > Do you mean how do you determine which record is causing the problem? > > You'll need to do a SQL Report. > > You could try something like the following: > > SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="880" and > subfield[@code="6" and substring(text(),1,3)="24 "]]/*') as f880 from > biblio_metadata HAVING f880 <> '' > > Do you have a public OPAC? If you can provide the URL to that OPAC, I can > lookup the records once you've given me a biblionumber. Thank you very much David, I figured out the problem of Tag "24 " is not a valid tag using your SQL Query. It should be Tag "245" not Tag "24 ". (In reply to Chaminda de Silva from comment #5) > Thank you very much David, I figured out the problem of Tag "24 " is not a > valid tag using your SQL Query. It should be Tag "245" not Tag "24 ". I thought that's what I was saying in my 1st comment. Apologies that I wasn't clearer! Glad you were able to sort it out. Katrin, do you think this should be closed? On one hand, failing to reindex due to one bad record seems suboptimal. On the other hand, if it just warns or silences the error, then it's not obvious there is a problem. That's ok for me, glad it could be resolved. When I tagged you I was not sure if it was related to the recent work on 880 indexing. |