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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
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/
