https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |40777 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40777 [Bug 40777] 500 Error: Something went wrong when loading the table Should Exit Cleanly -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 --- Comment #1 from Fridolin Somers <fridolin.somers@biblibre.com> --- Created attachment 200422 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200422&action=edit Bug 42846: Koha::Database::DataInconsistency fix typo for biblioitemnumber in MARC Check of biblioitemnumber in MARC uses $biblionumber instead of $biblioitemnumber It returns for example : Biblionumber 542620 has biblioitemnumber '542620' but should be '542620' in 090$a Test plan (for MARC21 only) : 1) Choose a biblio record id=X 2) Change with SQL : update biblio_metadata set metadata = UpdateXML( metadata , '//datafield[@tag="999"]/subfield[@code="d"]' , CONCAT('<subfield code="d">1111</subfield>') ) where biblionumber = X 3) Run audit on this record 4) Check message is correct -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #200422|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com --- Comment #3 from David Nind <david@davidnind.com> --- Testing notes (using KTD, MARC21 instance): 1. Updated MARC for record 262 (Programming Perl) with one item (39999000011418, item number = 578) using the SQL in the test plan. 2. Error message before the patch: Biblionumber 262 has biblioitemnumber '262' but should be '262' in 999$d 3. Error message after the patch: Biblionumber 262 has biblioitemnumber '1111' but should be '262' in 999$d I find the message confusing, because 'biblioitemnumber' looks wrong to me. The record number (biblionumber) is 262, but the item number (itemnumber) is 578. What happens when there are multiple items for a record. Or is the 999$d something else? Normally when we say biblioitemnumber, we are referring to the database id for the individual item(?). Or is this just something weird in MARC21 and makes much more sense with UNIMARC? -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA QA Contact|testopia@bugs.koha-communit |jonathan.druart@gmail.com |y.org | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 --- Comment #5 from Jonathan Druart <jonathan.druart@gmail.com> --- Created attachment 200726 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200726&action=edit Bug 42846: Koha::Database::DataInconsistency fix typo for biblioitemnumber in MARC Check of biblioitemnumber in MARC uses $biblionumber instead of $biblioitemnumber It returns for example : Biblionumber 542620 has biblioitemnumber '542620' but should be '542620' in 090$a Test plan (for MARC21 only) : 1) Choose a biblio record id=X 2) Change with SQL : update biblio_metadata set metadata = UpdateXML( metadata , '//datafield[@tag="999"]/subfield[@code="d"]' , CONCAT('<subfield code="d">1111</subfield>') ) where biblionumber = X 3) Run audit on this record 4) Check message is correct Signed-off-by: David Nind <david@davidnind.com> Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42846 --- Comment #6 from Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> --- Thanks everyone! Pushed to main for 26.11! -- You are receiving this mail because: You are watching all bug changes.