http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692017-05-04T17:47:38ZTYPO3 ForgeTYPO3 Core - Bug #80916: Show title of file metadata in frontendhttp://forge.typo3.org/issues/80916?journal_id=3320432017-05-04T17:47:38ZBenni Mackbenni@typo3.org
<ul><li><strong>Target version</strong> changed from <i>8 LTS</i> to <i>next-patchlevel</i></li></ul> TYPO3 Core - Bug #80916: Show title of file metadata in frontendhttp://forge.typo3.org/issues/80916?journal_id=3417732017-10-06T17:23:11ZPhilipp Parzer
<ul></ul><p><strong>Temporary workaround via SQL:</strong></p>
<p>UPDATE sys_file_reference AS ref<br />JOIN sys_file AS file ON ref.uid_local = file.uid<br />JOIN sys_file_metadata AS meta ON meta.file = file.uid<br />SET ref.title = NULL<br />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;</p> TYPO3 Core - Bug #80916: Show title of file metadata in frontendhttp://forge.typo3.org/issues/80916?journal_id=3984012019-04-17T23:41:04ZBenni Mackbenni@typo3.org
<ul><li><strong>Target version</strong> changed from <i>next-patchlevel</i> to <i>Candidate for patchlevel</i></li></ul> TYPO3 Core - Bug #80916: Show title of file metadata in frontendhttp://forge.typo3.org/issues/80916?journal_id=4807372022-11-14T14:31:03ZVinay Singh
<ul></ul><p>Stefan Froemken wrote:</p>
<blockquote>
<p>1<br />down vote<br />favorite</p>
<p>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.</p>
<p>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.</p>
<p>Currently I have to open each reference record and deactivate the Checkbox "Set element specific value (Default: "MyTitle")", which I have never set.</p>
<p>Do you know an easier way? Is this a TYPO3 bug?</p>
<p>Stefan</p>
<p>Link: <a class="external" href="http://stackoverflow.com/questions/43495223/show-title-of-file-metadata-in-frontend/43496142?noredirect=1#comment74082783_43496142">http://stackoverflow.com/questions/43495223/show-title-of-file-metadata-in-frontend/43496142?noredirect=1#comment74082783_43496142</a></p>
</blockquote>
<p>Hey,</p>
<p>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.</p>
<p>Let me quicker hit inside this procedure; Will get back to you with the suggestion.</p>