Bugzilla – Attachment 121849 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 (kohastructure.sql)
Bug-28489-Modify-sessionsasession-from-longtext-to.patch (text/plain), 1.20 KB, created by
Jonathan Druart
on 2021-06-11 14:05:13 UTC
(
hide
)
Description:
Bug 28489: Modify sessions.a_session from longtext to longblob (kohastructure.sql)
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2021-06-11 14:05:13 UTC
Size:
1.20 KB
patch
obsolete
>From 2ddedca369049b802b954b92fda6325e39fb7cb2 Mon Sep 17 00:00:00 2001 >From: Julian Maurice <julian.maurice@biblibre.com> >Date: Thu, 3 Jun 2021 11:28:57 +0200 >Subject: [PATCH] Bug 28489: Modify sessions.a_session from longtext to > longblob (kohastructure.sql) > >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> > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 900d8cf0850..e9b12d6898b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4580,7 +4580,7 @@ DROP TABLE IF EXISTS `sessions`; > /*!40101 SET character_set_client = utf8 */; > CREATE TABLE `sessions` ( > `id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, >- `a_session` longtext COLLATE utf8mb4_unicode_ci NOT NULL, >+ `a_session` longblob NOT NULL, > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; >-- >2.20.1
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