[Koha-bugs] [Bug 35878] New: serial.publisheddatetext should allow for more than varchar(100)

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

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