[TYPO3-english] Re: Upgrade 4.6 to 6.2.3 - Update sys_refindex table

[Christoph Ascherl]

Meanwhile I did upgrades from TYPO3 4.7 to 6.2 for three times and every time I run into this problem.
Reason are links in content elements of hidden or (from database point of view: logical) deleted pages where the targed (usually the file in fileadmin) does not exist anymore. 
cli_dispatch.phpsh lowlevel_refindex -c 
does not detect these broken links.

I found this solution which requires using a SQL client for the mysql database:
check if the result of this query matches the list of "Reference index was probably out of date" elements
select * from sys_refindex where softref_key = 'typolink_tag' AND ref_table = '_FILE';

If so you can update these records:
update sys_refindex set softref_key = 'typolink' where softref_key = 'typolink_tag' AND ref_table = '_FILE';

I never used templavoila so this could require additional analysis.