[Koha-bugs] [Bug 28328] Editing a record can cause an ISE if data too long for column

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328

--- Comment #3 from Jan Kissig <bibliothek at th-wildau.de> ---
The same problem for columns publishercode or place obtained from MARC 264$b
and $a or 260$a and $b


to reproduce 
1 - edit or add new biblio
2 - in 264$a enter f.e.
"1averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext84
|
2averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext84
|
3averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylongtext847"
3 - fill in other mandatory fields
4 - save


/var/log/koha/kohadev/plack-intranet-error.log says
[2023/04/12 08:27:52] [WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI
Exception: DBD::mysql::st execute failed: Data too long for column 'place' at
row 1 at /kohadevbox/koha/Koha/Object.pm line 176

As 260/264 $a and $c are repeatable fields, which get joined, it is not
uncommon that they exceed the maximal length of 256 in some of my records

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.