From 8fb54973d1fbc3de860953602a5e9c63b6f0d0a9 Mon Sep 17 00:00:00 2001 From: Julian Maurice 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 0 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 Signed-off-by: Andrew Nugged Signed-off-by: David Cook --- .../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