Bug 35878 - serial.publisheddatetext should allow for more than varchar(100)
Summary: serial.publisheddatetext should allow for more than varchar(100)
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Serials (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-23 19:05 UTC by Lucas Gass
Modified: 2024-01-23 19:05 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lucas Gass 2024-01-23 19:05:10 UTC
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