[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]

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

Victor Grousset/tuxayo <victor at tuxayo.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Passed QA                   |Failed QA
                 CC|                            |victor at tuxayo.net

--- Comment #24 from Victor Grousset/tuxayo <victor at tuxayo.net> ---
Futher tests.

== Master ==
1.
Try to hold from the OPAC with delivery to TESTÄ/Testä or TEST✓/Test✓
=> ERROR: Internal error: incomplete hold request.
(odd, nothing in all the logs, just the HTTP request returning 200)

2.
Staff interface
set library: TESTÄ/Testä
transfer item to any another library
=> Broken FK constraint at /usr/share/perl5/Exception/Class/Base.pm line 88
Oddly it works with TEST✓/Test✓

3.
Staff interface
set library: TESTÄ/Testä
checkout an item
=> Broken FK constraint at /usr/share/perl5/Exception/Class/Base.pm line 88
Oddly it works with TEST✓/Test✓

4.
Staff interface
set library: NOT TESTÄ/Testä
checkout an item
set library: TESTÄ/Testä
partron page => checkout tab => show checkouts
try to check in
=> it's loads for ever
=> logs: Broken FK constraint at /usr/share/perl5/Exception/Class/Base.pm line
88
refresh page
The item has actually been checked in. (not sure if DB is in a consistent
state)

5.
Same but use the check in tab of the search box, next to the Koha logo

==

Does anyone know why TEST✓/Test✓ doesn't cause issue? At least it should cause
as much issues as TESTÄ/Testä.


== With patches ==
1. fails!
2. passes
3. fails!
4. passes
5. fails! (odd)

So, QA fails!

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