[Koha-bugs] [Bug 34029] Import breaks when data exceeds size of mapped database columns
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 16 16:26:45 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34029
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #152417|0 |1
is obsolete| |
--- Comment #6 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 152418
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152418&action=edit
Bug 34029: Extend datatypes of biblioitems.columns to longtext to avoid
breaking import
This updated the datatype of the following columns from varchar(255) to
longtext
to avoid import problems if the mapped MARC field's data exceeds 255
characters.
This is for:
* place (260$a and 264$a)
* publishercode (260$b and 264$b)
* size (300$c)
* illus (300$b)
* pages (300$a)
To test:
* Edit a bibliographic record and enter more than 255 characters into
the MARC fields listed above. Try to save.
* Run the updatedatabase script to modify the DB structure
* restart_all
* Edit a bibliographic record and enter more than 255 characters into
the MARC fields listed above.
* Save
* Export the record
* Import the record using staging tools, all should work well
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list