Issue Bug New Orphaned

#91178Applying needed DB change fails in BE using PostgreSQL

Tobias Diekershoff 04/23/20, 12:09 updated 07/31/24, 08:44

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". How to create a patch

Commit message
[BUGFIX] Applying needed DB change fails in BE using PostgreSQL Resolves: #91178 Releases: main