Project

General

Profile

Actions

Bug #79324

closed

PostgreSQL: ERROR: invalid byte sequence for encoding "UTF8": 0x00

Added by Morton Jonuschat over 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Must have
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2017-01-15
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Updating the session data for a flash message contains null bytes that are not allowed with PostgreSQL:

An exception occurred while executing 'UPDATE "be_sessions" SET "ses_data" = ? WHERE "ses_id" = ?' with params ["a:4:{s:26:\"formProtectionSessionToken\";s:64:\"6d6cae08447036cff41db530558a1a5555e51f3f4d5ed1b12d87d4c8f3e1f71a\";s:27:\"core.template.flashMessages\";N;s:80:\"extbase.flashmessages.tx_extensionmanager_tools_extensionmanagerextensionmanager\";a:1:{i:0;O:37:\"TYPO3\\CMS\\Core\\Messaging\\FlashMessage\":6:{s:17:\"\u0000*\u0000storeInSession\";b:1;s:10:\"\u0000*\u0000classes\";a:5:{i:-2;s:6:\"notice\";i:-1;s:4:\"info\";i:0;s:7:\"success\";i:1;s:7:\"warning\";i:2;s:6:\"danger\";}s:8:\"\u0000*\u0000icons\";a:5:{i:-2;s:11:\"lightbulb-o\";i:-1;s:4:\"info\";i:0;s:5:\"check\";i:1;s:11:\"exclamation\";i:2;s:5:\"times\";}s:8:\"\u0000*\u0000title\";s:0:\"\";s:10:\"\u0000*\u0000message\";s:95:\"Cannot deactivate extension 'bootstrap_package' - The extension(s) 'introduction' depend on it.\";s:11:\"\u0000*\u0000severity\";i:2;}}s:31:\"TYPO3\\CMS\\Recordlist\\RecordList\";a:1:{s:12:\"search_field\";N;}}", "d57ba30aec76fabfbe5987910c693016"]: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0x00 

Steps to reproduce:

1) Install Bootstrap Package via EM
2) Deinstall Bootstrap Package

Actions

Also available in: Atom PDF