TYPO3 Core

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;

Stefan Froemken wrote:

1
down vote
favorite

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?

Stefan

Link: http://stackoverflow.com/questions/43495223/show-title-of-file-metadata-in-frontend/43496142?noredirect=1#comment74082783_43496142

Hey,

I am new, but I can't say it's a bug, Let me quickly comeup with solution, Sorry for replying you without the solution.

Let me quicker hit inside this procedure; Will get back to you with the suggestion.