[Koha-bugs] [Bug 28328] New: Editing a record can cause an ISE if data too long for column

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

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: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

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.