Bugzilla – Attachment 121650 Details for
Bug 28489
CGI::Session is incorrectly serialized to DB in production env / when strict_sql_modes = 0
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28489: Modify sessions.a_session from longtext to longblob
Bug-28489-Modify-sessionsasession-from-longtext-to.patch (text/plain), 1.77 KB, created by
David Cook
on 2021-06-07 02:27:40 UTC
(
hide
)
Description:
Bug 28489: Modify sessions.a_session from longtext to longblob
Filename:
MIME Type:
Creator:
David Cook
Created:
2021-06-07 02:27:40 UTC
Size:
1.77 KB
patch
obsolete
>From 8fb54973d1fbc3de860953602a5e9c63b6f0d0a9 Mon Sep 17 00:00:00 2001 >From: Julian Maurice <julian.maurice@biblibre.com> >Date: Wed, 2 Jun 2021 16:05:17 +0200 >Subject: [PATCH] Bug 28489: Modify sessions.a_session from longtext to > longblob >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >This column contains serialized data, it should be a blob. >And it fixes encoding issues. > >Test plan: >1. Apply patch and run updatedatabase >2. In $KOHA_CONF make sure that you have > <strict_sql_modes>0</strict_sql_modes> >3. Create 2 libraries: > a. TESTÃ/Testä > b. TESTâ/Testâ >4. Go to the staff interface, change your library to Testä, then > navigate to a few other pages, make sure there is no encoding problem > with the library name in the top right corner >5. Do the same with Testâ > >Signed-off-by: Petro Vashchuk <stalkernoid@gmail.com> >Signed-off-by: Andrew Nugged <nugged@gmail.com> > >Signed-off-by: David Cook <dcook@prosentient.com.au> >--- > .../mysql/atomicupdate/sessions-from-longtext-to-longblob.perl | 8 ++++++++ > 1 file changed, 8 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/sessions-from-longtext-to-longblob.perl > >diff --git a/installer/data/mysql/atomicupdate/sessions-from-longtext-to-longblob.perl b/installer/data/mysql/atomicupdate/sessions-from-longtext-to-longblob.perl >new file mode 100644 >index 0000000000..0ddca85b5a >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/sessions-from-longtext-to-longblob.perl >@@ -0,0 +1,8 @@ >+$DBversion = 'XXX'; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do('DELETE FROM sessions'); >+ $dbh->do('ALTER TABLE sessions MODIFY a_session LONGBLOB NOT NULL'); >+ >+ NewVersion( $DBversion, '28489', >+ 'Modify sessions.a_session from longtext to longblob' ); >+} >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 28489
:
121539
|
121541
|
121563
|
121564
|
121565
|
121570
|
121571
|
121584
|
121585
|
121624
|
121637
|
121638
|
121639
|
121640
|
121648
|
121650
|
121651
|
121652
|
121653
|
121654
|
121831
|
121832
|
121833
|
121834
|
121835
|
121848
|
121849
|
121850
|
121851
|
121852