Dear Frédéric, Thank you very much for the quick fix. It worked just fine! Is there a way to predict, which unicode character will break the code? Best, Marc Frederic Demians schrieb:
On koha 3.0.3 we edited a title of a record, inserting the following unicode charachter 𡼱 [it's a rare Chinese character][Decimal: 139057; UTF-8: F0 A1 BC B1] from unicode.org. In the input field it looked just fine. But after saving the record, we got a fatal error message and the record became inaccesible. Under the old title it is still searchable (intranet and OPAC), but if you follow the respective links, you get invariably the following error messages:
I can confirm this bug. This character break marcxml biblioitems table field: field content stops a this character and so XML marc document can't be parsed anymore.
And last but not least, how can I delete or access the compromised record again?
It's not possible to recreate by hand such a corrupted xml marc record. You have to delete the record identified by its biblionumber in your MySQL DB:
DELETE FROM biblio WHERE biblionumber=x DELETE FROM biblioitems WHERE biblionumber=x DELETE FROM items WHERE biblionumber=x
And then rebuild zebra indexes : rebuild_zebra -r -b
-- Frédéric