[Koha-bugs] [Bug 27730] Innocent changes to framework silently delete bibliographic data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27730

--- Comment #3 from Ian Bays <ian.bays at ptfs-europe.com> ---
Hi. The initial description includes a test plan that shows "ignore" deletes
metadata. This was tested on recent versions including 20.11, but for
completeness I went back to a 17.11 version and used a simpler method to verify
the behaviour:

We often set up a framework for (say) BK that sets (eg) the 022$a to ignore so
I first checked this was the case on the system, then added a bib in the
default framework and added an 022$a. I checked the biblio_metadata and it was
present.  I edited the record and changed frameworkcode from default to BK and
saved. On inspection the 022$a has not present.  Here is the SQL from this
sequence:

MariaDB [koha_ras]> select metadata from biblio_metadata where biblionumber =
37441;
| <?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim
http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>00242nam a22001217a 4500</leader>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">37441</subfield>
    <subfield code="d">37441</subfield>
  </datafield>
  <controlfield tag="003">OSt</controlfield>
  <controlfield tag="005">20210323092844.0</controlfield>
  <controlfield tag="008">210323b           ||||| |||| 00| 0 eng
d</controlfield>
  <datafield tag="022" ind1=" " ind2=" ">
    <subfield code="a">1234</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Test</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Test</subfield>
  </datafield>
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="2">ddc</subfield>
    <subfield code="c">MONO</subfield>
  </datafield>
</record>
 |

MariaDB [koha_ras]> select frameworkcode from biblio where biblionumber =
37441;
+---------------+
| frameworkcode |
+---------------+
|               |
+---------------+

MariaDB [koha_ras]> select tab from marc_subfield_structure where frameworkcode
= '' and tagfield='022' and tagsubfield = 'a';
+------+
| tab  |
+------+
|    0 |
+------+

MariaDB [koha_ras]> select frameworkcode from biblio where biblionumber =
37441;
+---------------+
| frameworkcode |
+---------------+
| BK            |
+---------------+

MariaDB [koha_ras]> select tab from marc_subfield_structure where frameworkcode
= 'BK' and tagfield='022' and tagsubfield = 'a';
+------+
| tab  |
+------+
|   -1 |
+------+

MariaDB [koha_ras]> select metadata from biblio_metadata where biblionumber =
37441;
| <?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim
http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>00216nam a22001097a 4500</leader>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">37441</subfield>
    <subfield code="d">37441</subfield>
  </datafield>
  <controlfield tag="003">OSt</controlfield>
  <controlfield tag="005">20210323094228.0</controlfield>
  <controlfield tag="008">210323b           ||||| |||| 00| 0 eng
d</controlfield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Test</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Test</subfield>
  </datafield>
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="c">MONO</subfield>
  </datafield>
</record>
 |
1 row in set (0.00 sec)

MariaDB [koha_ras]> select value from systempreferences where variable like
'%version%';
+------------+
| value      |
+------------+
| 17.1109000 |
+------------+

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.