Project

General

Profile

Actions

Bug #91178

open

Applying needed DB change fails in BE using PostgreSQL

Added by Tobias Diekershoff over 4 years ago. Updated 4 months ago.

Status:
New
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2020-04-23
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

On Typo3 9.5.15 using PostgreSQL.

Using "Analyse Database Structure" from the Admin Tools I get the following needed change listed

ALTER TABLE "sys_file_processedfile" ALTER "configuration" TYPE BYTEA 
Current value: configuration TEXT DEFAULT NULL

When applying the change the following error is shown

Database update failed
Error: SQLSTATE[42804]: Datatype mismatch: 7 FEHLER:  Spalte »configuration« kann nicht automatisch in Typ bytea umgewandelt werden
HINT:  Sie müssen möglicherweise »USING configuration::bytea« angeben.

I followed the documented migration from a non-composer installation to composer based installation. After the migration was done, checking the DB structure I encountered this error.

PS: I hope this is the right place to report exceptions found by normal users, if not please redirect me.


Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Epic #90719: PostgreSQL related issuesAccepted2020-03-10

Actions
Actions

Also available in: Atom PDF