[BUGFIX] Use BLOB type column for uc in be_users table 93/51393/3
authorManuel Selbach <manuel_selbach@yahoo.de>
Sun, 22 Jan 2017 06:23:30 +0000 (22:23 -0800)
committerGeorg Ringer <georg.ringer@gmail.com>
Wed, 25 Jan 2017 08:27:46 +0000 (09:27 +0100)
The unified handling for frontend and backend users requires
identical SQL column types to properly escape the input data.
Using binary encoding for the uc column in combination with a
TEXT type field in the BE fails on PostgreSQL.

Resolves: #79451
Related: #79324
Releases: master
Change-Id: I08e404ca7050aa169234a4542ffa640cad2cd1ff
Reviewed-on: https://review.typo3.org/51393
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Manuel Selbach <manuel_selbach@yahoo.de>
Tested-by: Manuel Selbach <manuel_selbach@yahoo.de>
Reviewed-by: Georg Ringer <georg.ringer@gmail.com>
Tested-by: Georg Ringer <georg.ringer@gmail.com>

index cec33c8..60b2356 100644 (file)
@@ -73,7 +73,7 @@ CREATE TABLE be_users (
        realName varchar(80) DEFAULT '' NOT NULL,
        userMods text,
        allowed_languages varchar(255) DEFAULT '' NOT NULL,
-       uc mediumtext,
+       uc mediumblob,
        file_mountpoints text,
        file_permissions text,
        workspace_perms tinyint(3) DEFAULT '1' NOT NULL,