Issue Bug Closed

#90760Link validator throws exception with Page TSConfig configuration on sys_file_reference

Riccardo De Contardi 03/14/20, 12:13 updated 04/01/20, 21:15

Description

I performed the following operation with the latest version TYPO3 10.4.0-dev (latest master)

Info > link validator > check links

It threw an exception:

(1/2) Doctrine\DBAL\Exception\InvalidFieldNameException
An exception occurred while executing 'SELECT `uid`, `pid`, `uid_local`, `link`, `sys_language_uid`, `uid_local:type` FROM `sys_file_reference` WHERE (`pid` IN (?)) AND ((`sys_file_reference`.`deleted` = 0) AND (`sys_file_reference`.`hidden` = 0))' with params [307]: Unknown column 'uid_local:type' in 'field list'

I tried to clear all caches from install tool, updated db schema and dump php autoload without success

[UPDATE]: I’ve found that params [307]: refers to the page I am when I start the link validator

[UPDATE 2]

the cause of the error was a page TSConfig configuration:

mod.linkvalidator.searchFields.sys_file_reference = link

Environment: MAMP 5.5 on MAC

PHP version: 7.2.21
MySQL version: 5.7.26

Let me know if you need further information or if you think that this issue should be closed

Reviews 1