Project

General

Profile

Actions

Bug #67668

closed

PostgreSQL needs escaping for BLOB fields

Added by Morton Jonuschat over 9 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-06-21
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
medium
Is Regression:
No
Sprint Focus:

Description

PostgreSQL requires data in BYTEA (BLOB) columns needs to be escaped for PostgreSQL, otherwise queries fail with:

Core: Error handler (BE): PHP Warning: pg_query(): Query failed: ERROR: invalid input syntax for type bytea LINE 9: 'O:44:"TYPO3\CMS\Extbase\Object\Container\ClassInfo":6:{... ^ in /Users/mjonuschat/Documents/Development/TYPO3/Sites/postgresql/TYPO3.CMS/typo3/sysext/adodb/adodb/drivers/adodb-postgres7.inc.php line 219

Manual
bq. The bytea type supports two external formats for input and output: PostgreSQL's historical "escape" format, and "hex" format. Both of these are always accepted on input. The output format depends on the configuration parameter bytea_output; the default is hex. (Note that the hex format was introduced in PostgreSQL 9.0; earlier versions and some tools don't understand it.)


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #67059: AdoDB error with PostgreSQLClosed2015-05-20

Actions
Related to TYPO3 Core - Epic #64459: Make TYPO3 run on PostgreSQLClosed2015-05-21

Actions
Actions #1

Updated by Susanne Moog over 9 years ago

  • Target version changed from 7.4 (Backend) to 7.5
Actions #2

Updated by Benni Mack about 9 years ago

  • Target version changed from 7.5 to 7 LTS
Actions #3

Updated by Riccardo De Contardi almost 9 years ago

  • Target version changed from 7 LTS to Candidate for Major Version
Actions #4

Updated by Morton Jonuschat about 8 years ago

  • Category changed from 999 to Database API (Doctrine DBAL)
  • Status changed from New to Closed
  • Assignee deleted (Morton Jonuschat)
  • Target version deleted (Candidate for Major Version)
Actions #5

Updated by Morton Jonuschat about 8 years ago

Solved on TYPO3 8/master by the migration to Doctrine DBAL.

Actions

Also available in: Atom PDF