[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 #16 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Jan Kissig from comment #3)
> 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.
> "1averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylon
> gtext84 |
> 2averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylong
> text84 |
> 3averylongtextaverylongtextaverylongtext42averylongtextaverylongtextaverylong
> text847"
> 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

Hi Jan, please see bug 34029. Trying to get rid of those problems for good.

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