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@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@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.