https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35878 Bug ID: 35878 Summary: serial.publisheddatetext should allow for more than varchar(100) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org With Bug 33039 you can define a template for serial.publisheddatetext. It can be pretty easy to go over 100 characters and cause errors. To recreate: 1 Create or edit a new subscription 2 Edit the "Publication date template" adding something like: [% USE KohaDates %] Serial seq.: [% serialseq %] Serial seq. X:[% serialseq_x %] Serial seq. Y:[% serialseq_y %] Serial seq. Z:[% serialseq_z %] Subscription ID:[% subscriptionid %] Biblionumber: [% biblionumber %] Status: [% status %] Planned date: [% planneddate | $KohaDates %] Published date: [% publisheddate | $KohaDates %] Notes: [% notes %] Routing notes: [% routingnotes %] 3 Generate the next serial and see the error: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'publisheddatetext' at row 1 at /kohadevbox/koha/Koha/Object.pm line 170 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.