#91178Applying needed DB change fails in BE using PostgreSQL
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