Show title of file metadata in frontend
I have 10 images without a title assigned in filelist module and I have used each of these images 20 times on my website. This will result in 200 sys_file_reference records in database without any title as I have not set a title for each file reference.
Now, I want to optimize my website for SEO. It would be good to add title, alt and description for my images. Instead of editing 200 reference records I just go to filelist and edit this data directly in my 10 images. But TYPO3 still does not render this title.
Currently I have to open each reference record and deactivate the Checkbox "Set element specific value (Default: "MyTitle")", which I have never set.
Do you know an easier way? Is this a TYPO3 bug?
Updated by Philipp Parzer over 3 years ago
Temporary workaround via SQL:
UPDATE sys_file_reference AS ref
JOIN sys_file AS file ON ref.uid_local = file.uid
JOIN sys_file_metadata AS meta ON meta.file = file.uid
SET ref.title = NULL
WHERE ref.tablenames LIKE 'tt_content' AND ref.fieldname LIKE 'media' AND ref.table_local LIKE 'sys_file' AND ref.title LIKE '' AND meta.title IS NOT NULL;