[Koha-bugs] [Bug 28489] CGI::Session is incorrectly serialized to DB in production env / when strict_sql_modes = 0

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon May 31 10:21:04 CEST 2021


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

--- Comment #1 from Joonas Kylmälä <joonas.kylmala at helsinki.fi> ---
Relating to this is another bug but it only happens with strict_sql_modes = 1,
so if we come up with a fix for this we should make sure it handles this case
as well.

The other issue is:

> CGI::Session::Driver::mysql::store(): DBI Exception: DBD::mysql::db do
> failed: Incorrect string value: '\xE4iskap...' for column
> `koha_kohadev`.`sessions`.`a_session` at row 1 [for Statement "INSERT INTO
> sessions (id, a_session) VALUES(?, ?) ON DUPLICATE KEY UPDATE a_session =
> ?"] at /usr/share/perl5/CGI/Session.pm line 251
>  at /usr/share/perl5/DBIx/Class/Exception.pm line 77

This happens when trying to to set on the page
/cgi-bin/koha/circ/set-library.pl the active branch another time to what is
selected already AND the branch display contains an "ä" character.

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


More information about the Koha-bugs mailing list