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

Sam Lau <sama...@gmail.com> changed:

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

--- Comment #10 from Sam Lau <sama...@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 <sama...@gmail.com>

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to