[Koha-bugs] [Bug 34029] Import breaks when data exceeds size of mapped database columns

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

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

Sam Lau <samalau at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #152418|0                           |1
        is obsolete|                            |

--- Comment #10 from Sam Lau <samalau at gmail.com> ---
Created attachment 152490
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152490&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

Signed-off-by: Sam Lau <samalau at gmail.com>

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