[Koha-bugs] [Bug 26516] New: Importing records with unexpected format of copyrightdate fails

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

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

            Bug ID: 26516
           Summary: Importing records with unexpected format of
                    copyrightdate fails
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Tools
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

Bug 11046 attempted to improve the parsing of publicationyear/copyrightdate
from marc records.

Unfortunately copyrightdate is strictly an integer field, so now adds/imports
fail if invalid data is passed

To recreate:
1 - Add a new record to Koha making sure data is valid except 260$c:
    198-
2 - Save the record
3 - It fails

DBD::mysql::st execute failed: Data truncated for column 'copyrightdate' at row
1 [for Statement "INSERT INTO biblio
        SET frameworkcode = ?,
            author = ?,
            title = ?,
            subtitle = ?,
            medium = ?,
            part_number = ?,
            part_name = ?,
            unititle =?,
            notes = ?,
            serial = ?,
            seriestitle = ?,
            copyrightdate = ?,
            datecreated=NOW(),
            abstract = ?
        " with ParamValues: 0='', 1=undef, 2="This record", 3=undef, 4=undef,
5=undef, 6=undef, 7=undef, 8=undef, 9=0, 10=undef, 11="198-", 12=undef] at
/kohadevbox/koha/C4/Biblio.pm line 2745.
ERROR in _koha_add_biblio INSERT INTO biblio

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