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 #1

Updated by Gerrit Code Review over 7 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51314

Actions #2

Updated by Morton Jonuschat over 7 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #3

Updated by Dan Kleine (Untenzu) over 6 years ago

We had this issue as well, using TYPO3 7.6 with PostgreSQL. Whenever a user tried to delete an image the session was lost. This is because one place writes a different session string into the database, then it is originally. So use deleted the image, session is stored, new page in fileadmin is opend, trying to show a flash message, flash message checks the session (which was stored wrongly), detects an errors and throws an exception.

The given patch for version 8.7 is fixing the problem in 7.6 as well. So I just pushed a backport of this patch for version 7.6.

https://review.typo3.org/#/c/53652/

Actions #4

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF