Bug 26853: Harmonize import_biblios with biblio and biblioitems
authorDavid Cook <dcook@prosentient.com.au>
Thu, 29 Oct 2020 05:20:53 +0000 (05:20 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Mon, 16 Nov 2020 19:07:31 +0000 (19:07 +0000)
commit3d554f7ff6b0c76ae674893fcbf0273c80885815
tree0da82c1a47e896ad225f6fe73a40238e46346a07
parent493e62aad82931304bdcf2c63152451aed781b16
Bug 26853: Harmonize import_biblios with biblio and biblioitems

This patch harmonizes the column datatypes of import_biblios
with biblio and biblioitems to prevent database errors which cause
staged MARC uploads to sometimes fail to update 100% correctly.

To test:
1. Go to http://localhost:8081/cgi-bin/koha/tools/stage-marc-import.pl
2. Upload a file with MARC records with titles longer than 128
characters long
3. Click "Stage for import"
4. Monitor /var/log/koha/kohadev/intranet-error.log for
database errors
5. Note that there are no database errors

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit e39b9684d5cd0ce15a3d1f07d7691b832309287b)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/atomicupdate/001-26853-update-import_biblios.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql