Bug #79324
closedPostgreSQL: ERROR: invalid byte sequence for encoding "UTF8": 0x00
100%
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
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
Updated by Morton Jonuschat over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset b63380469eda45f23a28dfe7a19c58c0b9b943c8.
Updated by Dan Kleine (Untenzu) about 7 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.
Updated by Riccardo De Contardi almost 7 years ago
- Status changed from Resolved to Closed