https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328
Bug ID: 28328
Summary: Editing a record can cause an ISE if data too long for
column
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Cataloging
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Like bug 26518, but for ModBiblio
To recreate:
1 - Edit a record in the staff client
2 - In MARC21 edit the 010a/LCCN field wih:
ThisisgoingtobetoomanycharactersfortheLCCNfield
3 - Save the record
4 - ISE:
C4::Biblio::_koha_modify_biblioitem_nonmarc(): DBI Exception: DBD::mysql::st
execute failed: Data too long for column 'lccn' at row 1 [for Statement "UPDATE
biblioitems
SET biblionumber = ?,
volume = ?,
number = ?,
itemtype = ?,
isbn = ?,
issn = ?,
publicationyear = ?,
publishercode = ?,
volumedate = ?,
volumedesc = ?,
collectiontitle = ?,
collectionissn = ?,
collectionvolume= ?,
editionstatement= ?,
editionresponsibility = ?,
illus = ?,
pages = ?,
notes = ?,
size = ?,
place = ?,
lccn = ?,
url = ?,
cn_source = ?,
cn_class = ?,
cn_item = ?,
cn_suffix = ?,
cn_sort = ?,
totalissues = ?,
ean = ?,
agerestriction = ?
where biblioitemnumber = ?
" with ParamValues: 0="4239", 1=undef, 2=undef, 3="BK", 4="0887080189",
5=undef, 6=undef, 7="Neugebauer Press USA ; | Distributed by Alphabet Press,",
8=undef, 9=undef, 10=undef, 11=undef, 12=undef, 13=undef, 14=undef, 15="col.
ill. ;", 16="[30] p. :", 17=undef, 18="30 cm.", 19="[S.l.] : | Natick, MA :",
20="83181009sdhgaethq45y245y24thsadhgahq", 21=undef, 22="ddc", 23=undef,
24=undef, 25=undef, 26='', 27=undef, 28=undef, 29=undef, 30='4239'] at
/kohadevbox/koha/C4/Biblio.pm line 384
at /usr/share/perl5/DBIx/Class/Exception.pm line 77
This also kills the linker script if a bib with too long lccn is encountered
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
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/
