Bug #80916

Show title of file metadata in frontend

Added by Stefan Froemken about 2 years ago. Updated about 2 months ago.

Status:
New
Priority:
Should have
Assignee:
Category:
Fluid Styled Content
Start date:
2017-04-20
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

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

History

#1 Updated by Benni Mack about 2 years ago

  • Target version changed from 8 LTS to next-patchlevel

#2 Updated by Philipp Parzer over 1 year 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;

#3 Updated by Benni Mack about 2 months ago

  • Target version changed from next-patchlevel to Candidate for patchlevel

Also available in: Atom PDF