Bug 25385

Summary: When cataloguing a too long barcode, Koha explodes or silently cuts it at 20 characters
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: CatalogingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: jonathan.druart, m.de.rooy
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24535
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25386
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Katrin Fischer 2020-05-06 06:18:20 UTC
We don't validate for length in the forms and this can lead to bad errors especially for users new to Koha:

To test:
- Edit any item in your catalog
- Change the barcode to be longer than 20 characters
- Save
- You see en arror message:

DBIx::Class::Storage::DBI::_dbh_execute(): Data too long for column 'barcode' at row 1 at /home/vagrant/kohaclone/Koha/Object.pm line 164
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77
Comment 1 Katrin Fischer 2020-05-06 06:32:39 UTC
When not using strict, there is no error, the barcode will be silently "cut" to 20 characters.