Issue Bug Closed

#78591can't delete referenced files - column missing from database

Dominik Hahn 11/07/16, 13:04 updated 10/02/18, 11:06

Description

Hey guys,

whenever I try to delete a file that is in use I get this exception:
@An exception occurred while executing ‘SELECT `recuid`, `uid_foreign`, `tablenames`, `fieldname`, `sorting_foreign` FROM `sys_file_reference` WHERE `uid` = 590’: Unknown column ‘recuid’ in ‘field list’@

The problem also occurs on files that used to be referenced, even after deleting the reference.
The deletion of files that are not referenced anywhere (fresh uploads) works.

I have checked the database and the database analyzer, the column isn’t there and TYPO3 doesn’t want to create it.

I had this problem before when we were using the dev-master of TYPO3 8 but updating to TYPO3 8.3.1 didn’t resolve this.

Reviews 0

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